Oracle database 10g:Administration I Sample Questions:

1. Which two operations require undo data? (Choose two.)

A) rolling forward during instance recovery
B) committing a transaction
C) recording a transaction to redo log files
D) recovering from failed transactions
E) rolling back a transaction

2. You backed up the control file to trace. Which statement is true about the trace file generated?

A) The trace file is a backup set created during the backup of the control file.
B) The trace file is in binary format.
C) The trace file contains the instructions to manually re-create the control file.
D) The trace file has a SQL script to re-create the control file.
E) The trace file is an image copy of the control file created during the backup of the control file.

3. User A executes the following command to update the TRANS table:
SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code='C005';
Before user A issues a COMMIT or ROLLBACK command, user B executes the following
command on the TRANS table:
SQl> ALTER TABLE trans MODIFY (tr_type VARCHAR2(3));
What would happen in this scenario?

A) The ALTER TABLE command waits until user A ends the transaction.
B) The ALTER TABLE command modifies the column successfully.
C) The ALTER TABLE command fails due to the resource being busy.
D) The transaction for user A is rolled back.

4. In your database, the snapshot interval is set to 10 minutes for the Automatic Workload Repository (AWR). The database instance is running for the past 30 days.
View the Exhibit to examine the Automatic Database Diagnostic Monitor (ADDM) task.
The ADDM task is performed every 10 minutes, except the last task. What could be the reason for this?

A) The STATISTICS_LEVEL initialization parameter was changed to BASIC and reset to TYPICAL before the last task.
B) The optimizer statistics for few objects in the database were locked before the last task.
C) The snapshot retention period for the AWR was increased before the last task.
D) The optimizer statistics was collected manually by using the DBMS_STATS package before the last task.

5. You created a response file and want to check it before starting installations in silent mode. You started installation of Oracle software in interactive mode by providing the response file. In the middle of the installation, you realize that the behavior of the Oracle Universal Installer (OUI) is not consistent with the response file. What action would you take to detect the cause of this behavior?

A) Refer to the alert log file for information regarding the actions performed by OUI during installation.
B) Compare the contents of the installActions.log file with that of the response file.
C) Refer to the contents of the oraInst.loc file to verify the steps performed by OUI.
D) Compare the contents of the install.log file with the response file.

Solutions: