Activedumpsnet Logo
Which three options have a RAC-specific tuning component?
Examine this command to create a volume in the DATA disk group:
SQL>ALTER DISKGROUP DATA ADD VOLUME vo11 SIZE 10g HIGH
STRIPE_WIDTH 1M;
STRIPE_COLUMNS 1;
The DATA disk group has 50GB free space.
Which two are prerequisites for successful execution of this command?
Which two actions guarantee that time is synchronized properly on all nodes in a cluster after installing Oracle Grid Infrastructure 12c? (Choose two.)
Examine this command:
SQL> CREATE DISKROUP data NORMAL REDANDUNCY:
FAILGROUP fgrp1 DISK
‘/dev/disk1’ NAME disk1,
‘/dev/disk2’ NAME disk2,
‘/dev/disk3’ NAME disk3,
FAILGROUP fgrp2 DISK
‘/dev/disk4’ NAME disk4,
‘/dev/disk5’ NAME disk5,
‘/dev/disk6’ NAME disk6,
FAILGROUP fgrp3 DISK
‘/dev/disk7’ NAME disk7,
‘/dev/disk8’ NAME disk8,
‘/dev/disk9’ NAME disk9,
ATTRIBUTE ‘au_size’=’4M’,
‘compatible.asm’ = ’11.2’,
‘compatible.rdbms’ = ’11.2’,
‘compatible.advm’ = ’11.2’,
‘content_type’ = ‘recovery’;
Which two statements a true about this disk group, created using Grid Infrastructure 12.1?
Which two statements are true about Oracle Clustered ASM performance? (Choose two.)
Which three statements are true about Oracle 12 RAC Database software installations?
Which two types of network adapters are required in which quantity in order to comply with Oracle recommendations for hardware in a cluster? (Choose two.)
Which two statements are true about ASM default templates?
Examine these commands:
$ srvctl add service –db racdb –service erp –serverpool srvpooll
- failovertype TRANSACTION –commit_outcome TRUE – replay_init_time 1800
- retention 86400 –notification TRUE –rlbgoal SERVICE_TIME –clbgoal SHORT
- failoverretry 30 – failoverdelay 10
$ srvctl start service – db racdb – service erp
Instances RACDB_1 and RACDB_2 run on host01 and host02, respectively.
Which three statements are true regarding the service erp?
Examine this command:
$ srvctl modify service -db RACDB -service SRVBl -clbgoal LONG
This three-Instance RAC database uses Flex ASM.
Which two statements are true regarding server-side connect-time load balancing using SCAN listeners for this service? (Choose two.)
Which three statements are true about Oracle 12c multitenant RAC databases created using the Database Configuration Assistant (DBCA) on a cluster from a RAC database home? (Choose three.)
Examine these commands:
srvctl add service -db RACDB -service CRM -preferred RACDB_1 -available RACDB_2 -
tafpolicy preconnect
srvcl start service -db RACDB -service CRM
Instances RACDB_1 and RACDB_2 run on host0l and host02, respectively.
This is the only TNS entry in the client side tnsnames.ora:
CRM =
(DESCRIPTION =(FAILOVER=ON) (LOAD_BALANCE=ON)
(ADDRESS= (PROTOCOL=TCP) (HOST=host0l-VIP.example.com)(PORT=1521))
(ADDRESS= (PROTOCOL=TCP) (HOST=host02-VIP.example.com)(PORT=1521))
(CONNECT_DATA = (SERVICE_NAME = CRM)
(FAILOVER_MODE = (BACKUP=CRM_PRECONNECT)
(TYPE=SESSION)(METHOD=PRECONNECT))))
Which statement is true regarding the TAF settings?
Examine this command:
SQL> CREATE PLUGGABLE DATABASE pdb3 FROM pdb1;
Which three conditions must be true for successful execution of this command on a RAC database? (Choose three.)
You support a three-instance, policy-managed, multitenant RAC database CDB1 with two PDBs PDB_1 and PDB_2.
It runs on an eight-node cluster and a serverpool prod_pool has three servers.
Examine these commands executed on HOST01:
$ srvctl add service –db CDB1 –pdb PDB_1 –service HR –serverpool prod_pool
$ srvctl start service –db CDB1 –service HR
$ srvctl stop service –db CDB1 –service HR
Which two statements are true?
Which two commands will stop the Oracle High Availability Services (OHAS) and prevent it from starting automatically at system boot on the local node? (Choose two.)
You administer a six-instance, policy-managed, multitenant RAC database CDB1 with three PDBs: PDB_1, PDB_2 and PDB_3.
Server pool prod_pool has a cardinality of three and all six hosts of the cluster app.
Examine these commands executed on HOST01:
$ srvctl add service –db CDB1 –pdb PDB_1 service AR –serverpool prod_pool –cardinality singleton
$ srvctl start service –db CDB1 –service AR
Which two statements are true regarding the AR service?
Which method can be used to convert a single-instance Oracle 12c Database to a RAC Database?
Which two statements are true concerning Oracle Enterprise Manager Cloud Control Cluster Database performance pages? (Choose two.)
Which three events occur when a hub node fails in an Oracle Clusterware 12c Flex Cluster?
You are installing Oracle Grid Infrastructure 12c and configuring a Flex Cluster?
Which two elements are required to support this configuration? (Choose two.)
Which three components are integral parts of High Availability NFS (HANFS)?
Identify two reasons for the gc current block busy wait event. (Choose two.)