1.
What functionality is exclusive to onbar (i.e. not present in ontape)?
2.
What is the minimum database-level privilege required for a user to create Stored Procedure Language routines?
3.
Which command would you execute to restore an instance without using or restoring the logical logs?
4.
Which of the following is required for a cold restore?
5.
Which configuration parameters are used by ontape logical log backup?
6.
What functionality is exclusive to ontape (i.e. not present in onbar)?
7.
There are two open sessions (session A and session B) that are updating the same tables. Session B is trying to read all rows in the table and is continuously receiving the error -143 ISAM error: deadlock detected. Which action in session B would allow it to read all of the rows?
8.
What is the only isolation level available on an unlogged database?
9.
Which phase of Fast Recovery rolls forward (restores) all transactions since the last checkpoint and rolls back any uncommitted transactions?
10.
What is the default isolation level on a mode ANSI database?