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

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

题目
多选题
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).

参考答案和解析
正确答案： C,D
解析： 暂无解析
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

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.


参考答案：D

第2题：

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


参考答案：A, B, C

第3题：

Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container:Which two statements are true?()

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

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

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

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

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


参考答案：B, E

第4题：

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

第5题：

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

第6题：

What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATEDATABASE” statement?()

A. It will create a multitenant container database (CDB) with only the root opened.

B. It will create a CDB with root opened and seed read only.

C. It will create a CDB with root and seed opened and one PDB mounted.

D. It will create a CDB that must be plugged into an existing cdb.

E. It will create a CDB with root opened and seed mounted.


参考答案：B

第7题：

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

第8题：

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

第9题：

You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance， you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data， you want to have minimal impact on the database performance and optimize the dataload operation.  Which method would you use to load data into the Oracle database（）

  • A、Use the external table population.
  • B、Use the Oracle Data Pump export and import utility.
  • C、Use the conventional path data load of the SQL*Loader utility.
  • D、Use the INSERT INTO...SELECT command to load the data

正确答案:C

第10题：

If you create your database using Oracle Managed Files （OMF）， what is true？（）

  • A、You must use Oracle predefined names to identify raw partitions that will hold OMF structures. 
  • B、You must define directories for two online redo log groups and three copies of the control file. 
  • C、If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically. 
  • D、You must use only OMF data files when adding new tablespaces or data files to your database in the future.

正确答案:D

更多相关问题
相关内容