单选题You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB). The characteristics of the non-CDB are as follows: -Version: Oracle Database 12c Releases 1 64-bit -Character set: WE8IS

题目
单选题
You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB). The characteristics of the non-CDB are as follows: -Version: Oracle Database 12c Releases 1 64-bit -Character set: WE8ISO8859P15 -National character set: AL16UTF16 -O/S: Oracle Linux 6 64-bit The characteristics of the CDB are as follows: -Version: Oracle Database 12c Release 1 64-bit -Character set: AL32UTF8 -O/S: Oracle Linux 6 64-bit Which technique should you use to minimize down time while plugging this non-CDB into the CDB?（）
A

Transportable database

B

Transportable tablespace

C

Data Pump full export / import

D

The DBMS_PDB package

E

RMAN

相似考题

1.Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.Which two RMAN commands may be; used to back up only the PDB1 pluggable database?()A. BACKUP PLUGGABLE DATABASE PDB1 while connected to the root containerB. BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 containerC. BACKUP DATABASE while connected to the PDB1 containerD. BACKUP DATABASE while connected to the boot containerE. BACKUP PLUGGABLE database PDB1 while connected to PDB2

2.You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB).The characteristics of the non-CDB are as follows:-Version: Oracle Database 12c Releases 1 64-bit -Character set: WE8ISO8859P15 -National characterset: AL16UTF16 -O/S: Oracle Linux 6 64-bitThe characteristics of the CDB are as follows: -Version: Oracle Database 12c Release 1 64-bit -Characterset: AL32UTF8 -O/S: Oracle Linux 6 64-bitWhich technique should you use to minimize down time while plugging this non-CDB into the CDB?（）A. Transportable databaseB. Transportable tablespaceC. Data Pump full export / importD. The DBMS_PDB packageE. RMAN

3.You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privilegesand execute the following sequence statements:What is the result of the last SET CONTAINER statement and why is it so?（）A. It succeeds because the PDB_ADMIN user has the required privileges.B. It fails because common users are unable to use the SET CONTAINER statement.C. It fails because local users are unable to use the SET CONTAINER statement.D. If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).

4.You are connected to a pluggable database (PDB) as a common user with DBA privileges.The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following:SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE;Which is true about the result of this command?（）A. The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.B. The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.C. The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.D. Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.

参考答案和解析
正确答案： C
解析： 暂无解析
更多“单选题You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB). The characteristics of the non-CDB are as follows: -Version: Oracle Database 12c Releases 1 64-bit -Character set: WE8IS”相关问题

  • 第1题：

    You are required to migrate your 11.2.0.3 database as a pluggable database (PDB) to a multitenant container database (CDB).The following are the possible steps to accomplish this task:1. Place all the user-defined tablespace in read-only mode on the source database.2. Upgrade the source database to a 12c version.3. Create a new PDB in the target container database.4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility.5. Copy the associated data files and export the dump file to the desired location in the target database.6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function.Identify the correct order of the required steps.（）

    A.2，1，3，4，5，6

    B.1，3，4，5，6，7

    C.1，4，3，5，6，7

    D.2，1，3，4，5，6，7

    E.1，5，6，4，3，2


    参考答案：C

  • 第2题：

    What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATEDATABASE” statement?()

    A. It will create a multitenant container database (CDB) with only the root opened.

    B. It will create a CDB with root opened and seed read only.

    C. It will create a CDB with root and seed opened and one PDB mounted.

    D. It will create a CDB that must be plugged into an existing cdb.

    E. It will create a CDB with root opened and seed mounted.


    参考答案：B

  • 第3题：

    You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB). The characteristics of the non-CDB are as follows: -Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit -Character set: AL32UTF8 -National character set: AL16UTF16 -O/S: Oracle Linux 6 64-bit The characteristics of the CDB are as follows: -Version: Oracle Database 12c Release 1 64-bit -Character Set: AL32UTF8 -National character set: AL16UTF16 -O/S: Oracle Linux 6 64-bit Which technique should you use to minimize down time while plugging this non-CDB into the CDB?（）

    • A、Transportable database
    • B、Transportable tablespace
    • C、Data Pump full export/import
    • D、The DBMS_PDB package
    • E、RMAN

    正确答案:B

  • 第4题：

    Which two statements are true concerning the Resource Manager plans for individual pluggabledatabases (PDB plans) in a multitenant container database (CDB)?（）

    • A、If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that pdb.
    • B、In a PDB plan, subplans may be used with up to eight consumer groups.
    • C、If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the cdb.
    • D、If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
    • E、If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

    正确答案:A,B,C,D,E

  • 第5题：

    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

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

    单选题
    You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB). The characteristics of the non-CDB are as follows: -Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit -Character set: AL32UTF8 -National character set: AL16UTF16 -O/S: Oracle Linux 6 64-bit The characteristics of the CDB are as follows: -Version: Oracle Database 12c Release 1 64-bit -Character Set: AL32UTF8 -National character set: AL16UTF16 -O/S: Oracle Linux 6 64-bit Which technique should you use to minimize down time while plugging this non-CDB into the CDB?（）
    A

    Transportable database

    B

    Transportable tablespace

    C

    Data Pump full export/import

    D

    The DBMS_PDB package

    E

    RMAN


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

  • 第8题：

    单选题
    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
    解析： 暂无解析

  • 第9题：

    多选题
    Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.Which two RMAN commands may be; used to back up only the PDB1 pluggable database?（）
    A

    BACKUP PLUGGABLE DATABASE PDB1 while connected to the root container

    B

    BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 container

    C

    BACKUP DATABASE while connected to the PDB1 container

    D

    BACKUP DATABASE while connected to the boot container

    E

    BACKUP PLUGGABLE database PDB1 while connected to PDB2


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

  • 第10题：

    单选题
    You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privilegesand execute the following sequence statements:What is the result of the last SET CONTAINER statement and why is it so?（）
    A

    It succeeds because the PDB_ADMIN user has the required privileges.

    B

    It fails because common users are unable to use the SET CONTAINER statement.

    C

    It fails because local users are unable to use the SET CONTAINER statement.

    D

    If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).


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

  • 第11题：

    单选题
    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
    解析： 暂无解析

  • 第12题：

    单选题
    You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB). The characteristics of the non-CDB are as follows: -Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit -Character set: AL32UTF8 -National character set: AL16UTF16 -O/S: Oracle Linux 6 64-bit The characteristics of the CDB are as follows: -Version: Oracle Database 12c Release 1 64-bit -Character Set: AL32UTF8 -National character set: AL16UTF16 -O/S: Oracle Linux 6 64-bit Which technique should you use to minimize down time while plugging this non-CDB into the CDB?（）
    A

    Transportable database

    B

    Transportable tablespace

    C

    Data Pump full export/import

    D

    The DBMS_PDB package

    E

    RMAN


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

  • 第13题：

    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.


    参考答案：D

  • 第14题：

    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

  • 第15题：

    What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATEDATABASE” statement?（）

    • A、It will create a multitenant container database (CDB) with only the root opened.
    • B、It will create a CDB with root opened and seed read only.
    • C、It will create a CDB with root and seed opened and one PDB mounted.
    • D、It will create a CDB that must be plugged into an existing cdb.
    • E、It will create a CDB with root opened and seed mounted.

    正确答案:B

  • 第16题：

    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

  • 第17题：

    You are required to migrate your 11.2.0.3 database as a pluggable database (PDB) to a multitenant container database (CDB). The following are the possible steps to accomplish this task: 1. Place all the user-defined tablespace in read-only mode on the source database. 2. Upgrade the source database to a 12c version. 3. Create a new PDB in the target container database. 4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility. 5. Copy the associated data files and export the dump file to the desired location in the target database. 6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options. 7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function. Identify the correct order of the required steps.（）

    • A、2，1，3，4，5，6
    • B、1，3，4，5，6，7
    • C、1，4，3，5，6，7
    • D、2，1，3，4，5，6，7
    • E、1，5，6，4，3，2

    正确答案:C

  • 第18题：

    单选题
    You are required to migrate your 11.2.0.3 database as a pluggable database (PDB) to a multitenant container database (CDB). The following are the possible steps to accomplish this task: 1. Place all the user-defined tablespace in read-only mode on the source database. 2. Upgrade the source database to a 12c version. 3. Create a new PDB in the target container database. 4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility. 5. Copy the associated data files and export the dump file to the desired location in the target database. 6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options. 7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function. Identify the correct order of the required steps.（）
    A

    2，1，3，4，5，6

    B

    1，3，4，5，6，7

    C

    1，4，3，5，6，7

    D

    2，1，3，4，5，6，7

    E

    1，5，6，4，3，2


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

  • 第19题：

    单选题
    You are connected to a pluggable database (PDB) as a common user with DBA privileges. The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following: SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE; Which is true about the result of this command?（）
    A

    The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.

    B

    The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.

    C

    The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.

    D

    Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.


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

  • 第20题：

    单选题
    You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB). The characteristics of the non-CDB are as follows: -Version: Oracle Database 12c Releases 1 64-bit -Character set: WE8ISO8859P15 -National character set: AL16UTF16 -O/S: Oracle Linux 6 64-bit The characteristics of the CDB are as follows: -Version: Oracle Database 12c Release 1 64-bit -Character set: AL32UTF8 -O/S: Oracle Linux 6 64-bit Which technique should you use to minimize down time while plugging this non-CDB into the CDB?（）
    A

    Transportable database

    B

    Transportable tablespace

    C

    Data Pump full export / import

    D

    The DBMS_PDB package

    E

    RMAN


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

  • 第21题：

    单选题
    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
    解析： 暂无解析

  • 第22题：

    单选题
    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
    解析： 暂无解析

  • 第23题：

    多选题
    Which two statements are true concerning the Resource Manager plans for individual pluggabledatabases (PDB plans) in a multitenant container database (CDB)?（）
    A

    If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that pdb.

    B

    In a PDB plan, subplans may be used with up to eight consumer groups.

    C

    If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the cdb.

    D

    If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.

    E

    If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.


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

相关内容