网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
Identify three key features of ASM.()
- A、file striping
- B、allocation unit mirroring
- C、automatic disk rebalancing
- D、automatic file size increment
- E、automatic undo management
参考答案
更多 “Identify three key features of ASM.()A、file stripingB、allocation unit mirroringC、automatic disk rebalancingD、automatic file size incrementE、automatic undo management” 相关考题
考题
Examine the CREATE DISKGROUP command used to create a disk group:In which situation would you use this method of disk group creation?()
A. When two-way disk mirroring is required for the allocation unitsB. When three-way disk mirroring is required for the allocation unitsC. When using hardware mirroring or RAIDD. When disk mirroring is required for the Automatic Storage Management (ASM) disks
考题
Identify three key features of ASM.()
A. file stripingB. allocation unit mirroringC. automatic disk rebalancingD. automatic file size incrementE. automatic undo management
考题
Examine the CREATE DISKGROUP command used to create a disk group:SQL CREATE DISKGROUP misc EXTERNAL REDUNDANCYDISK ‘ORCL: FRA3‘ NAME misc1, ‘ORCL: FRA4‘ NAME misc2;In which situation would you use this method of disk group creation?()A. When two-way disk mirroring is required for the allocation unitsB. When three-way disk mirroring is required for the allocation unitsC. When using hardware mirroring or RAIDD. When disk mirroring is required for the Automatic Storage Management (ASM) disks
考题
Which are the two prerequisites before setting up Flashback Data Archive? ()(Choose two.)
A. Flash recovery area must be definedB. Undo retention guarantee must be enabled.C. Database must be running in archivelog mode.D. Automatic undo management must be enabled.E. The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).
考题
You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature?()A、 You must use automatic undo management in the database.B、 You must configure OMF in your database.C、 You must configure ASM for storing the datafiles.D、 You must multiplex the online redo log file.
考题
Identify three key features of ASM.()A、 file stripingB、 allocation unit mirroringC、 automatic disk rebalancingD、 automatic file size incrementE、 automatic undo management
考题
Which statement is true about the Manageability Monitor (MMON) background proces()A、It transfers statistics from memory to disk at regular intervals.B、It coordinates the rebalance activity for disk groups when ASM is used.C、It communicates with the Automatic Storage Management (ASM) instance on behalf of the databaseinstance.D、It performs dynamic memory management when Automatic Shared Memory Management is enabledfor the database instance.
考题
Which statement about Automatic Memory Management with Oracle 11g is true?() A、 You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_ TARGET values that are greater than zero in your parameter file.B、 Oracle can reallocate memory between the SGA and PGA automatically as needed.C、 To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.D、 You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.
考题
Which are the two prerequisites before setting up Flashback Data Archive? ()(Choose two.)A、Flash recovery area must be definedB、Undo retention guarantee must be enabled.C、Database must be running in archivelog mode.D、Automatic undo management must be enabled.E、The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).
考题
You have included the following parameter setting in your server parameter file: PGA_AGGREGATE_TARGET = 800M SORT_AREA_SIZE = 100M HASH_AREA_SIZE = 100M BITMAP_MERGE_AREA_SIZE = 100M CREATE_BITMAP_AREA_SIZE = 100M Which statement is true?() A、 All the *_AREA_SIZE parameters are ignored.B、 The Automatic PGA Memory Management feature cannot be disabled.C、 The total Program Global Area (PGA) memory cannot be manually increased above 800M.D、 The total memory for the PGA can automatically exceed 800M using the Automatic PGA Memory Management feature.
考题
Which two statements about Automatic Storage Management (ASM) are true?()A、ASM provides mirroring on file by file basis.B、ASM provides automatic load balancing across all ASM disks.C、ASM supports the Oracle database and operating system files.D、ASM can be used to store trace files, alert log files, and the server parameter file (SPFILE).
考题
Which two are the prerequisites to enable Flashback Data Archive?() (Choose two.)A、Database must be running in archivelog mode.B、Automatic undo management must be enabled.C、Undo retention guarantee must be enabled.D、The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).
考题
For Oracle 11g, Oracle strongly recommends that you configure your database to use which of the following memory-management features?() A、 Automatic PGA Memory ManagementB、 Automatic SGA Memory ManagementC、 Automatic Shared Memory ManagementD、 Automatic Memory ManagementE、 Manual SGA Memory ManagementF、 None of the above
考题
Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter?() A、 Automatic PGA Memory ManagementB、 Automatic SGA Memory ManagementC、 Automatic Shared Memory ManagementD、 Automatic Memory ManagementE、 Manual SGA Memory ManagementF、 None of the above
考题
View the Exhibit and examine the disk groups created at the time of migrating the database storage to Automatic Storage Management (ASM). Why does the FRA disk group initially have more free space even though both DATA and FRA disk groups are provided with the same size?()A、 Because the FRA disk group will not support dynamic rebalancingB、 Because the FRA disk group is not configured to support mirroringC、 Because disks in the FRA disk group are not formatted at this stageD、 Because the FRA disk group will support only a single size of allocation unit
考题
In Oracle 11g,by default which one of the following conditions implicitly enables Automatic PGA Memory Management?() A、 Setting a nonzero value for SGA_TARGETB、 Configuring Automatic Shared Memory ManagementC、 Configuring Automatic Memory ManagementD、 Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGETE、 None of the above
考题
Examine the CREATE DISKGROUP command used to create a disk group: SQL CREATE DISKGROUP misc EXTERNAL REDUNDANCY DISK ’ORCL: FRA3’ NAME misc1, ’ORCL: FRA4’ NAME misc2; In which situation would you use this method of disk group creation?()A、 When two-way disk mirroring is required for the allocation unitsB、 When three-way disk mirroring is required for the allocation unitsC、 When using hardware mirroring or RAIDD、 When disk mirroring is required for the Automatic Storage Management (ASM) disks
考题
Which two are the prerequisites to enable Flashback Data Archive?()A、 Database must be running in archivelog mode.B、 Automatic undo management must be enabled.C、 Undo retention guarantee must be enabled.D、 The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).
考题
You are managing an Oracle Database 11g database with ASM storage. The ASM disk group has the COMPATIBLE.ASM attribute set to 11.1. Which statements are true regarding extent management and allocation units in the ASM disk group?()A、 The au_size disk group attribute determines the size of allocation units in the disk group. B、 The allocation unit size may vary but the extent size is fixed.C、 The allocation unit size and extent size are fixed for all the disks in a disk group and cannot be changed.D、 Extent management is completely automated.
考题
单选题Examine the CREATE DISKGROUP command used to create a disk group: SQL CREATE DISKGROUP misc EXTERNAL REDUNDANCY DISK 'ORCL: FRA3' NAME misc1, 'ORCL: FRA4' NAME misc2; In which situation would you use this method of disk group creation?()A
When two-way disk mirroring is required for the allocation unitsB
When three-way disk mirroring is required for the allocation unitsC
When using hardware mirroring or RAIDD
When disk mirroring is required for the Automatic Storage Management (ASM) disks
考题
单选题In Oracle 11g,by default which one of the following conditions implicitly enables Automatic PGA Memory Management?()A
Setting a nonzero value for SGA_TARGETB
Configuring Automatic Shared Memory ManagementC
Configuring Automatic Memory ManagementD
Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGETE
None of the above
考题
单选题You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature?()A
You must use automatic undo management in the database.B
You must configure OMF in your database.C
You must configure ASM for storing the datafiles.D
You must multiplex the online redo log file.
考题
多选题Identify three key features of ASM.()Afile stripingBallocation unit mirroringCautomatic disk rebalancingDautomatic file size incrementEautomatic undo management
考题
单选题View the Exhibit and examine the disk groups created at the time of migrating the database storage to Automatic Storage Management (ASM). Why does the FRA disk group initially have more free space even though both DATA and FRA disk groups are provided with the same size?()A
Because the FRA disk group will not support dynamic rebalancingB
Because the FRA disk group is not configured to support mirroringC
Because disks in the FRA disk group are not formatted at this stageD
Because the FRA disk group will support only a single size of allocation unit
考题
单选题Which statement about Automatic Memory Management with Oracle 11g is true?()A
You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_ TARGET values that are greater than zero in your parameter file.B
Oracle can reallocate memory between the SGA and PGA automatically as needed.C
To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.D
You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.
考题
单选题Which statement is true about the Manageability Monitor (MMON) background proces()A
It transfers statistics from memory to disk at regular intervals.B
It coordinates the rebalance activity for disk groups when ASM is used.C
It communicates with the Automatic Storage Management (ASM) instance on behalf of the databaseinstance.D
It performs dynamic memory management when Automatic Shared Memory Management is enabledfor the database instance.
考题
单选题For Oracle 11g, Oracle strongly recommends that you configure your database to use which of the following memory-management features?()A
Automatic PGA Memory ManagementB
Automatic SGA Memory ManagementC
Automatic Shared Memory ManagementD
Automatic Memory ManagementE
Manual SGA Memory ManagementF
None of the above
考题
单选题What is true regarding a transaction executed in Automatic Undo Management mode?()A
AB
BC
CD
D
热门标签
最新试卷