Explain the uses of control file.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

Hi, Can anybody please explain me the flow of the below query. I am not able to understand how this query works. This query is for finding the Nth highest salary.. SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal); If N = 2 then second highest salary will be the o/p. If N = 3 then third highest salary will be the o/p. and so on.. Thanks, Nitin

5 Answers   Deloitte, Ness Technologies,


How do you handle exceptions. Give the syntax for it?

1 Answers   BCL, Microsoft,


what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

0 Answers  


Write a unique difference between a function and a stored procedure.

0 Answers  


What is the usage of distinct keyword?

0 Answers  






Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!?

3 Answers   eBay,


Define commit?

0 Answers  


List the different type of joins?

0 Answers  


Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

0 Answers   IBM,


How many triggers can be applied to a table?

0 Answers  


What does truncate mean in sql?

0 Answers  


Why stored procedure is faster than query?

0 Answers  


Categories