We heartily thanks Barnwal for sharing collections of PL/SQL interview question asked in various companies.
Exp: 3 Yearcomp: HCL, ACCENTURE
1- What are differences between delete and truncate statement ?
2-What is bulk sql?
3- What is bulk collect clause?
4-How many types of Exception Handling are there ?
5- What is ref cursor?
6- How many types of Views are there?
7- What is Materialized View?
8-What is Deterministic Function?
9-What is PRAGMA_Exception_Init?
10-What is Autonomous Transaction?
11-Wha is difference between DDL and DML command?
12-How we can see all the tables in one Schema?
13-What Exception Propagation?
14- What is Force View?
15- What is Instead of Trigger?
16- For Query Optimization, what methods you can use?
17-How you can use Cursor under Procedure?
18-What is commit, savepoint and Rollback?
19-What is difference between Procedure and Function?
20-What is correlated subquery?
21- What is Cursor and How many types of Cursor you have used?
22- What is self join?
23- What is Mutation of Tables?
24- What is Collection? And how many types of Collections are there?
25-What is FORALL statement?
26- What is RANK and DENS_RANK?
27-What is INDEX and how many types of INDEX are there?
28-What is CONNECT_BY clause?
29-What is Analytic function?
30- What is difference between View and Force View?
31- What is MERGE statement?
32- What is Cartesian Product?
No comments:
Post a Comment