电子商务务安全要求的四个方面是A．传输的高效性、数据的完整性、交易各方的身份认证和交易的不可抵

In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation.How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions？（）

A. It collects data from SGA and compares it with a preserved snapshot.

B. It collects data from SGA, analyzes it, and provides a report.

C. It collects data from SGA and compares it with the latest snapshot.

D. It collects data from both SGA and PGA, analyzes it, and provides a report

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.

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.

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.

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

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

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.

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