|
Question |
Rating |
View Answer |
|
Subquery vs Join |
|
View Answer |
|
How to drop the index |
|
View Answer |
|
How will you a activate/deactivate integrity constraints ? |
|
View Answer |
|
How can you call a PL/SQL procedure from SQL? |
|
View Answer |
|
What is tkprof and how is it used? |
|
View Answer |
|
What are the pre-requisites to modify datatype of a column and to add a column with NOT NULL constraint |
|
View Answer |
|
What is the fastest way of accessing a row in a table ? |
|
View Answer |
|
Explain the UNION operation in SQL . What is meant by OUTER JOIN |
|
View Answer |
|
Which date function returns number value |
|
View Answer |
|
Explain UNION,MINUS,UNION ALL, INTERSECT ? |
|
View Answer |
|
What is the sub-query |
|
View Answer |
|
What is the fastest way of accessing a row in a table? |
|
View Answer |
|
What is CYCLE/NO CYCLE in a Sequence ? |
|
View Answer |
|
If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE ? |
|
View Answer |
|
Is it possible to use LONG columns in WHERE clause or ORDER BY |
|
View Answer |
|
What is a join |
|
View Answer |
|
What are the data types allowed in a table ? |
|
View Answer |
|
What is a Non- corelated subquery |
|
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 transaction ? |
|
View Answer |