|
Question |
Rating |
View Answer |
|
What are two virtual tables available during database trigger execution ? |
|
View Answer |
|
Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ? |
|
View Answer |
|
How many types of database triggers can be specified on a table ? What are they ? |
|
View Answer |
|
What is a database trigger ? Name some usages of database trigger ? |
|
View Answer |
|
Explain the usage of WHERE CURRENT OF clause in cursors ? |
|
View Answer |
|
What will happen after commit statement ? |
|
View Answer |
|
What is a cursor for loop ? |
|
View Answer |
|
What are the cursor attributes used in PL/SQL ? |
|
View Answer |
|
What are the PL/SQL Statements used in cursor processing ? |
|
View Answer |
|
Explain the two type of Cursors ? |
|
View Answer |
|
What is a cursor ? Why Cursor is required ? |
|
View Answer |
|
What is PL/SQL table ? |
|
View Answer |
|
What is difference between % ROWTYPE and TYPE RECORD ? |
|
View Answer |
|
What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes? |
|
View Answer |
|
What are the datatypes a available in PL/SQL ? |
|
View Answer |
|
What are the components of a PL/SQL Block ? |
|
View Answer |
|
What are the components of a PL/SQL block ? |
|
View Answer |
|
What is the basic structure of PL/SQL ? |
|
View Answer |
|
What is PL/SQL ? |
|
View Answer |
|
What will the Output for this Coding? Declare Cursor c1 is select * from emp FORUPDATE; Z c1%rowtype; Begin Open C1; Fetch c1 into Z; Commit; Fetch c1 in to Z; end;
|
|
View Answer |