多选题Which two statements are true about variable extent size support for large ASM files?()AThe metadata used to track extents in SGA is reduced.BRebalance operations are completed faster than with a fixed extent sizeCAn ASM Instance automatically allocate

题目
多选题
Which two statements are true about variable extent size support for large ASM files?()
A

The metadata used to track extents in SGA is reduced.

B

Rebalance operations are completed faster than with a fixed extent size

C

An ASM Instance automatically allocates an appropriate extent size.

D

Resync operations are completed faster when a disk comes online after being taken offline.

E

Performance improves in a stretch cluster configuration by reading from a local copy of an extent.

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

第1题:

Which two statements are true about Oracle Managed Files (OMF)?()

A. OMF cannot be used in a database that already has data files created with user-specified directions.

B. The file system directions that are specified by OMF parameters are created automatically.

C. OMF can be used with ASM disk groups, as well as with raw devices, for better file management.

D. OMF automatically creates unique file names for table spaces and control files.

E. OMF may affect the location of the redo log files and archived log files.


参考答案:B, D

第2题:

Which two statements are true regarding an Automatic Storage Management (ASM) instance? ()

  • A、As ASM instance mounts an ASM control file
  • B、An ASM instance uses the ASMB process for rebalancing of disks within a disk group
  • C、Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly
  • D、An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

正确答案:C,D

第3题:

The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. 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


参考答案:B, C

第4题:

The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. 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

正确答案:B,C

第5题:

You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the COMPATIBLE.ASM attribute is set to 11.1. Which two statements are true in this scenario for the features enabled for ASM? ()

  • A、The ASM-preferred mirror read feature is enabled.
  • B、The ASM supports variable sizes for extents of 1, 8, and 64 allocation units.
  • C、The ASM disk is dropped immediately from a disk group when it becomes unavailable.
  • D、The RDBMS always reads the primary copy of a mirrored extent of the ASM disk group.

正确答案:A,B

第6题:

Which two statements are true about variable extent size support for large ASM files?()

A. The metadata used to track extents in SGA is reduced.

B. Rebalance operations are completed faster than with a fixed extent size

C. An ASM Instance automatically allocates an appropriate extent size.

D. Resync operations are completed faster when a disk comes online after being taken offline.

E. Performance improves in a stretch cluster configuration by reading from a local copy of an extent.


参考答案:A, C

第7题:

You are managing an Oracle Database 11g database with the ASM storage. The database is having 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.

正确答案:A,D

第8题:

Which two statements are true regarding an Automatic Storage Management (ASM) instance?() (Choosetwo.)

A. As ASM instance mounts an ASM control file

B. An ASM instance uses the ASMB process for rebalancing of disks within a disk group

C. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly

D. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started


参考答案:C, D

第9题:

What are the advantages of variable extent size support for large ASM files?()

  • A、It improves resync operations when the disk comes online after being taken offline for maintenance purposes. 
  • B、It improves performance in the extended cluster configuration by reading from a local copy of an extent. 
  • C、Fewer extent pointers are needed to describe the file and less memory is required to manage the extent maps in the shared pool.
  • D、This feature enables faster file opens because of the reduction in the amount of memory that is required to store file extents.

正确答案:C,D

第10题:

You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM). Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?()

  • A、The ASM compatibility attribute controls the format of the disk group metadata.
  • B、RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.
  • C、The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.
  • D、The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.
  • E、The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10g database.

正确答案:A,B,D

更多相关问题