网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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 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?（）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 statement is true about Enterprise Manager (EM) express in Oracle Database 12c?（）A
By default, EM express is available for a database after database creation.B
You can use EM express to manage multiple databases running on the same server.C
You can perform basic administrative tasks for pluggable databases by using the EM express interface.D
You cannot start up or shut down a database Instance by using EM express.E
You 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?（）A
Setting a metric thresholdB
Implementing Database Resource ManagerC
Enabling resumable timeout for user sessionsD
Decreasing 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?（）A
Setting a metric thresholdB
Implementing Database Resource ManagerC
Enabling resumable timeout for user sessionsD
Decreasing the value of the IDLE_TIME resource limit in the default profile
考题
单选题Which statement is true concerning dropping a pluggable database (PDB)?（）A
The PDB must be open in read-only mode.B
The PDB must be in mount state.C
The PDB must be unplugged.D
The PDB data files are always removed from disk.E
A 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?（）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
考题
多选题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.
热门标签
最新试卷
