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

You can conned as a common user by using the connect statement.

You can connect as a local user by using the connect statement.

You can connect by using easy connect.

You can connect by using OS authentication.

You can connect by using a Net Service name.

You can connect as a local user by using the SET CONTAINER statement.

Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.

The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.

The command will, create a common user whose description is contained in the root and each pdb.

The schema for the common user C # # A_ADMIN can be different in each container.

The command will create a user in the root container only because the container clause is not used

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

A PDB can have a private temp tablespace.

PDBs can share the sysaux tablespace.

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

Different PDBs can have different default block sizes.

PDBs share a common system tablespace.

Instance recovery is always performed at the CDB level.

Use Oracle Managed Files (OMF).

Specify the SEED FILE_NAME_CONVERT clause.

Specify the PDB_FILE_NAME_CONVERT initialization parameter.

Specify the DB_FILE_NAMECONVERT initialization parameter.

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

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

The C # # ROLE1 role is created in the root database and all the PDBs.

The C # # ROLE1 role is created only in the root database because the container clause is not used.

Privileges are granted to the C##A_ADMIN user only in the root database.

Privileges are granted to the C##A_ADMIN user in the root database and all PDBs.

The statement for granting a role to a user fails because the CONTAINER clause is not used.

The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.

The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.

The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.

Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.

The PDB must be open in read only mode.

The PDB must be dosed.

The unplugged PDB becomes a non-cdb.

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

The unplugged PDB can be plugged into another cdb.

The PDB data files are automatically removed from disk.

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

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

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

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

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

The root container can be flashed back without flashing back the pluggable databases (PDBs).

To enable flashback database, the CDB must be mounted.

Individual PDBs can be flashed back without flashing back the entire cdb.

The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the cdb.

A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

System privileges apply only to the PDB in which they are used.

Local users cannot use local system privileges on the schema of a common user.

The granter of system privileges must possess the set container privilege.

Common users connected to a PDB can exercise privileges across other PDBs.

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.

The CDB must be open.

The CDB must be in the mount stage.

The CDB must be in the nomount stage.

Alt existing PDBs must be closed.