|
Question |
Rating |
View Answer |
 |
How do you set the number of lines on a page of output,the width? |
|
View Answer |
 |
What is explain plan and how is it used? |
|
View Answer |
 |
What is tkprof and how is it used? |
|
View Answer |
 |
You are joining a local and a remote table, the network manager complains about the traffic involved, how can you reduce the network traffic? |
|
View Answer |
 |
What is a Cartesian product? |
|
View Answer |
 |
You want to determine the location of identical rows in a table before attempting to place a unique index on the table, how can this be done? |
|
View Answer |
 |
What SQLPlus command is used to format output from a select? |
|
View Answer |
 |
You want to use SQL to build SQL, what is this called and give an example |
|
View Answer |
 |
How can you call a PL/SQL procedure from SQL? |
|
View Answer |
 |
How do I replace a comma (,) with a blank in a select statement? |
|
View Answer |
 |
How to get/select the nth row from the table ? How to select first n rows ,last n rows from a table
|
|
View Answer |
 |
What are the types of SQL statement |
|
View Answer |
 |
What is a transaction |
|
View Answer |
 |
What is difference between TRUNCATE & DELETE |
|
View Answer |
 |
What is a join |
|
View Answer |
 |
Explain the different types of joins |
|
View Answer |
 |
What is the sub-query |
|
View Answer |
 |
What is correlated sub-query |
|
View Answer |
 |
Explain CONNECT BY PRIOR |
|
View Answer |
 |
Difference between SUBSTR and INSTR |
|
View Answer |