itgle.com

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

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

相似考题

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

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

参考答案和解析
正确答案： B
解析： 暂无解析
更多“单选题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 ”相关问题

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

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

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

    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

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

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

  • 第7题：

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

  • 第8题：

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

  • 第9题：

    单选题
    Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root container. The steps to recover the tablespace are as follows: 1. Mount the CDB. 2. Close all the PDBs. 3. Open the database. 4. Apply the archive redo logs. 5. Restore the data file. 6. Take the SYSAUX tablespace offline. 7. Place the SYSAUX tablespace online. 8. Open all the PDBs with RESETLOGS. 9. Open the database with RESETLOGS. 10. Execute the command SHUTDOWN ABORT. Which option identifies the correct sequence to recover the SYSAUX tablespace?（）
    A

    6，5，4，7

    B

    10，1，2，5，8

    C

    10，1，2，5，4，9，8

    D

    10，1，5，8，10


    正确答案： 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题：

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


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

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

    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

  • 第15题：

    Which three statements are true about the working of system privileges in a multitenant control database(CDB) that has pluggable databases (PDBs)?（）

    • A、System privileges apply only to the PDB in which they are used.
    • B、Local users cannot use local system privileges on the schema of a common user.
    • C、The granter of system privileges must possess the set container privilege.
    • D、Common users connected to a PDB can exercise privileges across other PDBs.
    • E、System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users.

    正确答案:A,C,E

  • 第16题：

    You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs). Examine the query and its output: Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file?（）

    • A、Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.
    • B、Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
    • C、Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.
    • D、Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.
    • E、Re-create the password file in the Oracle Database 12c format.

    正确答案:B,D

  • 第17题：

    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

  • 第18题：

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

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


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

  • 第20题：

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

  • 第21题：

    多选题
    You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs). Examine the query and its output: Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file?（）
    A

    Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.

    B

    Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.

    C

    Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.

    D

    Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.

    E

    Re-create the password file in the Oracle Database 12c format.


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

  • 第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
    解析： 暂无解析

  • 第24题：

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


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

相关内容