|
Question |
Rating |
View Answer |
|
What is a OUTER JOIN? |
|
View Answer |
|
How you will avoid your query from using indexes? |
|
View Answer |
|
What is a pseudo column. Give some examples? |
|
View Answer |
|
Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments? |
|
View Answer |
|
Display the records between two range? |
|
View Answer |
|
Find out nth highest salary from emp table |
|
View Answer |
|
Display the number value in Words? |
|
View Answer |
|
Display Odd/ Even number of records |
|
View Answer |
|
How do you find the number of rows in a Table ? |
|
View Answer |
|
minvalue.sql Select the Nth lowest value from a table |
|
View Answer |
|
maxvalue.sql Select the Nth Highest value from a table |
|
View Answer |
|
What is the purpose of a cluster? |
|
View Answer |
|
What is a cursor? |
|
View Answer |
|
Difference between an implicit & an explicit cursor. |
|
View Answer |
|
What are cursor attributes? |
|
View Answer |
|
What is a cursor for loop? |
|
View Answer |
|
Difference between NO DATA FOUND and %NOTFOUND |
|
View Answer |
|
What a SELECT FOR UPDATE cursor represent. |
|
View Answer |
|
What WHERE CURRENT OF clause does in a cursor? |
|
View Answer |
|
What is use of a cursor variable? How it is defined? |
|
View Answer |