Oracle database 10g:Administration I 認定 1Z0-042 試験問題:

1. A user receives the following error while executing a query:
ORA-01555: snapshot too old
Which two options can be the solutions to avoid such errors in future? (Choose two.)

A) increase the size of redo log files
B) increase the size of the default temporary tablespace
C) increase the size of the Database Buffer Cache
D) increase the size of the undo tablespace
E) enable the retention guarantee for the undo tablespace

2. Which two statements about Recovery Manager (RMAN) backups are true? (Choose two.)

A) Only consistent database backups can be performed.
B) Archived redo log files are backed up.
C) RMAN backup can be taken only if the database is configured in ARCHIVELOG mode.
D) Online redo log files can be backed up.
E) Only used data blocks can be backed up as backup sets.

3. Which two statements are true about the primary key constraint in a table? (Choose two.)

A) It is possible to have more than one primary key constraint in a single table.
B) It is not possible to disable the primary key constraint.
C) The non-deferrable primary key constraint creates an unique index on the primary key column if it is not already indexed.
D) The primary key constraint can be imposed by combining more than one column.
E) The primary key constraint can be referred by only one foreign key constraint.

4. When you try to start the Database Control by using the emctl start dbconsole command the following error is displayed:
TZ set to America/New_york
OC4J Configuration issue. /u01/app/oracle/product/10.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_orcl.us.oracle.com not found.
Which two environment variables do you need to set appropriately to avoid such errors, and start the Database Control successfully? (Choose two.)

A) LD_LIBRARY_PATH
B) NLS_LANG
C) ORACLE_BASE
D) ORACLE_HOME
E) ORACLE_SID

5. Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of the database in the future. What action would you take to achieve this task?

A) Set the snapshot retention period in the Automatic Workload Repository (AWR) to zero to avoid the automatic purging of the snapshots.
B) Create a baseline on a pair of snapshots that have the statistics of the peak-load period in the database.
C) Set the STATISTICS_LEVEL initialization parameter to ALL.
D) Decrease the snapshot interval in the AWR to collect more number of snapshots during the peak-load period.

質問と回答：