单选题Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN. You want to issue the following RMAN command: RMAN > BAC

题目
单选题
Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN. You want to issue the following RMAN command: RMAN > BACKUP TABLESPACE hr_pdb:userdata; Which task should you perform before issuing the command?（）
A

Place the root container in ARHCHIVELOG mode.

B

Take the user data tablespace offline.

C

Place the root container in the nomount stage.

D

Ensure that HR_PDB is open.

相似考题

1.In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container:Which two statements are true?()A. The C # # ROLE1 role is created in the root database and all the PDBs.B. The C # # ROLE1 role is created only in the root database because the container clause is not used.C. Privileges are granted to the C##A_ADMIN user only in the root database.D. Privileges are granted to the C##A_ADMIN user in the root database and all PDBs.E. The statement for granting a role to a user fails because the CONTAINER clause is not used.

2.Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN.You want to issue the following RMAN command:RMAN > BACKUP TABLESPACE hr_pdb:userdata;Which task should you perform before issuing the command?（）A. Place the root container in ARHCHIVELOG mode.B. Take the user data tablespace offline.C. Place the root container in the nomount stage.D. Ensure that HR_PDB is open.

3.Which three statements are true about using flashback database in a multitenant container database(CDB)?()A. The root container can be flashed back without flashing back the pluggable databases (PDBs).B. To enable flashback database, the CDB must be mounted.C. Individual PDBs can be flashed back without flashing back the entire cdb.D. The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the cdb.E. A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

4.Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container:Which two statements are true?()A. Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.B. The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.C. The command will, create a common user whose description is contained in the root and each pdb.D. The schema for the common user C # # A_ADMIN can be different in each container.E. The command will create a user in the root container only because the container clause is not used

更多“单选题Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN. You want to issue the following RMAN command: RMAN BACK”相关问题

  • 第1题：

    Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs.Which three steps should you perform to recover the control file and make the database fully operational?（）

    A. Mount the container database (CDB) and restore the control file from the control file auto backup.

    B. Recover and open the CDB in NORMAL mode.

    C. Mount the CDB and then recover and open the database, with the RESETLOGS option.

    D. Open all the pluggable databases.

    E. Recover each pluggable database.

    F. Start the database instance in the nomount stage and restore the control file from control file auto backup.


    参考答案：C, D, F

  • 第2题：

    Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the database.You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF data file for the default permanent tablespace USERDATA belonging to ACCOUNTS_PDB is corrupted.What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB?（）

    A. Place CDB1 in the mount stage and then the USERDATA tablespace offline in ACCOUNTS_PDb.

    B. Place CDB1 in the mount stage and issue the ALTER PLUGGABLE DATABASE accounts_pdb CLOSE IMMEDIATE command.

    C. Issue the ALTER PLUGGABLE DATABASE accounts_pdb RESTRICTED command.

    D. Take the USERDATA tablespace offline in ACCOUNTS_PDb.


    参考答案：D

  • 第3题：

    You executed the following command in Recovery Manager （RMAN）：  RMAN> RESTORE CONTROLFILE；  Which operation must you perform before this command is executed？（） 

    • A、back up the control file to trace
    • B、bring database to the MOUNT state
    • C、open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database
    • D、set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

    正确答案:C

  • 第4题：

    Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the database. You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF data file for the default permanent tablespace USERDATA belonging to ACCOUNTS_PDB is corrupted. What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB?（）

    • A、Place CDB1 in the mount stage and then the USERDATA tablespace offline in ACCOUNTS_PDb.
    • B、Place CDB1 in the mount stage and issue the ALTER PLUGGABLE DATABASE accounts_pdb CLOSE IMMEDIATE command.
    • C、Issue the ALTER PLUGGABLE DATABASE accounts_pdb RESTRICTED command.
    • D、Take the USERDATA tablespace offline in ACCOUNTS_PDb.

    正确答案:D

  • 第5题：

    Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs. You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands: SQL > SHUTDOWN IMMEDIATE SQL > STARTUP MOUNT SQL > FLASHBACK DATABASE to TIME “TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)”; Examine following commands: 1. ALTER PLUGGABLE DATABASE ALL OPEN; 2. ALTER DATABASE OPEN; 3. ALTER DATABASE OPEN RESETLOGS; Which command or commands should you execute next to allow updates to the flashback back schema?（）

    • A、Only 1
    • B、Only 2
    • C、Only 3
    • D、3 and 1
    • E、1 and 2

    正确答案:C

  • 第6题：

    In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer. Which statement is true?（）

    • A、The CDB must be open.
    • B、The CDB must be in the mount stage.
    • C、The CDB must be in the nomount stage.
    • D、Alt existing PDBs must be closed.

    正确答案:A

  • 第7题：

    多选题
    Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）
    A

    when you change the name of a datafile

    B

    when you drop a table from the database

    C

    when you take an export of the database

    D

    when you back up the database using OS utilities

    E

    when you issue an ALTER SYSTEM SWITCH LOGFILE statement

    F

    when you issue a BACKUP command from inside the RMAN run block


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

  • 第8题：

    单选题
    You executed the following command in Recovery Manager （RMAN）：  RMAN> RESTORE CONTROLFILE；  Which operation must you perform before this command is executed？（）
    A

     back up the control file to trace

    B

     bring database to the MOUNT state

    C

     open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database

    D

     set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog


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

  • 第9题：

    多选题
    Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container: Which two statements are true?（）
    A

    Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.

    B

    The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.

    C

    The command will, create a common user whose description is contained in the root and each pdb.

    D

    The schema for the common user C # # A_ADMIN can be different in each container.

    E

    The command will create a user in the root container only because the container clause is not used


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

  • 第10题：

    单选题
    Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs. You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands: SQL > SHUTDOWN IMMEDIATE SQL > STARTUP MOUNT SQL > FLASHBACK DATABASE to TIME “TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)”; Examine following commands: 1. ALTER PLUGGABLE DATABASE ALL OPEN; 2. ALTER DATABASE OPEN; 3. ALTER DATABASE OPEN RESETLOGS; Which command or commands should you execute next to allow updates to the flashback back schema?（）
    A

    Only 1

    B

    Only 2

    C

    Only 3

    D

    3 and 1

    E

    1 and 2


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

  • 第11题：

    单选题
    Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN. Examine the following command and its output: You execute the following command: RMAN > BACKUP DATABASE PLUS ARCHIVELOG; Which data files will be backed up?（）
    A

    Data files that belong to only the root container

    B

    Data files that belong to the root container and all the pluggable databases (PDBs)

    C

    Data files that belong to only the root container and PDB$SEED

    D

    Data files that belong to the root container and all the PDBs excluding PDB$SEED


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

  • 第12题：

    单选题
    Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN. Examine the following command and its output: You execute the following command: RMAN > BACKUP DATABASE PLUS ARCHIVELOG; Which data files will be backed up?（）
    A

    Data files that belong to only the root container

    B

    Data files that belong to the root container and all the pluggable databases (PDBs)

    C

    Data files that belong to only the root container and PDB$SEED

    D

    Data files that belong to the root container and all the PDBs excluding PDB$SEED


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

  • 第13题：

    Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN.Examine the following command and its output:You execute the following command:RMAN > BACKUP DATABASE PLUS ARCHIVELOG;Which data files will be backed up?（）

    A. Data files that belong to only the root container

    B. Data files that belong to the root container and all the pluggable databases (PDBs)

    C. Data files that belong to only the root container and PDB$SEED

    D. Data files that belong to the root container and all the PDBs excluding PDB$SEED


    参考答案：B

  • 第14题：

    Which three statements are true about using flashback database in a multitenant container database(CDB)?（）

    • A、The root container can be flashed back without flashing back the pluggable databases (PDBs).
    • B、To enable flashback database, the CDB must be mounted.
    • C、Individual PDBs can be flashed back without flashing back the entire cdb.
    • D、The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the cdb.
    • E、A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

    正确答案:B,C,D

  • 第15题：

    Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN. Examine the following command and its output: You execute the following command: RMAN > BACKUP DATABASE PLUS ARCHIVELOG; Which data files will be backed up?（）

    • A、Data files that belong to only the root container
    • B、Data files that belong to the root container and all the pluggable databases (PDBs)
    • C、Data files that belong to only the root container and PDB$SEED
    • D、Data files that belong to the root container and all the PDBs excluding PDB$SEED

    正确答案:B

  • 第16题：

    Your database is in ARCHIVELOG mode. On Friday evening， you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager （RMAN） prompt and close the  database. On Monday， the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles， HR1.DBF and HR2.DBF， both of which belong to a read/write tablespace named HR. The disk also contains a datafile， USERS.DBF， which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database， you issue the following RMAN commands：        RMAN>RESTORE DATABASE；        RMAN>RECOVER DATABASE；   After successfully executing these RMAN commands， you issue the following statement using SQL*Plus：        SQL>ALTER DATABASE OPEN；   You receive the following errors when attempting to open the database：        ORA-01157： cannot identify/lock data file 10 see DBWR trace file        ORA-01110： data file 10： ’D:///USERS.DBF’   What is the cause of these errors？（）

    • A、 The USERS.DBF datafile is corrupted and cannot be restored by RMAN.
    • B、 The USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.
    • C、 The USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.
    • D、 The USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.

    正确答案:C

  • 第17题：

    Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the HR_PDB. You execute the following command: SQL > CREATE UNDO TABLESPACE undotb01 DATAFILE ‘u01/oracle/rddb1/undotbs01.dbf’ SIZE 60M AUTOEXTEND ON; What is the result?（）

    • A、It executes successfully and creates an UNDO tablespace in hr_pdb.
    • B、It falls and reports an error because there can be only one undo tablespace in a cdb.
    • C、It fails and reports an error because the CONTAINER=ALL clause is not specified in the command.
    • D、It fails and reports an error because the CONTAINER=CURRENT clause is not specified in the command.
    • E、It executes successfully but neither tablespace nor the data file is created.

    正确答案:E

  • 第18题：

    单选题
    Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the HR_PDB. You execute the following command: SQL > CREATE UNDO TABLESPACE undotb01 DATAFILE ‘u01/oracle/rddb1/undotbs01.dbf’ SIZE 60M AUTOEXTEND ON; What is the result?（）
    A

    It executes successfully and creates an UNDO tablespace in hr_pdb.

    B

    It falls and reports an error because there can be only one undo tablespace in a cdb.

    C

    It fails and reports an error because the CONTAINER=ALL clause is not specified in the command.

    D

    It fails and reports an error because the CONTAINER=CURRENT clause is not specified in the command.

    E

    It executes successfully but neither tablespace nor the data file is created.


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

  • 第19题：

    多选题
    Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs. Which three steps should you perform to recover the control file and make the database fully operational?（）
    A

    Mount the container database (CDB) and restore the control file from the control file auto backup.

    B

    Recover and open the CDB in NORMAL mode.

    C

    Mount the CDB and then recover and open the database, with the RESETLOGS option.

    D

    Open all the pluggable databases.

    E

    Recover each pluggable database.

    F

    Start the database instance in the nomount stage and restore the control file from control file auto backup.


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

  • 第20题：

    单选题
    Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the database. You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF data file for the default permanent tablespace USERDATA belonging to ACCOUNTS_PDB is corrupted. What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB?（）
    A

    Place CDB1 in the mount stage and then the USERDATA tablespace offline in ACCOUNTS_PDb.

    B

    Place CDB1 in the mount stage and issue the ALTER PLUGGABLE DATABASE accounts_pdb CLOSE IMMEDIATE command.

    C

    Issue the ALTER PLUGGABLE DATABASE accounts_pdb RESTRICTED command.

    D

    Take the USERDATA tablespace offline in ACCOUNTS_PDb.


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

  • 第21题：

    单选题
    Your database is in ARCHIVELOG mode. On Friday evening， you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager （RMAN） prompt and close the  database. On Monday， the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles， HR1.DBF and HR2.DBF， both of which belong to a read/write tablespace named HR. The disk also contains a datafile， USERS.DBF， which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database， you issue the following RMAN commands：        RMAN>RESTORE DATABASE；        RMAN>RECOVER DATABASE；   After successfully executing these RMAN commands， you issue the following statement using SQL*Plus：        SQL>ALTER DATABASE OPEN；   You receive the following errors when attempting to open the database：        ORA-01157： cannot identify/lock data file 10 see DBWR trace file        ORA-01110： data file 10： ’D:///USERS.DBF’   What is the cause of these errors？（）
    A

     The USERS.DBF datafile is corrupted and cannot be restored by RMAN.

    B

     The USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.

    C

     The USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.

    D

     The USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.


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

  • 第22题：

    单选题
    Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN. You want to issue the following RMAN command: RMAN > BACKUP TABLESPACE hr_pdb:userdata; Which task should you perform before issuing the command?（）
    A

    Place the root container in ARHCHIVELOG mode.

    B

    Take the user data tablespace offline.

    C

    Place the root container in the nomount stage.

    D

    Ensure that HR_PDB is open.


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

  • 第23题：

    单选题
    In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer. Which statement is true?（）
    A

    The CDB must be open.

    B

    The CDB must be in the mount stage.

    C

    The CDB must be in the nomount stage.

    D

    Alt existing PDBs must be closed.


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

相关内容