|
Question |
Rating |
View Answer |
|
What the difference between UNION and UNIONALL?
|
|
View Answer |
|
What is a event handler ? |
|
View Answer |
|
Which command displays the SQL command in the SQL buffer, and then executes it? |
|
View Answer |
|
What is normalization,types with eg's. _ with queries of all types?
|
|
View Answer |
|
What command is used to create a table by copying the structure of another table? |
|
View Answer |
|
What is reference cursor ?
|
|
View Answer |
|
Cursor Syntax brief history
|
|
View Answer |
|
How to analyze the performance of a query using Explain Plan? Can any one explain me this in detail... if you can provide me with a link where I can get full information on it I would appreciate it...? |
|
View Answer |
|
How can we backup the sql files & what is SAP?
|
|
View Answer |
|
In subqueries, which is efficient ,the IN clause or EXISTS clause? Does they produce the same result?????
|
|
View Answer |
|
1. How to create a new table? 2. How to insert another column into the table? |
|
View Answer |
|
Which system tables contain information on privileges granted and privileges obtained? |
|
View Answer |
|
What are the properties and different Types of Sub-Queries? |
|
View Answer |
|
What is sql? what is the difference between sql and pl/sql? |
|
View Answer |
|
What is the advantage to use trigger in your PL?
|
|
View Answer |
|
What’s the difference between a primary key and a unique key? |
|
View Answer |
|
Difference between VARCHAR and VARCHAR2?
|
|
View Answer |
|
What is the fastest way of accessing a row in a table? |
|
View Answer |
|
What is a default TCP/IP socket assigned for SQL Server? |
|
View Answer |
|
If a view on a single base table is manipulated will the changes be reflected on the base table?
|
|
View Answer |