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