Forums  ›  Career Advice  ›  Interview Tips
 

Interview Preparation for SQL & PL/SQL

SQL & PL/SQL Sitemap Index:

 You can Study SQL & PL/SQL using this forum you can also revise your knowledge using this forum & you can also prepare for your Interview using this forum kindly note there are interview questions with answer in this forum check for interview question in the index below for the same. 

Dear Members anyone who want's to participate in the forum or have any question please post them in the relevant topic below from the Index in case if the topic you needed to discus is not available then you can create a new post over here. Click here

Kindly Note: In order to participate & discuss in this forum you must join the Group  Oracle SQL & PL/SQL

SQL Server / Oracle SQL

 SQL Introduction 


 SQL Syntax 


 SQL Select 


 SQL Insert 


 SQL Update 


 SQL Delete 


 SQL Joins 


 SQL Inner Join

 SQL Outer Join
 

 SQL Left Join

 SQL Right Join
 

 SQL Self Join

 SQL Equi Joins
 

 SQL Join Using Multiple Tables
 

 SQL Full Join


 SQL Explicit vs. Implicit Joins 


 SQL Group By 
 

 Null Values in SQL Group By


 SQL Having 


 SQL - IN 


 SQL - NULLs 


 Functional Dependencies 


 Normalization 


 ACID Properties 


 SQL SubQueries
 

 SQL Views 


 Insert, Update, Delete Views


 SQL Join Views 


 SQL Inline Views 


 SQL - Nth Highest Salary

 
 SQL Second Highest Salary 


 SQL - Difference Truncate / Delete 


 SQL - Difference Truncate / Drop 


 SQL - Difference HAVING / WHERE 


 SQL - Difference CAST / CONVERT 


 SQL - Difference NOT IN / NOT EXIST 


 SQL - Difference IN / EXISTS 


 SQL - Difference UNION / UNION ALL 


 SQL - Difference Nested / Correlated Subquery 


 SQL - REPLACE 


 SQL - TOP 


 SQL - LIKE 


 SQL - SELECT INTO 


 SQL - CREATE TABLE 


 SQL - ALTER TABLE 


 SQL - Difference views / Materialized views 


 SQL Count 


 SQL Update 


 SQL Clustered / Non-Clustered Indexes 


 SQL - Delete Duplicate Records 


 SQL - Difference Unique/Primary Key 


 SQL - GETDATE() 


 SQL - DATEDIFF() 


 SQL - DATEADD() 


 SQL - DATEPART() 


 SQL - Convert() 


 SQL - SUM() 


 SQL - AVG() 


 SQL - MIN() 


 SQL - MAX() 


 SQL - Insert Into Select 


 SQL - Insert Multiple Values In Table 


 SQL - Referential Integrity 


 SQL - Not Null Constraint

 
 SQL - Unique Constraint 


 SQL - Primary Key Constraint 


 SQL - Foreign Key Constraint 


 SQL - Default Constraint 


 SQL - Check Constraint 


 SQL - ROLLUP 


 SQL - CUBE
 

 SQL - Difference between Rollup / Cube


 SQL - STUFF() 


 SQL - Count_Big 


 SQL - Binary_Checksum 


 SQL - Checksum_AGG 


 SQL - Index Include 


 SQL - Covered Query 


 SQL - Identity 


 SQL - sp_columns

 
 SQL - Diff Local/Global Temporary Tables 


 SQL - Stored Procedure 


 SQL - sp_who 


 SQL - Session 


 SQL - Dynamic SQL

 
 SQL - SQL Server Execution Plan 


 SQL - sp_executesql 


 SQL - Difference Execute/Execute() 


 SQL - Case Expression 


 SQL - XML Variable Example


 SQL - Pivot 


 SQL - Merge 


 Example of Merge Output Clause 


 SQL - Compute / Compute by 


 SQL - Diff SCOPE_IDENTITY / IDENT_CURRENT / @@IDENTITY 


 SQL Coalesce 


 SQL - Import Data into SQL Server Table 


 SQL - Delete Duplicate Records in SQL Server Table 

 SQL - Delete Duplicate Rows


 SQL - Check If a Column Exists in SQL Server Table


 SQL - Has_perms_by_name 


 SQL - Difference between Logins / Users 


 SQL - Diff between Table Variable/Temp Table 

 
 SQL - SERVERPROPERTY 


 SQL - Find Primary Key / Foreign Key in Table 


 SQL - Sequence 


 SQL - Columnstore Indexes 


 SQL - Difference Primary / Candidate Key 


 SQL - Throw 


 SQL - Difference GUID / INT


 SQL Server 2012 Enhancements 


 SQL - Diff between Cross Join / Full Outer Join 


 SQL - NTILE() 


 SQL - Object Dependencies 


 SQL - Email Reminder on Updating Table 


 SQL - Object Definition 


 SQL Server - Report Builder 3 


 SQL Server - User Defined Roles 


 SQL Server - Filetables 


 SQL Server - Contained Databases 


 SQL Server - Update from Select 


 SQL Server - XML Methods 


 SQL Server - Add a Column to Table 


 SQL Server - Insert Multiple Rows 


 SQL Server - Add Identity Column to Table 


 SQL Server - Indexes 


 SQL Server - Diff Functions / Stored Procedures 


 SQL - Comparison Operators Any / All 


 SQL - Difference Primary / Foreign Key 


 SQL - Difference Replace / Stuff 


 SQL - ROW_NUMBER() 


 SQL - Intersect

 
 SQL Server - Local Variables


 SQL Server - Update with Join 


 SQL Server - Difference Merge / Hash Join 


 SQL Server - Difference Update / Exclusive Lock 


 SQL Server - Difference Instance / Database 


 SQL Server - Difference Datetime2 / Datetime 


 SQL Server - Difference Disable / Drop Indexes 


 SQL Server - Difference Decimal / Float 


 SQL Server - DATEDIFF with Examples 


 SQL Server - Difference Raiserror / Throw 


 SQL Server - Query Excel Using Linked Server 


 SQL Server - WaitFor 


 SQL Server - Difference Rank, Dense_Rank & Row_Number 


 SQL Server - PATINDEX Examples 


 SQL Server - COLLATE Examples 


 SQL Server - Difference CHAR / VARCHAR 


 SQL Server - Interview Questions for Testers 


 SQL Interview Questions 


 SQL Join Interview Questions

 

Oracle PL/SQL