|
Question |
Rating |
View Answer |
 |
What is SPOOL? |
|
View Answer |
 |
What are advantages fo Stored Procedures |
|
View Answer |
 |
What is a database trigger ? Name some usages of database trigger ? |
|
View Answer |
 |
What happens if a procedure that updates a column of table X is called in a database trigger of the same table ? |
|
View Answer |
 |
What is Rollback? |
|
View Answer |
 |
What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes? |
|
View Answer |
 |
In a Distributed Database System Can we execute two queries simultaneously ? Justify ?
|
|
View Answer |
 |
What is SQL*Loader? |
|
View Answer |
 |
How we can create a table through procedure ? |
|
View Answer |
 |
What is Synonyms? |
|
View Answer |
 |
What are the components of a PL/SQL Block ? |
|
View Answer |
 |
What is a cursor ? Why Cursor is required ? |
|
View Answer |
 |
What are the cursor attributes used in PL/SQL ? |
|
View Answer |
 |
What is Correlated Subquery? |
|
View Answer |
 |
What is Overloading of procedures ? |
|
View Answer |
 |
What is the use of CASCADE CONSTRAINTS? |
|
View Answer |
 |
The INSERT INTO Statements in SQL? |
|
View Answer |
 |
What is NVL? |
|
View Answer |
 |
SELECT statements in SQL? |
|
View Answer |