多选题Which three tasks can be automatically performed by the Automatic Data Optimization feature ofInformation lifecycle Management (ILM)?（）ATracking the most recent read time for a table segment in a user tablespaceBTracking the most recent write time for

第1题：

Which of the following must be available prior to performing the FIRST server backup？（）

• A、The most recent service pack
• B、The most recent backup documentation plan
• C、The most recent backup utility
• D、The most recent hotfixes

第2题：

Every Sunday， consistent backups are performed on your database. Because of a user error， you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday， which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available. What would you do in this scenario？（）

• A、recovery cannot be performed because a backup was not performed after the last incomplete recovery
• B、restore all the files from Sunday’s backup， and then perform an incomplete recovery up to the point in time when the user error occurred on Thursday
• C、restore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on Tuesday
• D、restore all the files from Sunday’s backup， and open the database to reset the database to the point in time when the backup was performed on Sunday

第3题：

第4题：

Your boss at Certkiller .com wants you to clarify Oracle 10g. Which two steps are performed the first time any UPDATE statement is issued after the instance is started？（）

• A、Creating the parse tree of the statement
• B、Writing the modified data blocks to the data files
• C、Writing the modified data to the archived redo log files
• D、Updating the control file to indicate the most recent checkpoint
• E、Updating the data file header to indicate the most recent checkpoint
• F、Reading the blocks to database buffer cache if they are not already there

第5题：

You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c. Examine the table definition: Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?（）

• A、The valid time columns employee_time_start and employee_time_end are automatically created.
• B、The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
• C、The valid time columns are not populated by the Oracle Server automatically.
• D、The valid time columns are visible by default when the table is described.
• E、Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulatio

第6题：

Which of the following backup methodologies is MOST time efficient for restoring data?（）

• A、Incremental
• B、Differential
• C、Full
• D、GFS

第7题：

Which statement is true about the loss of system/x7fcritical data files in ARCHIVELOG mode？（）

• A、The data files can be recovered till the last committed transaction.
• B、The data files can be recovered without shutting down the database.
• C、The data file is taken offline automatically; the database remains open.
• D、The data files can be recovered to the time of the most recent backup.

第8题：

The user HR receives the following error while inserting data into the TTK table： ERROR at line 1：  ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMDUpon  investigation， you find that SMD is a small file tablespace.  Which three action would allow the user to insert data（）

• A、Add a data file to the SMD tablespace.
• B、Add a data file to the temporary tablespace associated with the user HR.
• C、Resize the data file associated with the SMD tablespace to make it larger.
• D、Alter the data file associated with the SMD tablespace to grow automatically.
• E、Change the segment space management for the SMD tablespace to automatic. n segments is managed through free lists.

第9题：

You are managing an Oracle Database 11g database with the following backup strategy：1） On Sunday， an incremental level 0 tape backup is performed.2） Monday through Saturday， a cumulative incremental level 1 tape backup is performed. Which twostatements are true regarding the backups performed（）

• A、The backup performed in step 1 backs up all blocks that have ever been in use in the database.
• B、The backup performed in step 2 copies all the blocks changed since the most recent level 0 backup.
• C、The backup performed in step 1 backs up all the blocks changed since the most recent level 1 backup.
• D、The backup performed in step 2 backs up all blocks that have changed since the most recent incrementalbackup at level 1

第10题：

Which statement is true about the loss of system-critical data files in ARCHIVELOG mode？（）

• A、The data files can be recovered till the last committed transaction.
• B、The data files can be recovered without shutting down the database.
• C、The data file is taken offline automatically； the database remains open.
• D、The data files can be recovered to the time of the most recent backup.