多选题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 a table segment in a user tablespaceCTracking insert time by row for table rowsDTracking the most recent write time for a table blockETracking the most recent read time for a table segment in the SYSAUX tablespaceFTracking the most recent write time for a table segment in the SYSAUX tablespace
多选题
Which three tasks can be automatically performed by the Automatic Data Optimization feature ofInformation lifecycle Management (ILM)?（）
A
Tracking the most recent read time for a table segment in a user tablespace
B
Tracking the most recent write time for a table segment in a user tablespace
C
Tracking insert time by row for table rows
D
Tracking the most recent write time for a table block
E
Tracking the most recent read time for a table segment in the SYSAUX tablespace
F
Tracking the most recent write time for a table segment in the SYSAUX tablespace
参考解析
解析：
暂无解析
相关考题：
Which three tasks can be automatically performed by the Automatic Data Optimization feature ofInformation lifecycle Management (ILM)?() A. Tracking the most recent read time for a table segment in a user tablespaceB. Tracking the most recent write time for a table segment in a user tablespaceC. Tracking insert time by row for table rowsD. Tracking the most recent write time for a table blockE. Tracking the most recent read time for a table segment in the SYSAUX tablespaceF. Tracking the most recent write time for a table segment in the SYSAUX tablespace
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.
Which of the following must be available prior to performing the FIRST server backup？（）A、The most recent service packB、The most recent backup documentation planC、The most recent backup utilityD、The most recent hotfixes
Which of the following backup methodologies is MOST time efficient for restoring data?（）A、IncrementalB、DifferentialC、FullD、GFS
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 recoveryB、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 ThursdayC、restore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on TuesdayD、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
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.
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
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
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 statementB、Writing the modified data blocks to the data filesC、Writing the modified data to the archived redo log filesD、Updating the control file to indicate the most recent checkpointE、Updating the data file header to indicate the most recent checkpointF、Reading the blocks to database buffer cache if they are not already there
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.
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 SMD Upon investigation， you find that SMDis 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
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， acumulativeincremental level 1 tape backup is performed. Which two statements 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 incremental backup at level 1.
Which three tasks can be automatically performed by the Automatic Data Optimization feature ofInformation lifecycle Management (ILM)?（）A、Tracking the most recent read time for a table segment in a user tablespaceB、Tracking the most recent write time for a table segment in a user tablespaceC、Tracking insert time by row for table rowsD、Tracking the most recent write time for a table blockE、Tracking the most recent read time for a table segment in the SYSAUX tablespaceF、Tracking the most recent write time for a table segment in the SYSAUX tablespace
You are working on an Oracle Database 10g database that operates in the ARCHIVELOG mode. At 06：00 p.m.， you discovered that a table in the SYSTEM tablespace that does not belong to the data dictionary was dropped at 03：00 p.m. What would you do to recover the table？（）A、 use the Flashback Transaction Query feature to identify the relevant SQL statement and use it to undrop the tableB、 restore the entire database from the most recent backup and open itC、 recover the table by using the Flashback Table featureD、 perform point-in-time recovery to recover the table
A full backup of your database named DB1 is created automatically at midnight every day. Differential backups of DB1 occur twice each day at 10:00 and at 16:00. A database snapshot is created every day at noon. A developer reports that he accidentally dropped the Pricelist table in DB1 at 12:30. The last update to Pricelist occurred one week ago. You need to recover the Pricelist table. You want to achieve this goal by using the minimum amount of administrative effort. You must also minimize the amount of data that is lost. What should you do?（）A、 Restore the most recent backup into a new database named DB1bak. Apply the most recent differential backup. Copy the Pricelist table from DB1bak to DB1. B、 Delete all database snapshots except the most recent one. Restore DB1 from the most recent database snapshot. C、 Recover DB1 from the most recent backup. Apply the most recent differential backup. D、 Copy the Pricelist table from the most recent database snapshot into DB1.
多选题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（）AThe backup performed in step 1 backs up all blocks that have ever been in use in the database.BThe backup performed in step 2 copies all the blocks changed since the most recent level 0 backup.CThe backup performed in step 1 backs up all the blocks changed since the most recent level 1 backup.DThe backup performed in step 2 backs up all blocks that have changed since the most recent incrementalbackup at level 1
多选题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（）AAdd a data file to the SMD tablespace.BAdd a data file to the temporary tablespace associated with the user HR.CResize the data file associated with the SMD tablespace to make it larger.DAlter the data file associated with the SMD tablespace to grow automatically.EChange the segment space management for the SMD tablespace to automatic. n segments is managed through free lists.
多选题Network management saves time and money by automating which two tasks? （）AConfiguring changes to hardware and softwareBMonitoring online purchasingCMonitoring user access to storage filesDMonitoring and troubleshooting network devices
多选题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 SMD Upon investigation， you find that SMDis a small file tablespace. Which three action would allow the user to insert data（）AAdd a data file to the SMD tablespace.BAdd a data file to the temporary tablespace associated with the user HR.CResize the data file associated with the SMD tablespace to make it larger.DAlter the data file associated with the SMD tablespace to grow automatically.EChange the segment space management for the SMD tablespace to automatic
多选题You are adatabase developer. You develop atask management application that connect stoa SQLServer 2008 database named TaskDB.Users logon to the application by using a SQLServer login. The application contains amodule named Task that assigns tasks tousers. Information about the setasks is stored in the Tasks table of the TaskDB data base. The Tasks table contains multiple columns. These include the Close Dateand Estimated Timecolumns. The application must meet the following security requirements: Users assigned toad atabase role named User 1 canupd ate all task information columns except the Close Date and the Estimated Time columns in the Tasks table. Administrative users assigned toad atabase role named Task_Admin canupd ateall task information in the Tasks table.You needto design a strategy to meet the security requirements. Which two actions should you perform?（）AAdd the Task_Admin role to thedb_accessadmin fixed database role.BGrant Update permissions on the Tasks table to the Task_Admin role.CGrant Update permissions on the Tasks table to the User 1 role foreach column except the Close Dateand Estimated Time columns.DCreatean INSTEAD OF trigger on the Tasks Table. Use theIs_Member function toprevent the User 1 role from updating the Close Date and Estimated Time columns.
单选题Which statement is true about the loss of system/x7fcritical data files in ARCHIVELOG mode？（）AThe data files can be recovered till the last committed transaction.BThe data files can be recovered without shutting down the database.CThe data file is taken offline automatically; the database remains open.DThe data files can be recovered to the time of the most recent backup.
多选题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？（）ACreating the parse tree of the statementBWriting the modified data blocks to the data filesCWriting the modified data to the archived redo log filesDUpdating the control file to indicate the most recent checkpointEUpdating the data file header to indicate the most recent checkpointFReading the blocks to database buffer cache if they are not already there
多选题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?（）AThe valid time columns employee_time_start and employee_time_end are automatically created.BThe same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.CThe valid time columns are not populated by the Oracle Server automatically.DThe valid time columns are visible by default when the table is described.ESetting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulatio
多选题Which three tasks can be performed by using the performance Schema?（）AFinding queries that are not using indexesBFinding rows that are locked by InnoDBCFinding client connection attributesDFinding the part of a code in which a single query is spending timeEFinding the size of each table
多选题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 a table segment in a user tablespaceCTracking insert time by row for table rowsDTracking the most recent write time for a table blockETracking the most recent read time for a table segment in the SYSAUX tablespaceFTracking the most recent write time for a table segment in the SYSAUX tablespace
多选题Which two statements are correct regarding the Flashback Versions Query feature？（）AYou can use this feature to identify the committed versions of the rows， but not the uncommitted versions.BYou can use this feature to identify the versions of V$ views.CYou can use this feature to identify the inserts， deletes， and updates performed on a particular row but not the data definition language （DDL） operations performed on the table.DYou can use this feature for a table only if row movement is enabled for the table.EYou can use this feature to identify the versions of external and fixed tables.
单选题Which of the following must be available prior to performing the FIRST server backup？（）AThe most recent service packBThe most recent backup documentation planCThe most recent backup utilityDThe most recent hotfixes
单选题Which statement is true about the loss of system-critical data files in ARCHIVELOG mode？（）AThe data files can be recovered till the last committed transaction.BThe data files can be recovered without shutting down the database.CThe data file is taken offline automatically； the database remains open.DThe data files can be recovered to the time of the most recent backup.