This certification validates practical skills in enterprise business systems, with emphasis on configuring processes, managing information, and supporting business outcomes. It is intended for professionals who implement or operate enterprise business systems.
Which two statements are true regarding an Automatic Storage Management (ASM) instance? (Choose two.)
Users are connected to a database instance that is using Automatic Storage Management (ASM). The DBA executes the command as follows to shut down the
ASM instance:
SQL> SHUTDOWN IMMEDIATE;
What happens to the database instance?
Examine the following ALTER command;
SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;
What is the purpose of the command?
A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows:
SQL> CREATE DISKGROUP dgroup1 NORMAL REDUNDANCY
FAILGROUP controller1 DISK '/devices/diska1', '/devices/diska2'
FAILGROUP controller2 DISK '/devices/diskb1', '/devices/diskb2';
What happens when the whole CONTROLLER1 Failure group is damaged?
Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.
Which tool or utility would you use to start the listener?