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.
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.
相关考题：
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.
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.
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.
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
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).
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.
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.
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 system administrator needs to specify a set of FQDN to IP address mappings for a legacyserver； the administrator does not want the legacy server to be referenced by other servers. Which of the following should the administrator use to set this？（）A、DHCP serverB、DNS serverC、Host fileD、Route statements
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.
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).
You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this？（）A、Set the UNDO_RETENTION parameter to AUTO.B、Create an initial undo segment in undotablespace.C、Set the UNDO_RETENTION parameter to 900 or moreD、Set the initialization parameter UNDO_MANAGEMENT to AUTOE、Set the UNDO_MANAGEMENT parameter to the name of an undotablespace
You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA. While observing the server settings， you find that the following parameter has been set in the parameter file of the database： REMOTE_OS_AUTHENT = TRUE What could have been the reason to set this parameter as TRUE？（）A、to enable operating system authentication for a remote clientB、to restrict the scope of administration to identical operating systemsC、to allow the start up and shut down of the database from a remote clientD、to enable the administration of the operating system from a remote clientE、to disable the administration of the operating system from a remote client
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 containerB、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$SEEDD、Data files that belong to the root container and all the PDBs excluding PDB$SEED
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.
Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database？（） A、 Yes， if the database is in ARCHIVELOG modeB、 Yes， if the database is in NOARCHIVELOG modeC、 No， the backup is not usable in any wayD、 Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE
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.
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.
单选题You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA. While observing the server settings， you find that the following parameter has been set in the parameter file of the database： REMOTE_OS_AUTHENT = TRUE What could have been the reason to set this parameter as TRUE？（）Ato enable operating system authentication for a remote clientBto restrict the scope of administration to identical operating systemsCto allow the start up and shut down of the database from a remote clientDto enable the administration of the operating system from a remote clientEto disable the administration of the operating system from a remote client
单选题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?（）AThe STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.BThe STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.CThe STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.DNothing happens; because there is no SPFILE for each PDB, the statement is ignored.
多选题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?（）AYou can conned as a common user by using the connect statement.BYou can connect as a local user by using the connect statement.CYou can connect by using easy connect.DYou can connect by using OS authentication.EYou can connect by using a Net Service name.FYou can connect as a local user by using the SET CONTAINER statement.
多选题Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container: Which two statements are true?（）ASchema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.BThe C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.CThe command will, create a common user whose description is contained in the root and each pdb.DThe schema for the common user C # # A_ADMIN can be different in each container.EThe command will create a user in the root container only because the container clause is not used
单选题Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database？（）A Yes， if the database is in ARCHIVELOG modeB Yes， if the database is in NOARCHIVELOG modeC No， the backup is not usable in any wayD Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE
多选题Which three statements are true concerning the multitenant architecture?（）AEach pluggable database (PDB) has its own set of background processes.BA PDB can have a private temp tablespace.CPDBs can share the sysaux tablespace.DLog switches occur only at the multitenant container database (CDB) level.EDifferent PDBs can have different default block sizes.FPDBs share a common system tablespace.GInstance recovery is always performed at the CDB level.
多选题Which three statements are true about the working of system privileges in a multitenant control database(CDB) that has pluggable databases (PDBs)?（）ASystem privileges apply only to the PDB in which they are used.BLocal users cannot use local system privileges on the schema of a common user.CThe granter of system privileges must possess the set container privilege.DCommon users connected to a PDB can exercise privileges across other PDBs.ESystem 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.
单选题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?（）AIt succeeds because the PDB_ADMIN user has the required privileges.BIt fails because common users are unable to use the SET CONTAINER statement.CIt fails because local users are unable to use the SET CONTAINER statement.DIf fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).
单选题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?（）AThe CDB must be open.BThe CDB must be in the mount stage.CThe CDB must be in the nomount stage.DAlt existing PDBs must be closed.