Which is the correct syntax to create an asmlib disk?
DISK1 = asmlib disk name /dev/sdb1 = first device partition/dev/sdb = device name
A. /usr/sbin/oracleasm add disk DISK1 /dev/sdfa
B. /usr/sbin/oracleasm createdisk DISK1 /dev/sdb1
C. /usr/sbin/oracleasm createdisk DISK1 /dev/sdb
D. /usr/sbin/oracleasm map DISK1 /dev/sdb
To create a policy-managed database in RAC, which three properties have to be defined?
A. Minimum downtime before switchover occurs
B. Minimum number of nodes
C. Maximum number of nodes
D. Relative importance compared to other server pools
E. Relative uptime compared to other server pools
A node is evicted from a three-node cluster due to poor latency of the underlying storage Which two statements are correct in describing the instance recovery process?
A. Perform a restore of archive redo from flash recovery area to recover database
B. Upon startup, the SMON/LMS processes perform instance crash recovery.
C. Upon startup of failed instance, the SMON process performs instance crash recovery by using checkpoints to determine which data needs to be append to data files.
D. User intervention is not required.
E. Upon startup, PMON (process monitor) performs instance crash recovery automatically User intervention is not required
Identify the correct command to create the salesrep seivice for the PDB salespdb in the RAC 12cR1 CDB with DB_UNIQUE_NAME mycdb.
A. Srvct1 add service -db mycdb -service salesrep -pdb create salespdb
B. Srvct1 add service -db mycdb -service salesrep -pdb service salespdb
C. Srvct1 add service -db mycdb -service salesrep -pdb salespdb
D. Srvct1 add service -db mycdb -service salesrep -pdb service salespdb
Identify the root cause of Enqueue: CF - Contention in this scenario.
A. Root cause is a stalled LGWR due to LGWR waits Enqueue: CF contention is caused by the db file sequential reads
B. Root cause is blocked LGWR due to LGWR waits LGWR waits ENQUEUE: CF contention is a symptom of the db file scattered reads and excessive ITL waits
C. Root cause is a blocked LGWR due to LGWR waits for enqueue: CF - contention, which may be held by another background process. Background process may hold a CF enqueue while updating the control file
D. Root cause is blocked LGWR due to SCAN_LISTENERS(s) dropping client connections during DoS event
The exhibit describes an Oracle Clusterware startup.
Which item is missing?
A. ohasd
B. ocssd
C. crsd
D. octssd
E. osysmond
F. oraagent
You are given the task of managing an Oracle RAC 12cR1 Cluster by using Oracle Flex ASM. Which two statements are valid?
A. A failure of an ASM instance affects the databases, even if you are using ASM disk groups
B. A failure of an ASM instance affects availability for the databases using ASM disk groups due to decreased cardinality of available ASM instances
C. To determine whether Oracle Flex ASM is enabled, use asmcmd show cluster mode
D. When deployed, Oracle Flex ASM enables an Oracle ASM instance to run on a separate physical server from the database server
Which three options can be used for storing database files in an Oracle Real Application Clusters database?
A. Shared disk partitions as raw devices
B. Shared disks managed by Oracle Automatic Storage Manager (ASM)
C. Local file system
D. Shared disk partitions as block devices
E. Network file system (NFS) on a certified network-attached storage (NAS) filer
F. Oracle Automatic Storage Management Cluster File System (ACFS)
Under which condition can Oracle Automated Storage Management (ASM) be considered to be a component of the Oracle Clusterware technology stack?
A. Oracle Cluster Registry (OCR) is stored on Oracle ASM
B. Oracle Local Registry (OLR) is stored on a clustered file system (OCFS/ACFS/DBFS)
C. Both Oracle Cluster Registry and Oracle Local Registry are stored on Oracle ASM
D. Oracle ASM can never be considered a component of Oracle Clusterware
E. Oracle ASM can be considered a component of Oracle Clusterware technology stack only when deployed on engineered systems such as Exadata or Oracle Database Appliance
What is the correct syntax to put a DATA1 disk offline for a failure group FG1, and drop it after five minutes?
A. ALTER DISKGROUP data OFFLINE DISK DATA1 IN FAILGROUP FG2 DROP AFTER 5m;
B. It is not possible to drop it after five minutes.
C. It is not possible to specify a disk In a FAILGROUP.
D. ALTER DISKGROUP data OFFLINE DISKS IN FAILGROUP FG2 DROP AFTER 5m;
E. ALTER DISKGROUP data OFFLINE DISK DATA1 IN FAILGROUP FG2 DROP AFTER 5 minutes;
