It succeeds because the PDB_ADMIN user has the required privileges.
It fails because common users are unable to use the SET CONTAINER statement.
It fails because local users are unable to use the SET CONTAINER statement.
If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).
第1题:
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
第2题:
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.
第3题:
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.
第4题:
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?()
第5题:
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
第6题:
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).
第7题:
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).
第8题:
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.
第9题:
Which three statements are true about using flashback database in a multitenant container database(CDB)?()
第10题:
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?()