单选题You executed the following code：   BACKUP VALIDATE DATABASE；   BLOCKRECOVER CORRUPTION LIST；  What will be the result of executing the above code？（）AThe code will run a backup validation to populate the V$BACKUP_CORRUPTION view and repair corrupt block

题目
单选题
You executed the following code：   BACKUP VALIDATE DATABASE；   BLOCKRECOVER CORRUPTION LIST；  What will be the result of executing the above code？（）
A

 The code will run a backup validation to populate the V$BACKUP_CORRUPTION view and repair corrupt blocks， if any， recorded in the view.

B

 The code will run a backup validate to populate the V$COPY_CORRUPTION view and then repair any corrupt blocks recorded in the view.

C

 The code will runs a backup validate to populate the V$DATABASE_BLOCK_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.

D

 The code will run a backup validate to populate the RC_BACKUP_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.

相似考题

1. public class Foo {  public void main（ String[] args ） {  System.out.println（ “Hello” + args[0] ）；  }  }   What is the result if this code is executed with the command line？（）A、 HelloB、 Hello FooC、 Hello worldD、 Compilation fails.E、 The code does not run.

2. You execute the following Recovery Manager （RMAN） commands in he following order：   BACKUP VALIDATE DATABAE RECOVER CORRUPTION LIST；   Which two tasks are performed by these commands？（）  A、 Repair the corrupted blocks. If any. In the backup createdB、 Populate VSCOPV_CORRUPTION with names of files that have corrupted blocksC、 Back up the database after checking whether array of the files have corrupted blocksD、 Discover any corrupt blocks that are viewable with the VSDATABASE_BI-OCK_CORBUPTION viewE、 Repair all corrupted blocks that have been logged in the VSDATABASE_BLOCK_ CORRUPTION

3.You have created a script in the recovery catalog called backup_database. Which of the following commands would successfully execute that script？（）  A、 run { open script backup_database； run script backup_database }B、 run { engage script backup_database； }C、 run { run script backup_database； }D、 Run { execute script backup_database； }E、 The name backup_database is an invalid name for an RMAN script. Trying to run it from RMAN would result in an error.

4.You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup？（）A、 V$BACKUP_CORRUPTIONB、 V$COPY_CORRUPTIONC、 V$DATABASE_BLOCK_CORRUPTIOND、 RC_BACKUP_CORRUPTION

更多“单选题You executed the following code：   BACKUP VALIDATE DATABASE；   BLOCKRECOVER CORRUPTION LIST；  What will be the result of executing the above code？（）A  The code will run a backup validation to populate the V$BACKUP_CORRUPTION view and repair corrupt blo”相关问题

  • 第1题：

    Which of the following views must you query to identify any corrupt data file blocks that have been detected during backup set creation？（）

    • A、V$COPY_CORRUPT
    • B、V$COPY_CORRUPTION
    • C、V$BACKUP_CORRUPT
    • D、V$BACKUP_CORRUPTION

    正确答案:D

  • 第2题：

    You execute the following RMAN commands in the order shown below：  BACKUP VALIDATE DATABASE;  BLOCKRECOVER CORRUPTION LIST;  What will these commands do？（）

    • A、create a backup of the database and recover all corrupted blocks found in the backup
    • B、run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database
    • C、run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view
    • D、run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view
    • E、run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired

    正确答案:D

  • 第3题：

    You issue the following code：    EXEC DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP        （’SCOTT’ ’GRP1’， TRUE）；   What will be the result of executing the above code？（）  

    • A、 The switch privilege will be granted to the user， Scott， for changing the consumer group to GRP1.
    • B、 The switch privilege will be granted to the user， Scott， for changing the consumer group from GRP1 to any other group.
    • C、 The code will not execute successfully because there is no GRANT_SWITCH_CONSUMER_GROUP procedure in the DBMS_RESOURCE_MANAGER_PRIVS package.
    • D、The code will execute successfully but no privilege will be granted to the user， Scott.

    正确答案:A

  • 第4题：

    You executed the following code：   BACKUP VALIDATE DATABASE；   BLOCKRECOVER CORRUPTION LIST；  What will be the result of executing the above code？（）  

    • A、 The code will run a backup validation to populate the V$BACKUP_CORRUPTION view and repair corrupt blocks， if any， recorded in the view.
    • B、 The code will run a backup validate to populate the V$COPY_CORRUPTION view and then repair any corrupt blocks recorded in the view.
    • C、 The code will runs a backup validate to populate the V$DATABASE_BLOCK_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.
    • D、 The code will run a backup validate to populate the RC_BACKUP_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.

    正确答案:C

  • 第5题：

    If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT， what RMAN command would you run to correct the problem？（）

    • A、 recover lost blocks
    • B、 recover corrupt blocks
    • C、 recover media corrupt blocks from list
    • D、 recover corrupt blocks from list
    • E、 recover corruption list

    正确答案:E

  • 第6题：

    单选题
    You have created a script in the recovery catalog called backup_database. Which of the following commands would successfully execute that script？（）
    A

     run { open script backup_database； run script backup_database }

    B

     run { engage script backup_database； }

    C

     run { run script backup_database； }

    D

     Run { execute script backup_database； }

    E

     The name backup_database is an invalid name for an RMAN script. Trying to run it from RMAN would result in an error.


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

  • 第7题：

    单选题
    Click the Exhibit button.   What is the result？（）
    A

     The code will deadlock.

    B

     The code may run with output "2 0 6 4".

    C

     The code may run with no output.

    D

     The code may run with output "0 6".

    E

     An exception is thrown at runtime.

    F

     The code may run with output "0 2 4 6".


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

  • 第8题：

    单选题
    You execute the following RMAN commands in the order shown below：  BACKUP VALIDATE DATABASE;  BLOCKRECOVER CORRUPTION LIST;  What will these commands do？（）
    A

    create a backup of the database and recover all corrupted blocks found in the backup

    B

    run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database

    C

    run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view

    D

    run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view

    E

    run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired


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

  • 第9题：

    单选题
    You issue the following code：    EXEC DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP        （’SCOTT’ ’GRP1’， TRUE）；   What will be the result of executing the above code？（）
    A

     The switch privilege will be granted to the user， Scott， for changing the consumer group to GRP1.

    B

     The switch privilege will be granted to the user， Scott， for changing the consumer group from GRP1 to any other group.

    C

     The code will not execute successfully because there is no GRANT_SWITCH_CONSUMER_GROUP procedure in the DBMS_RESOURCE_MANAGER_PRIVS package.

    D

    The code will execute successfully but no privilege will be granted to the user， Scott.


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

  • 第10题：

    单选题
    You created the ORDERS table in your database by using the following code：   SQL> CREATE TABLE ORDERS （ORDER_DATE TIMESTAMP（0） WITH TIME ZONE）；   Then， you inserted data in the ORDERS table and saved it by issuing the following statements：SQL> INSERT INTO ORDERS VALUES（’18-AUG-00 10：26：44 PM America/New_York’）；   SQL> INSERT INTO ORDERS VALUES（’23-AUG-02 12：46：34 PM America/New_York’）；   SQL> COMMIT；   Next， you issued the following statement to change the time zone for the database：   SQL> ALTER DATABASE SET TIME_ZONE=’Europe/London’；   What will be the result of executing the above statement？（）
    A

     The statement will fail.

    B

     The statement will be executed successfully， and the new time zone will be set for the database.

    C

     The statement will be executed successfully， but the new time zone will be set for the current session.

    D

    The statement will be executed successfully， but the new time zone will neither be set for the database nor for a specific session.


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

  • 第11题：

    单选题
    You executed the following code：   BACKUP VALIDATE DATABASE；   BLOCKRECOVER CORRUPTION LIST；  What will be the result of executing the above code？（）
    A

     The code will run a backup validation to populate the V$BACKUP_CORRUPTION view and repair corrupt blocks， if any， recorded in the view.

    B

     The code will run a backup validate to populate the V$COPY_CORRUPTION view and then repair any corrupt blocks recorded in the view.

    C

     The code will runs a backup validate to populate the V$DATABASE_BLOCK_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.

    D

     The code will run a backup validate to populate the RC_BACKUP_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.


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

  • 第12题：

    单选题
    You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup？（）
    A

     V$BACKUP_CORRUPTION

    B

     V$COPY_CORRUPTION

    C

     V$DATABASE_BLOCK_CORRUPTION

    D

     RC_BACKUP_CORRUPTION


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

  • 第13题：

    You executed the following code：   BEGIN   DBMS_SCHEDULER.SET_ATTRIBUTE  （  NAME => ’JOB_A’，   ATTRIBUTE => ’JOB_PRIORITY’，   VALUE => 7）；   END；  /   After analyzing the above code， what conclusion will you draw？（）  

    • A、 The code will be executed successfully.
    • B、 The code will not be executed successfully because the value of the VALUE parameter must be 1， 2， or 3.
    • C、 The code will not be executed successfully because the value of the VALUE parameter must range between 1 and 5.
    • D、 The code will not be executed successfully because no SET_ATTRIBUTE procedure exists in the DBMS_SCHDULER package.

    正确答案:C

  • 第14题：

    You created the ORDERS table in your database by using the following code：   SQL> CREATE TABLE ORDERS （ORDER_DATE TIMESTAMP（0） WITH TIME ZONE）；   Then， you inserted data in the ORDERS table and saved it by issuing the following statements：SQL> INSERT INTO ORDERS VALUES（’18-AUG-00 10：26：44 PM America/New_York’）；   SQL> INSERT INTO ORDERS VALUES（’23-AUG-02 12：46：34 PM America/New_York’）；   SQL> COMMIT；   Next， you issued the following statement to change the time zone for the database：   SQL> ALTER DATABASE SET TIME_ZONE=’Europe/London’；   What will be the result of executing the above statement？（）  

    • A、 The statement will fail.
    • B、 The statement will be executed successfully， and the new time zone will be set for the database.
    • C、 The statement will be executed successfully， but the new time zone will be set for the current session.
    • D、The statement will be executed successfully， but the new time zone will neither be set for the database nor for a specific session.

    正确答案:A

  • 第15题：

    You issued the following block of code：        SQL>BEGIN   DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP（        ’PROG_ROLE’， ’DEVELOPERS’ ，FALSE）；        END；        SQL>/   Which option is NOT a result of executing the above code？（）  

    • A、 The switch privilege is granted to the PROG_ROLE role.
    • B、 The users granted the role PROG_ROLE will be able to switch to the DEVELOPERS group.
    • C、 The users cannot grant the switch privilege to other users.
    • D、 The above code will not be executed successfully because the GRANT_SWITCH_CONSUMER_GROUP procedure is an invalid procedure in Oracle10g.

    正确答案:D

  • 第16题：

    You execute the following RMAN command in the order shown below： BACKUP VALIDATE DATABASE； BLOCKRECOVER CORRUPTION LIST； What will these commands do？（）

    • A、 Create a backup of the database and recover all corrupted blocks found in the backup.
    • B、 Run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database.
    • C、 Run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view.
    • D、 Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view.
    • E、 Run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired.

    正确答案:D

  • 第17题：

    单选题
    Which of the following views must you query to identify any corrupt data file blocks that have been detected during backup set creation？（）
    A

    V$COPY_CORRUPT

    B

    V$COPY_CORRUPTION

    C

    V$BACKUP_CORRUPT

    D

    V$BACKUP_CORRUPTION


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

  • 第18题：

    单选题
    You work as an application developer at Certkiller .com. Certkiller .com has asked you to create a multi-threaded application， which executes a critical database  backup operation on an hourly basis. You define this operation with the following code：  public void BackupDB （） {  //Implementation code }  You then create a Thread object for the purpose of invoking this method.  You need to ensure that the thread is scheduled for execution before any other thread at runtime.What should you do？（）
    A

    A

    B

    B

    C

    C

    D

    D


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

  • 第19题：

    单选题
    You execute the following RMAN command in the order shown below： BACKUP VALIDATE DATABASE； BLOCKRECOVER CORRUPTION LIST； What will these commands do？（）
    A

     Create a backup of the database and recover all corrupted blocks found in the backup.

    B

     Run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database.

    C

     Run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view.

    D

     Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view.

    E

     Run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired.


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

  • 第20题：

    单选题
    public class Foo {  public void main（ String[] args ） {  System.out.println（ “Hello” + args[0] ）；  }  }   What is the result if this code is executed with the command line？（）
    A

     Hello

    B

     Hello Foo

    C

     Hello world

    D

     Compilation fails.

    E

     The code does not run.


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

  • 第21题：

    多选题
    You execute the following Recovery Manager （RMAN） commands in he following order：   BACKUP VALIDATE DATABAE RECOVER CORRUPTION LIST；   Which two tasks are performed by these commands？（）
    A

    Repair the corrupted blocks. If any. In the backup created

    B

    Populate VSCOPV_CORRUPTION with names of files that have corrupted blocks

    C

    Back up the database after checking whether array of the files have corrupted blocks

    D

    Discover any corrupt blocks that are viewable with the VSDATABASE_BI-OCK_CORBUPTION view

    E

    Repair all corrupted blocks that have been logged in the VSDATABASE_BLOCK_ CORRUPTION


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

  • 第22题：

    单选题
    You executed the following code：   BEGIN   DBMS_SCHEDULER.SET_ATTRIBUTE  （  NAME => ’JOB_A’，   ATTRIBUTE => ’JOB_PRIORITY’，   VALUE => 7）；   END；  /   After analyzing the above code， what conclusion will you draw？（）
    A

     The code will be executed successfully.

    B

     The code will not be executed successfully because the value of the VALUE parameter must be 1， 2， or 3.

    C

     The code will not be executed successfully because the value of the VALUE parameter must range between 1 and 5.

    D

     The code will not be executed successfully because no SET_ATTRIBUTE procedure exists in the DBMS_SCHDULER package.


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

  • 第23题：

    单选题
    If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT， what RMAN command would you run to correct the problem？（）
    A

     recover lost blocks

    B

     recover corrupt blocks

    C

     recover media corrupt blocks from list

    D

     recover corrupt blocks from list

    E

     recover corruption list


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

  • 第24题：

    单选题
    You issued the following block of code：        SQL>BEGIN   DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP（        ’PROG_ROLE’， ’DEVELOPERS’ ，FALSE）；        END；        SQL>/   Which option is NOT a result of executing the above code？（）
    A

     The switch privilege is granted to the PROG_ROLE role.

    B

     The users granted the role PROG_ROLE will be able to switch to the DEVELOPERS group.

    C

     The users cannot grant the switch privilege to other users.

    D

     The above code will not be executed successfully because the GRANT_SWITCH_CONSUMER_GROUP procedure is an invalid procedure in Oracle10g.


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

相关内容