多选题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

题目
多选题
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

相似考题

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

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

3.Which of the following backup methodologies is MOST time efficient for restoring data?（）A、IncrementalB、DifferentialC、FullD、GFS

4. 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 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题：

    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

    正确答案:B

  • 第2题：

    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

    正确答案:A,B,E

  • 第3题：

    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

    正确答案:C,D

  • 第4题：

    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

    正确答案:A,C,D

  • 第5题：

    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

    正确答案:A,B,C

  • 第6题：

    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.

    正确答案:D

  • 第7题：

    多选题
    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.


    正确答案： C,E
    解析： 暂无解析

  • 第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 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


    正确答案： D,A
    解析： 暂无解析

  • 第9题：

    单选题
    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.


    正确答案： A
    解析： 暂无解析

  • 第10题：

    多选题
    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


    正确答案： E,D
    解析： 暂无解析

  • 第11题：

    多选题
    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


    正确答案： E,D
    解析： 暂无解析

  • 第12题：

    单选题
    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


    正确答案： B
    解析： 暂无解析

  • 第13题：

    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.

    正确答案:A

  • 第14题：

    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

    正确答案:A,B

  • 第15题：

    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.

    正确答案:A

  • 第16题：

    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.

    正确答案:A,B

  • 第17题：

    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 table
    • B、 restore the entire database from the most recent backup and open it
    • C、 recover the table by using the Flashback Table feature
    • D、 perform point-in-time recovery to recover the table

    正确答案:D

  • 第18题：

    多选题
    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


    正确答案： C,A
    解析： 暂无解析

  • 第19题：

    多选题
    Network management saves time and money by automating which two tasks? （）
    A

    Configuring changes to hardware and software

    B

    Monitoring online purchasing

    C

    Monitoring user access to storage files

    D

    Monitoring and troubleshooting network devices


    正确答案： B,A
    解析： 暂无解析

  • 第20题：

    多选题
    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?（）
    A

    Add the Task_Admin role to thedb_accessadmin fixed database role.

    B

    Grant Update permissions on the Tasks table to the Task_Admin role.

    C

    Grant Update  permissions on  the  Tasks table to  the  User  1  role foreach  column  except the  Close  Dateand Estimated  Time columns.

    D

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


    正确答案： C,D
    解析： 暂无解析

  • 第21题：

    多选题
    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


    正确答案： E,D
    解析： 暂无解析

  • 第22题：

    多选题
    Which three tasks can be performed by using the performance Schema?（）
    A

    Finding queries that are not using indexes

    B

    Finding rows that are locked by InnoDB

    C

    Finding client connection attributes

    D

    Finding the part of a code in which a single query is spending time

    E

    Finding the size of each table


    正确答案： C,E
    解析： 暂无解析

  • 第23题：

    多选题
    Which two statements are correct regarding the Flashback Versions Query feature？（）
    A

    You can use this feature to identify the committed versions of the rows， but not the uncommitted versions.

    B

    You can use this feature to identify the versions of V$ views.

    C

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

    D

    You can use this feature for a table only if row movement is enabled for the table.

    E

    You can use this feature to identify the versions of external and fixed tables.


    正确答案： A,C
    解析： 暂无解析

  • 第24题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

相关内容