itgle.com

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

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

相似考题

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

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

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

更多“单选题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 ”相关问题

  • 第1题：

    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

  • 第2题：

    You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories.You plan to create the database using SQL statements.Which three techniques can you use to achieve this?（）

    A. Use Oracle Managed Files (OMF).

    B. Specify the SEED FILE_NAME_CONVERT clause.

    C. Specify the PDB_FILE_NAME_CONVERT initialization parameter.

    D. Specify the DB_FILE_NAMECONVERT initialization parameter.

    E. Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).


    参考答案：A, B, C

  • 第3题：

    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

  • 第4题：

    Which statement is true concerning dropping a pluggable database (PDB)?（）

    • A、The PDB must be open in read-only mode.
    • B、The PDB must be in mount state.
    • C、The PDB must be unplugged.
    • D、The PDB data files are always removed from disk.
    • E、A dropped PDB can never be plugged back into a multitenant container database (CDB).

    正确答案:B

  • 第5题：

    You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories. You plan to create the database using SQL statements. Which three techniques can you use to achieve this?（）

    • A、Use Oracle Managed Files (OMF).
    • B、Specify the SEED FILE_NAME_CONVERT clause.
    • C、Specify the PDB_FILE_NAME_CONVERT initialization parameter.
    • D、Specify the DB_FILE_NAMECONVERT initialization parameter.
    • E、Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).

    正确答案:A,B,C

  • 第6题：

    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

  • 第7题：

    An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges. A multitenant container database (CDB) instant has the following parameter set: THREADED_EXECUTION = FALSE Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode?（）

    • A、You can conned as a common user by using the connect statement.
    • B、You can connect as a local user by using the connect statement.
    • C、You can connect by using easy connect.
    • D、You can connect by using OS authentication.
    • E、You can connect by using a Net Service name.
    • F、You can connect as a local user by using the SET CONTAINER statement.

    正确答案:C,D,E,F

  • 第8题：

    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

  • 第9题：

    单选题
    In your multitenant container database (CDB) containing pluggable database (PDBs), you granted theCREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs. You execute thefollowing command from the root container:SQL > REVOKE create table FROM C # # A_ADMIN;What is the result?（）
    A

    It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.

    B

    It fails and reports an error because the CONTAINER=ALL clause is not used.

    C

    It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.

    D

    It fails and reports an error because the CONTAINER=CURRENT clause is not used.

    E

    It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.


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

  • 第10题：

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

  • 第11题：

    多选题
    You run a script that completes successfully using SQL*Plus that performs these actions: 1. Creates a multitenant container database (CDB) 2. Plugs in three pluggable databases (PDBs) 3. Shuts down the CDB instance 4. Starts up the CDB instance using STARTUP OPEN READ WRITE Which two statements are true about the outcome after running the script?（）
    A

    The seed will be in mount state.

    B

    The seed will be opened read-only.

    C

    The seed will be opened read/write.

    D

    The other PDBs will be in mount state.

    E

    The other PDBs will be opened read-only.

    F

    The PDBs will be opened read/write.


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

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

    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

  • 第14题：

    Which statement is true concerning dropping a pluggable database (PDB)?()

    A. The PDB must be open in read-only mode.

    B. The PDB must be in mount state.

    C. The PDB must be unplugged.

    D. The PDB data files are always removed from disk.

    E. A dropped PDB can never be plugged back into a multitenant container database (CDB).


    参考答案：B

  • 第15题：

    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

  • 第16题：

    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

  • 第17题：

    You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege. The CDB has several pluggable databases (PDBs) open in the read/write mode. There are ongoing transactions in both the CDB and PDBs. What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?（）

    • A、The shutdown proceeds immediately. The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolledhack.
    • B、The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.
    • C、The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back.
    • D、The statement results in an error because there are open PDBs.

    正确答案:B

  • 第18题：

    You run a script that completes successfully using SQL*Plus that performs these actions: 1. Creates a multitenant container database (CDB) 2. Plugs in three pluggable databases (PDBs) 3. Shuts down the CDB instance 4. Starts up the CDB instance using STARTUP OPEN READ WRITE Which two statements are true about the outcome after running the script?（）

    • A、The seed will be in mount state.
    • B、The seed will be opened read-only.
    • C、The seed will be opened read/write.
    • D、The other PDBs will be in mount state.
    • E、The other PDBs will be opened read-only.
    • F、The PDBs will be opened read/write.

    正确答案:B,D

  • 第19题：

    In your multitenant container database (CDB) containing pluggable database (PDBs), you granted theCREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs. You execute thefollowing command from the root container:SQL > REVOKE create table FROM C # # A_ADMIN;What is the result?（）

    • A、It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.
    • B、It fails and reports an error because the CONTAINER=ALL clause is not used.
    • C、It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.
    • D、It fails and reports an error because the CONTAINER=CURRENT clause is not used.
    • E、It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.

    正确答案:A

  • 第20题：

    单选题
    You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege. The CDB has several pluggable databases (PDBs) open in the read/write mode. There are ongoing transactions in both the CDB and PDBs. What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?（）
    A

    The shutdown proceeds immediately. The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolledhack.

    B

    The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.

    C

    The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back.

    D

    The statement results in an error because there are open PDBs.


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

  • 第21题：

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

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

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

  • 第24题：

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

相关内容