1) Oracle architecture.
2) Select duplicate records.
3) What is function?
4) Difference between procedure and function.
5) What is package?
6) What is trigger?
7) What are constraints? Types of constraints?
8) Explain group by clause and order by clause and having clause.
9) Difference between primary key and unique key?
10) What are the difference types of data types
11) Different types of pseudo columns? What is rowid and rownum and their difference.
12) What is iterative statement (loops)
13) What is cursor?
14) What is view? Types of views?
15) Difference between view and materialized view and its usage
16) Explain DDL, DML and TCL (transaction control language)
17) What are the DDL, DML and TCL commands
18) What is magic table in trigger and in oracle?
19) What is sequence?
========================================================================================
1) What is normalization?
2) How to use LIKE clause effectively.
3) How to execute trigger.
4) What is rank, dens rank?
5) CURRENT OF CLAUSE, NOW WAIT CLAUSE and FOR UPDATE CLAUSE.
5) How to use truncate in procedure.
6) What are pseudo records in triggers?
7) What is Global, public and private variable
8) What if NOT IN clause contains NULL values?
9) What is table?
10) Records and collections in oracle.
11) Can we insert values in materialized views?
12) Which is faster IN or EXIST? Why?
13) What is difference between function and procedure? Excluding function returns value and procedure doesn’t
14) What is copy command in oracle?
15) How to skip first 10 records in sql loader?
16) What inline view, sub query and co-related sub query?
17) What is BULK COLLECT?
18) What are the difference types of index and their usage?
19) What is external table in oracle?
20) How can I create primary key on the column which is having duplicate records.
21) What is sql loader?
22) What are the new features of oracle 12c.
23) types of Index?
24) What is cursor and types of cursors.
25) How can we handle exceptions in bulk operations.
26) What is Merge?
27) How to delete duplicate records in table.
28) Second highest salary from table.
29) How can we fetch average amount without using average function.
30) How to drop parent table while child table still exist.
Read Also:- SQL Server Interview Questions
2) Select duplicate records.
3) What is function?
4) Difference between procedure and function.
5) What is package?
6) What is trigger?
7) What are constraints? Types of constraints?
8) Explain group by clause and order by clause and having clause.
9) Difference between primary key and unique key?
10) What are the difference types of data types
11) Different types of pseudo columns? What is rowid and rownum and their difference.
12) What is iterative statement (loops)
13) What is cursor?
14) What is view? Types of views?
15) Difference between view and materialized view and its usage
16) Explain DDL, DML and TCL (transaction control language)
17) What are the DDL, DML and TCL commands
18) What is magic table in trigger and in oracle?
19) What is sequence?
========================================================================================
1) What is normalization?
2) How to use LIKE clause effectively.
3) How to execute trigger.
4) What is rank, dens rank?
5) CURRENT OF CLAUSE, NOW WAIT CLAUSE and FOR UPDATE CLAUSE.
5) How to use truncate in procedure.
6) What are pseudo records in triggers?
7) What is Global, public and private variable
8) What if NOT IN clause contains NULL values?
9) What is table?
10) Records and collections in oracle.
11) Can we insert values in materialized views?
12) Which is faster IN or EXIST? Why?
13) What is difference between function and procedure? Excluding function returns value and procedure doesn’t
14) What is copy command in oracle?
15) How to skip first 10 records in sql loader?
16) What inline view, sub query and co-related sub query?
17) What is BULK COLLECT?
18) What are the difference types of index and their usage?
19) What is external table in oracle?
20) How can I create primary key on the column which is having duplicate records.
21) What is sql loader?
22) What are the new features of oracle 12c.
23) types of Index?
24) What is cursor and types of cursors.
25) How can we handle exceptions in bulk operations.
26) What is Merge?
27) How to delete duplicate records in table.
28) Second highest salary from table.
29) How can we fetch average amount without using average function.
30) How to drop parent table while child table still exist.
Read Also:- SQL Server Interview Questions
No comments:
Post a Comment