违法和不良信息举报 联系客服
免费注册 登录

多选题You run a script that completes successfully using SQL*Plus that performs these actions: 1. Creates a multitenant container database (CDB) 2. Plugs in three pluggable databases (PDBs) 3. Shuts down the CDB instance 4. Starts up the CDB instance using S

题目
多选题
You run a script that completes successfully using SQL*Plus that performs these actions: 1. Creates a multitenant container database (CDB) 2. Plugs in three pluggable databases (PDBs) 3. Shuts down the CDB instance 4. Starts up the CDB instance using STARTUP OPEN READ WRITE Which two statements are true about the outcome after running the script?（）
A

The seed will be in mount state.

B

The seed will be opened read-only.

C

The seed will be opened read/write.

D

The other PDBs will be in mount state.

E

The other PDBs will be opened read-only.

F

The PDBs will be opened read/write.

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

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.


参考答案：B, D, G

第2题：

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


参考答案：B

第3题：

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


参考答案：A

第4题：

Which two statements are true concerning the Resource Manager plans for individual pluggabledatabases (PDB plans) in a multitenant container database (CDB)?（）

  • A、If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that pdb.
  • B、In a PDB plan, subplans may be used with up to eight consumer groups.
  • C、If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the cdb.
  • D、If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
  • E、If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

正确答案:A,B,C,D,E

第5题：

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.

正确答案:B,C,D

第6题：

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.


参考答案：C, D, F

第7题：

Identify two correct statements about multitenant architectures.（）

  • A、Multitenant architecture can be deployed only in a Real Application Clusters (RAC) configuration.
  • B、Multiple pluggable databases (PDBs) share certain multitenant container database (CDB) resources.
  • C、Multiple CDBs share certain PDB resources.
  • D、Multiple non-RAC CDB instances can mount the same PDB as long as they are on the same server.
  • E、Patches are always applied at the CDB level.
  • F、A PDB can have a private undo tablespace.

正确答案:B,E

第8题：

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.


参考答案：B, C, D

第9题：

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.

正确答案:B

第10题：

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

正确答案:B

更多相关问题
相关内容