-
Oracle locks
With what ways can we find out instance locks?
-
Finding object dependencies
How can we find out the dependencies on a table?
-
Oracle Joins
There are 2 tables, A and B having 3 rows each. What will be result on executing the following query? : SQL> select * from A,B
-
Debugging PL/SQL programs
How can we debug stored procedures in PL/SQL?
-
Bulk binding
What are the advantages of bulk binding in PL/SQL?
-
Transaction management in triggers
Can we give COMMIT or ROLLBACK within a trigger?
-
Dropping a type in Oracle
Can a type body be dropped without dropping the type specification?
-
Oracle collections
What are the types of collection in PL/SQL? What is the advantage of nested tables?
-
Copying data across tables
In what ways can data be copied from one table to another?
-
Autonomous transactions
What is an autonomous transaction?
-
Global temporary tables
What is a global temporary table?