1.
Which of the following parameters would you use to record the errors that might be generated during the import
operation?
2.
Which of the following SQL*Loader parameters enables you to load a specified number of records stored in the
data file?
3.
Which Oracle background process frees SGA resources that were allocated to a user process that failed?
4.
Which one of the following statements about the TNSPING utility is correct?
5.
Which of the following commands must be issued to remove a stored script from the recovery catalog?
6.
Which one of the following RMAN commands is used to register the database files with repository that were
backed up using O/S commands?
7.
Which of the following packages maintains information in the recovery catalog?
8.
Which of the following environment variables specifies a non-default location for the listener configuration file?
9.
In your HRDB database instance, a transaction is manipulating a large volume of data, and requires more
space in the database buffer cache. What happens if the buffer cache fills up before the transaction
completes?
10.
You are working on a test database where instance recovery takes a considerable amount of time. Which task
can reduce the recovery time?