考题
Which background process of a database instance, using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?()
A. ASMBB. PMONC. RBALD.SMON
考题
Which two statements are true regarding an Automatic Storage Management (ASM) instance? ()
A. As ASM instance mounts an ASM control fileB. An ASM instance uses the ASMB process for rebalancing of disks within a disk groupC. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitlyD. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started
考题
Which two statements are true regarding an Automatic Storage Management (ASM) instance?() (Choosetwo.)
A. As ASM instance mounts an ASM control fileB. An ASM instance uses the ASMB process for rebalancing of disks within a disk groupC. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitlyD. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started
考题
You plan to use the In Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.Which three storage options support the use of HCC?()A. ASM disk groups with ASM disks consisting of Exadata Grid Disks.B. ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network arrayC. ASM disk groups with ASM disks consisting of any zero padded NFS-mounted filesD. Database files stored in ZFS and accessed using conventional NFS mounts.E. Database files stored in ZFS and accessed using the Oracle Direct NFS featureF. Database files stored in any file system and accessed using the Oracle Direct NFS featureG. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays
考题
Which background process of a database instance, using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?()A、ASMBB、PMONC、RBALD、SMON
考题
n your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance?()A、 Oracle Migration AssistantB、 Recovery Manager (RMAN)C、 Oracle Data Pump Export and ImportD、 conventional Oracle Export and ImportE、 operating system utilities to copy the files to the ASM instance
考题
You are maintaining the SALES database.You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity.Which parameter should you specify to control the speed of the rebalancing activity?()A、ASM_POWER_LIMITB、ASM_DISKSTRINGC、ASM_DISKGROUPSD、INSTANCE_TYPE
考题
Which two statements are true regarding an Automatic Storage Management (ASM) instance? ()A、As ASM instance mounts an ASM control fileB、An ASM instance uses the ASMB process for rebalancing of disks within a disk groupC、Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitlyD、An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started
考题
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.
考题
In your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance?()A、Oracle Migration AssistantB、Recovery Manager (RMAN)C、Oracle Data Pump Export and ImportD、conventional Oracle Export and ImportE、operating system utilities to copy the files to the ASM instance
考题
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).
考题
You plan to use the In Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format. Which three storage options support the use of HCC?()A、ASM disk groups with ASM disks consisting of Exadata Grid Disks.B、ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network arrayC、ASM disk groups with ASM disks consisting of any zero padded NFS-mounted filesD、Database files stored in ZFS and accessed using conventional NFS mounts.E、Database files stored in ZFS and accessed using the Oracle Direct NFS featureF、Database files stored in any file system and accessed using the Oracle Direct NFS featureG、ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays
考题
Which statement must you issue to an already-running Automatic Storage Management (ASM) instance to prevent database instances from connecting to the ASM instance?() A、 ALTER SYSTEM KILL SESSIONB、 ALTER SYSTEM DISCONNECT SESSIONC、 ALTER SYSTEM QUIESCE RESTRICTEDD、 ALTER SYSTEM ENABLE RESTRICTED SESSION
考题
You execute the following command to start an Automatic Storage Management (ASM) instance: SQLSTARTUP; In which of the following modes will the ASM instance start?()A、 OPENB、 MOUNTC、 NORMALD、 NOMOUNT
考题
You have a single Automatic Storage Management (ASM) instance running on the node on which your Oracle Database 10g resides. Which ASM instance initialization parameters must be included in the ASM instance initialization parameter file?()A、 INSTANCE_TYPEB、 DB_UNIQUE_NAMEC、 ASM_DISKSTRINGD、 ASM_POWER_LIMIT
考题
Which background process of a database instance, using Automatic Storage Management (ASM), connects asa foreground process into the ASM instance?()A、ASMBB、PMONC、RBALD、SMON
考题
Which statement is true about the Manageability Monitor (MMON) background process()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 database Instance.D、It performs dynamic memory management when Automatic Shared Memory Management is enabled for the Database instance
考题
单选题n your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance?()A
Oracle Migration AssistantB
Recovery Manager (RMAN)C
Oracle Data Pump Export and ImportD
conventional Oracle Export and ImportE
operating system utilities to copy the files to the ASM instance
考题
多选题Which two statements about Automatic Storage Management (ASM) are true?()AASM provides mirroring on file by file basis.BASM provides automatic load balancing across all ASM disks.CASM supports the Oracle database and operating system files.DASM can be used to store trace files, alert log files, and the server parameter file (SPFILE).
考题
单选题You work as a database administrator at Certkiller .com. Your production database uses an Automatic Storage Management (ASM) instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users?()A
mount the new disk group in the ASM instanceB
restart the ASM instance and the production database instanceC
register the new disk groups in the production database instanceD
restart the ASM instance without restarting the production database instanceE
include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance
考题
单选题Your production database uses an Automatic Storage Management (ASM) instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users?()A
mount the new disk group in the ASM instanceB
restart the ASM instance and the production database instanceC
register the new disk groups in the production database instanceD
restart the ASM instance without restarting the production database instanceE
include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance
考题
单选题Which background process of a database instance,using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?()A
ASMBB
PMONC
RBALD
SMON
考题
单选题In your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files. Which option would you use to migrate the database files from a non/x7fASM instance to an ASM instance?()A
Oracle Migration AssistantB
Recovery Manager (RMAN)C
Oracle Data Pump Export and ImportD
conventional Oracle Export and ImportE
operating system utilities to copy the files to the ASM instance
考题
单选题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 two statements are true regarding an Automatic Storage Management (ASM) instance?()AAs ASM instance mounts an ASM control fileBAn ASM instance uses the ASMB process for rebalancing of disks within a disk groupCAutomatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitlyDAn RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started
考题
单选题You have a single Automatic Storage Management (ASM) instance running on the node on which your Oracle Database 10g resides. Which ASM instance initialization parameters must be included in the ASM instance initialization parameter file?()A
INSTANCE_TYPEB
DB_UNIQUE_NAMEC
ASM_DISKSTRINGD
ASM_POWER_LIMIT
考题
单选题Which statement is true about the Manageability Monitor (MMON) background process()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 database Instance.D
It performs dynamic memory management when Automatic Shared Memory Management is enabled for the Database instance
考题
单选题Which statement must you issue to an already-running Automatic Storage Management (ASM) instance to prevent database instances from connecting to the ASM instance?()A
ALTER SYSTEM KILL SESSIONB
ALTER SYSTEM DISCONNECT SESSIONC
ALTER SYSTEM QUIESCE RESTRICTEDD
ALTER SYSTEM ENABLE RESTRICTED SESSION