SQL PLSQL Interview Questions

ALL SQL PLSQL INTERVIEW QUESTIONS    |    

---

S.No	SQL PLSQL Interview Question	Youtube Link
1	Difference between Delete and Truncate	Link
2	Difference between Procedure and Function	Link
3	Difference between NVL,NVL2, NULLIF and COALESCE	Link
4	Difference between Rank and Dense Rank	Link
5	What is SQL, What are the types of SQL statements	Link
6	How To Get unique records without using "DISTINCT" keyword in oracle?	Link
7	What is "DUAL" table in oracle?	Link
8	What is trigger in oracle? What are the types of trigger?What is the purpose of triggers in database?	Link
9	What is the difference between "DML" and "DDL" ?	Link
10	What is the difference between "CASE" and "DECODE"?	Link
11	What 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)
14	Can we use OUT and INOUT parameter in function?	Link
15	What is the difference between "VIEW" and "MATERIALIZED VIEW"?	Link
16	What 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