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 priv

题目

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.
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

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

第2题:

Which three resources might be prioritized between competing pluggable databases when creating amultitenant container database plan (CDB plan) using Oracle Database Resource Manager?()

A. Maximum Undo per consumer group

B. Maximum Idle time

C. Parallel server limit

D. CPU

E. Exadata I/O

F. Local file system I/O


参考答案:C, D, F

第3题:

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


参考答案:A, C

第4题:

Which three statements are true concerning unplugging a pluggable database (PDB)?()

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

B. The PDB must be dosed.

C. The unplugged PDB becomes a non-cdb.

D. The unplugged PDB can be plugged into the same multitenant container database (CDB)

E. The unplugged PDB can be plugged into another cdb.

F. The PDB data files are automatically removed from disk.


参考答案:B, D, E

第5题:

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

第6题:

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.


参考答案:B, C

第7题:

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


参考答案:A

第8题:

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

第9题:

Which three statements are true concerning the multitenant architecture?()

A. Each pluggable database (PDB) has its own set of background processes.

B. A PDB can have a private temp tablespace.

C. PDBs can share the sysaux tablespace.

D. Log switches occur only at the multitenant container database (CDB) level.

E. Different PDBs can have different default block sizes.

F. PDBs share a common system tablespace.

G. Instance recovery is always performed at the CDB level.


参考答案:B, D, G

第10题:

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

更多相关问题