최신 10g DBA 1Z0-042 무료샘플문제:

1. In your database, the Log Writer (LGWR) process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database? (Choose two.)

A) The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file.
B) Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members.
C) The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.
D) The database operation temporarily halts till the member becomes available.
E) The database instance aborts.

2. The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a bank. As part of the year-end tax and interest calculation process, all the rows in the table need to be accessed. The bank authorities want to track access to the rows containing balance amounts exceeding $200,000, and then send an alert message to the administrator. Which method would you suggest to the bank for achieving this task?

A) implementing value-based auditing by using triggers
B) implementing fine-grained auditing with audit condition and event handler
C) performing standard database auditing to audit SQL statements with granularity level set to ACCESS
D) performing standard database auditing to audit object privileges by setting the AUDIT_TRAIL parameter to EXTENDED

3. You executed the following command to back up your control file:
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
Which initialization parameter is used to specify the location of the trace file?

A) BACKUP_DUMP_DEST
B) CORE_DUMP_DEST
C) TRACE_DUMP_DEST
D) BACKGROUND_DUMP_DEST
E) USER_DUMP_DEST

4. You want to move all the objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task?

A) FULL
B) REMAP_TABLESPACE
C) REMAP_DATAFILES
D) SCHEMAS
E) REMAP_SCHEMA

5. 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.

질문과 대답: