题目内容（请给出正确答案）

[主观题]

You want to set the following initialization parameters for your database instance：Identify the statement that correctly describes this setting.（）

You want to set the following initialization param

A. The MANDATORY location must be a flash recovery area.

B. The optional destinations may not use the flash recovery area.

C. This setting is not allowed because the first destination is not set as MANDATORY.

D. The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.

查看答案

如搜索结果不匹配，请联系老师获取答案

您可能会需要：

重置密码查看订单联系客服

安装赏学吧APP，拍照搜题省时又省心！

更多“You want to set the following …”相关的问题

第1题

You are managing an Oracle Database 11g database with the ASM storage. The database is hav

ing big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps.What configuration would you effect to achieve your objective？（）

A. Set the ASM compatibility attribute for the ASM disk group to 11.1.0.

B. Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.

C. Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.

D. Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.

点击查看答案

第2题

You are managing an Oracle Database 11g database. You want to take a backup on tape drives

of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command:RMAN> BACKUPSECTION SIZE 300M TABLESPACE users;Identify the appropriate configuration to accomplish faster and optimized backups using the above command.（）

A. The SBT channel must be configured, with the MAXPIECESIZE set to 300 mb.

B. The SBT channel must be configured, with the parallelism setting for the SBT devices set to 3.

C. The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.

D. The SBT channel must be configured, with the default parallelism setting for the SBT devices set to 1

点击查看答案

第3题

You want to set the following initialization parameters for your database instance:LOG_ARC

HIVE_DEST_1 = ‘LOCATION=/disk1/arch‘LOG_ARCHIVE_DEST_2 = ‘LOCATION=/disk2/arch‘LOG_ARCHIVE_DEST_3 = ‘LOACTION=/disk3/arch‘LOG_ARCHIVE_DEST_4 = ‘LOCATION=/disk4/arch MANDATORY‘Identify the statement that correctly describes this setting.（）

A. The MANDATORY location must be a flash recovery area.

B. The optional destinations may not use the flash recovery area.

C. This setting is not allowed because the first destination is not set as MANDATORY.

D. The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.

点击查看答案

第4题

Which two initialization parameters would you set to enable Automatic Shared Memory Management？（）

A. set SHARED_POOL_SIZE to zero

B. set STATISTICS_LEVEL to BASIC

C. set SGA_TARGET to a non-zero value

D. set DB_CACHE_SIZE to a non-zero value

E. set STATISTICS_LEVEL to TYPICAL or ALL

点击查看答案

第5题

The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuratio

n. You executed the following command to startup the Automatic Storage Management (ASM) instance.SQL> STARTUP;Which two activities are performed during a successful start up operation？（）

A. The databases configured to use the ASM instance are mounted

B. The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter

C. ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not started

D. ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters

点击查看答案

第6题

The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuratio

n. You executed the following command to startup the Automatic Storage Management (ASM) instance.SQL> STARTUP;Which two activities are performed during a successful start up operation？（）(Choose two.)

A. The databases configured to use the ASM instance are mounted

B. The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter

C. ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not started

D. ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters

点击查看答案

第7题

You want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level？（）

A. issuing the ALTER SYSTEM ENABLE RESUMABLE; statement

B. issuing the ALTER SESSION ENABLE RESUMABLE; statement

C. modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero value

D. issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=<nonzero value>; statement

点击查看答案

第8题

You want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level？（）（Choose two.)

A. issuing the ALTER SYSTEM ENABLE RESUMABLE; statement

B. issuing the ALTER SESSION ENABLE RESUMABLE; statement

C. modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero value

D. issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=; statement

点击查看答案

第9题

You are planning the creation of a new multitenant container database （CDB) and want to st

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

点击查看答案