单选题 You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA. While observing the server settings， you find that the following parameter has been set in the parameter file of the database： REMOTE_OS_AUTHENT = TRUE What could have been the reason to set this parameter as TRUE？（）
to enable operating system authentication for a remote client
to restrict the scope of administration to identical operating systems
to allow the start up and shut down of the database from a remote client
to enable the administration of the operating system from a remote client
to disable the administration of the operating system from a remote client
单选题 According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）
The backup is similar to image copy.
The backup contains all used data blocks.
The backup contains only unused data blocks.
The backup contains all data blocks changed since the last incremental level 1 backup.
ASM provides mirroring on file by file basis.
ASM provides automatic load balancing across all ASM disks.
ASM supports the Oracle database and operating system files.
ASM can be used to store trace files， alert log files， and the server parameter file （SPFILE）.
多选题 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？（）
单选题 Your database is in the NOARCHIVELOG mode. Since last night’s offline backup， the logs in group 1 have been written to twice. This morning， the SYSTEM data file has become corrupted. Up to what point can it be recovered？（）
until the last commit
cannot be recovered
until the last offline backup
until the beginning of the last transaction
单选题 You work as a database administrator for Certkiller .com. You want to be notified when the number of disk I/O increases by 10% of what it was yesterday. You create a baseline metric for yesterday’s disk I/O performance. How do you use the baseline metrics to achieve your objective？（）
Save the baseline in the database
Save the baseline in the Database Control Home Page
Create a procedure to read and apply the baseline to disk I/O metrics
Apply the baseline to the disk I/O metrics in the Mange Metrics page
Alter the disk I/O metrics to include baseline by using the ALTER METRICScommnd
单选题 You work as a database administrator for Certkiller .com. Because of space constraints， you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows： ERROR at Line 1： ORA-10635： Invalid segment ortablespacetype What could be the reason？（）
The table is partitioned
The table name is wrong.
It is an index-Organized table （IOT）
The table is stored in locally managedtablespace.
The table is stored in atablespacewhere segment space is managed manually.
单选题 Your database is running under automatic undo management and the UNDO_RETENTION parameter is set to 900 sec. You executed the following command to enable retention guarantee： SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE； What effect would this statement have on the database？（）
The extents in undo tablespace retain data until the next full database backup.
The extents containing committed data in the undo tablespace are never overwritten.
The extents which no longer contain uncommitted data in the undo tablespace are not overwritten for at least15 minutes.
The extents containing committed data in the undo tablespace are not overwritten until the instance is shut down.
单选题 The user SCOTT executes the following command successfully to increase the salary values in one of his sessions： SQL> UPDATE emp SET sal=sal*1.15 WHERE deptno=20; Before SCOTT ends the transaction， user HR who has the privileges on EMP table executes a query to fetch the salary details but finds the old salary values instead of the increased values. Why does HR still see the old data？（）
because of redo data from redo log file
because of data from database buffer cache
because of data from a temporary tablespace
because of undo data from the undo tablespace
FGA is possible on SELECT statements only.
The audit trail for FGA is stored in the FGA_LOG$ table.
The audit trail for FGA is stored in the AUD_LOG$ table.
FGA enables a SQL predicate to define when to audit an event.
FGA audits DELETE statements only when audit columns are specified.
FGA includes the SQL statement used by the user as part of the audit event entry.