Oracle SQL Interview Questions

 
1.
Explain What is difference between SQL and SQL*PLUS?
2.
What is is a cursor?
3.
Explain What are various joins used while writing SUBQUERIES?
4.
Explain Difference between database triggers and form triggers?
5.
Explain me can the default values be assigned to actual parameters?
6.
How to pass cursor variables in PL/SQL 2.2?
7.
Explain What is difference between SUBSTR and INSTR?
8.
Explain What is an UTL_FILE.What are different procedures and functions associated with it?
9.
Explain Which is more faster - IN or EXISTS?
10.
How to find out nth highest salary from emp table?
11.
Explain What should be the return type for a cursor variable. Can we use a scalar data type as return type?
12.
Select the Nth lowest value from a table?
13.
Explain What is the purpose of a cluster?
14.
Explain Difference between procedure and function.?
15.
Explain Which datatype is used for storing graphics and images?
16.
Explain Difference between an implicit and an explicit cursor?
17.
Explain What is difference between SQL and SQL*PLUS?
18.
What is is a cursor?
19.
Explain What are various joins used while writing SUBQUERIES?
20.
Explain Difference between database triggers and form triggers?
21.
Explain me can the default values be assigned to actual parameters?
22.
How to pass cursor variables in PL/SQL 2.2?
23.
Explain What is difference between SUBSTR and INSTR?
24.
Explain What is an UTL_FILE.What are different procedures and functions associated with it?
25.
Explain Which is more faster - IN or EXISTS?
26.
How to find out nth highest salary from emp table?
27.
Explain What should be the return type for a cursor variable. Can we use a scalar data type as return type?
28.
Select the Nth lowest value from a table?
29.
Explain What is the purpose of a cluster?
30.
Explain Difference between procedure and function.?
31.
Explain Which datatype is used for storing graphics and images?
32.
Explain Difference between an implicit and an explicit cursor?
33.
Explain What is difference between SQL and SQL*PLUS?
34.
What is is a cursor?
35.
Explain What are various joins used while writing SUBQUERIES?
36.
Explain Difference between database triggers and form triggers?
37.
Explain me can the default values be assigned to actual parameters?
38.
How to pass cursor variables in PL/SQL 2.2?
39.
Explain What is difference between SUBSTR and INSTR?
40.
Explain What is an UTL_FILE.What are different procedures and functions associated with it?
41.
Explain Which is more faster - IN or EXISTS?
42.
How to find out nth highest salary from emp table?
43.
Explain What should be the return type for a cursor variable. Can we use a scalar data type as return type?
44.
Select the Nth lowest value from a table?
45.
Explain What is the purpose of a cluster?
46.
Explain Difference between procedure and function.?
47.
Explain Which datatype is used for storing graphics and images?
48.
Explain Difference between an implicit and an explicit cursor?
49.
Explain What is difference between SQL and SQL*PLUS?
50.
What is is a cursor?
51.
Explain What are various joins used while writing SUBQUERIES?
52.
Explain Difference between database triggers and form triggers?
53.
Explain me can the default values be assigned to actual parameters?
54.
How to pass cursor variables in PL/SQL 2.2?
55.
Explain What is difference between SUBSTR and INSTR?
56.
Explain What is an UTL_FILE.What are different procedures and functions associated with it?
57.
Explain Which is more faster - IN or EXISTS?
58.
How to find out nth highest salary from emp table?
59.
Explain What should be the return type for a cursor variable. Can we use a scalar data type as return type?
60.
Select the Nth lowest value from a table?
61.
Explain What is the purpose of a cluster?
62.
Explain Difference between procedure and function.?
63.
Explain Which datatype is used for storing graphics and images?
64.
Explain Difference between an implicit and an explicit cursor?