|
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 |