Database Development Interview Questions

 
1.
Explain the syntax of named procedure?
2.
How to find the first two highest salaries in deptno in emp table?
3.
What is difference between primary key and unique key?
4.
What is the use of foreginkey?
5.
How to create an external table?
6.
What is the difference between case version and decode version?
7.
What is the family trees and connection by clause?
8.
How to find the duplicate rows count from employees table in oracle?
9.
In which phase of mload can i use .FILLER?
10.
Write short notes on XSU and JAVA?