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

1. In the PROD database you have granted the RESUMABLE system privilege to the CONNECT role. Resumable space operation has been enabled for all user sessions. You want users NOT to be aware of any kind of space-related problems while performing transactions. Instead, you want the problem to be resolved by a database trigger automatically. Which combination of triggering time and event would you use to achieve this objective?

A) BEFORE SUSPEND
B) AFTER TRUNCATE
C) AFTER SUSPEND
D) AFTER CREATE
E) BEFORE CREATE
F) AFTER INSERT OR DELETE OR UPDATE
G) BEFORE INSERT OR DELETE OR UPDATE

2. What are the consequences of executing the SHUTDOWN ABORT command? (Choose two.)

A) The database files are synchronized.
B) Database buffers and redo buffers are not written to the disk.
C) The database is closed, but the instance is still started.
D) Uncommitted changes are not rolled back.
E) The database undergoes automatic media recovery during the next startup.

3. Which two are valid locking levels that are used by transactions in an Oracle database? (Choose two.)

A) schema level
B) block level
C) row level
D) object level
E) database level

4. You have a text file that maintains information on thousands of items. The end-user application requires the transfer of that information into a table in the database. What would you use to achieve this task? (Choose two.)

A) Oracle Import
B) External table
C) Data Pump
D) Oracle Text
E) SQL*Loader

5. You suspect unauthorized data manipulation language (DML) operations on a particular table. You want to track users who are performing the transactions and the values used in the transactions. Also, you plan to transfer these values to another table for analysis. How would you achieve this?

A) by using anonymous PL/SQL blocks
B) by using triggers
C) by using external tables
D) by auditing all DML operations on the table

質問と回答：