What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?
How we can create a table through procedure ?
Explain the two type of Cursors ?
What is difference between a Cursor declared in a procedure and Cursor declared in a package
specification ?
How to disable multiple triggers of a table at at a time?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What is Overloading of procedures ?
Can we declare a column having number data type and its scale is larger than pricesion ex: column_name NUMBER(10,100), column_name NUMBAER(10,-84)
What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?
What is NVL?
What are the two parts of a procedure ?
Write the order of precedence for validation of a column in a table ? I. done using Database triggers. ii. done using Integarity Constraints.
What is Character Functions?
What is Rollback?
What are the cursor attributes used in PL/SQL ?
In a Distributed Database System Can we execute two queries simultaneously ? Justify ?
In pl/sql functions what is use of out parameter even though we have return statement.
What are advantages fo Stored Procedures
What is SPOOL?
What is Intersect?
Next>>
