单选题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?()AThe shutdown proceeds immediately. The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolledhack.BThe shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.CThe shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back.DThe statement results in an error because there are open PDBs.

单选题
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?()
A

The shutdown proceeds immediately. The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolledhack.

B

The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.

C

The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back.

D

The statement results in an error because there are open PDBs.


参考解析

解析: 暂无解析

相关考题:

单选题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.

单选题Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?()ABy default, EM express is available for a database after database creation.BYou can use EM express to manage multiple databases running on the same server.CYou can perform basic administrative tasks for pluggable databases by using the EM express interface.DYou cannot start up or shut down a database Instance by using EM express.EYou can create and configure pluggable databases by using EM express.

单选题In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time. How would you accomplish this?()ASetting a metric thresholdBImplementing Database Resource ManagerCEnabling resumable timeout for user sessionsDDecreasing the value of the IDLE_TIME resource limit in the default profile

单选题In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time. How would you accomplish this?()ASetting a metric thresholdBImplementing Database Resource ManagerCEnabling resumable timeout for user sessionsDDecreasing the value of the IDLE_TIME resource limit in the default profile

单选题Which statement is true concerning dropping a pluggable database (PDB)?()AThe PDB must be open in read-only mode.BThe PDB must be in mount state.CThe PDB must be unplugged.DThe PDB data files are always removed from disk.EA dropped PDB can never be plugged back into a multitenant container database (CDB).

单选题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?()AData files that belong to only the root containerBData files that belong to the root container and all the pluggable databases (PDBs)CData files that belong to only the root container and PDB$SEEDDData files that belong to the root container and all the PDBs excluding PDB$SEED

多选题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?()AAssign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.BGrant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.CRe-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.DRe-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.ERe-create the password file in the Oracle Database 12c format.