Siva Academy

SQL PLSQL Interview Questions

SQL & PL/SQL Interview Questions

Oracle SQL • PL/SQL • Interview Preparation • Real-World Questions

S.NoSQL PLSQL Interview QuestionYoutube
Link
1Difference between Delete and Truncate▶Link
2Difference between Procedure and Function▶Link
3Difference between NVL,NVL2, NULLIF and COALESCE▶Link
4Difference between Rank and Dense Rank▶Link
5What is SQL, What are the types of SQL statements▶Link
6How To Get unique records without using "DISTINCT" keyword in oracle?▶Link
7What is "DUAL" table in oracle?▶Link
8What is trigger in oracle? What are the types of trigger?What is the purpose of triggers in database?▶Link
9What is the difference between "DML" and "DDL" ?▶Link
10What is the difference between "CASE" and "DECODE"?▶Link
11What is the difference between "REPLACE" and "TRANSLATE" function?▶Link
12 What is "VIEW"? What is Simple View? What is Complex View? Are DML's allowed on view? Difference between "Simple" & "Complex" view? ▶Link
13 Can we use DML and DDL statements inside function? Link(Part-1) Link(Part-2)
14Can we use OUT and INOUT parameter in function?▶Link
15What is the difference between "VIEW" and "MATERIALIZED VIEW"?▶Link
16What is "SET operator" in oracle?Explain the difference between "UNION", "UNIONALL", "INTERSECT" and "MINUS"▶Link
17 What is %rowtype?
What is %type?
what is the Difference between %rowtype and %type?
What is the advantage of using %rowtype and %type?
▶Link
18 What is Index? How to create index?
What are the types of index?
▶Link
19 How to create index?
How to find the list of indexes for a given table?
▶Link
20 What is B-tree index? How index data is stored?
Where to find the metadata information?
How to find whether index is used by the query?
When to create B-tree index?
What types of scan operations B-tree index will do?
Can we create index for all columns?
What are advantages/disadvantages of B-tree index?
▶Link
21 Explain BITMAP Index ▶Link
22 Explain Function Based Index ▶Link
23 Explain Reverse key Index ▶Link
24 8. When to choose what type of index?
9. How to know index is being used?
10. How to monitor index usage?
11. What are the advantages/drawbacks of indexes?
▶Link
25 1.What are the types of DML triggers?
2.What is the order of execution of trigger if there is more than one trigger exits?
▶Link
26 What is SQL Loader
▶Link
27 What is difference between "VARRAY", "NESTED TABLE" and "ASSOCIATIVE ARRAY"
▶Link
28 What is "INSTEAD OF Trigger"?
▶Link
29 What is Error/Exception in PLSQL?
How to handle Exception on PLSQL?
▶Link
30 What are the types of Exceptions?
▶Link
31 What is "PRAGMA exception_init"?
▶Link
32 What is "Raise_application_error"?
▶Link
33 What is "SQLERRM" and "SQLCODE"?
▶Link
34 What is SUBQUERY and what are the types of subquery in Oracle?
▶Link
35 What is Simple SUBQUERY in Oracle?
▶Link
36 What is Correlated subquery Oracle?
▶Link
37 simple vs corelated subquery in Oracle
▶Link
38.1 NULL and Arithmetic operation
▶Link
38.2 NULL and Order By Clause
▶Link
39 IN vs ANY operator in Oracle
▶Link
40 Difference between SQL LOADER and EXTERNAL TABLE
▶Link
41 RANK and DENSE RANK as Aggregate Function and Analytical Function
▶Link
42 Query was running fine yesterday but its very slow today?
▶Link
43 What is cursor and what are the types of cursor in oracle?
▶Link
44 What is Explicit Cursor?
▶Link
45 Explain Cursor Attributes
▶Link
46 Explain Parameterized Cursor and For Cursor
▶Link
47 Strongly Typed Ref Cursor and Weakly typed Ref Cursor
▶Link
48 Explain FOR UPDATE clause and WHERE CURRENT OF Clause ( Cursor Related )
▶Link
49 Difference between CURSOR Vs COLLECTION
▶Link
50.1 Difference between CURSOR Vs REFCURSOR
▶Link
50.2 Difference between CURSOR Vs REFCURSOR
▶Link
51.1 What is Compound Trigger in Oracle? (PART 1)
▶Link
51.2 What is Compound Trigger in Oracle? (PART 2)
▶Link
52 What is Mutating Trigger?
▶Link
53 How to Solve Mutating Trigger Error?
▶Link
54 How to Solve Mutating Trigger Using Compound trigger?
▶Link
55 SQL to Delete duplicate rows in table
▶Link
56 what is the Maximum number of triggers on same table
▶Link
57 Creating Same Type of trigger on same table
▶Link
58 What is pragma autonomous transaction?
▶Link
59 oracle pragma autonomous transaction real time use case
▶Link
60 What are the advantages of packages?
▶Link
61 oracle constraint with DEFERRABLE NOVALIDATE option
▶Link
62 Oracle constraint related interview question
▶Link
63.1 How to Exclude duplicate records while insertion
▶Link
63.2 How to Exclude duplicate records while insertion
▶Link
64 ORACLE FORCE VIEW | ORACLE VIEW WITH CHECK OPTION | ORACLE VIEW WITH READ ONLY
▶Link
65 Oracle FOR vs FORALL
▶Link
66.1 Oracle MERGE statement ( Part 1 )
▶Link
66.2 Oracle MERGE statement ( Part 2 )
▶Link
67.1 Oracle View related question ( Part 1 )
▶Link
67.2 Oracle View related question ( Part 2 )
▶Link
68 Oracle Table Function
▶Link
69 ORACLE PIPELINED TABLE
▶Link
70 DIFFERENCE BETWEEN ORACLE PIPELINED TABLE FUNCTION Vs ORACLE TABLE FUNCTION?
▶Link