Q1. Which method can be used to convert a single-instance Oracle 12c Database to a RAC Database? A. using DBCA to migrate the database to shared storage and then start one or more RAC databaseinstances on the cluster B. using DBCA to create a template from the single-instance database and then to create a RAC database onthe cluster using that template C. using…
Q1. The DGRP1 diskgroup has these attributes: 1.Normal redundancy 2.Two failgroups with four asmdisks in each failgroup 3.compatible.asm set to 12.1 The ASM_POWER_LIMIT is currently set to 1 in the ASM instances. There are three databases whose instances are up and which access data in the DGRP1 diskgroup. No other clients use this diskgroup. You want to add two asmdisks to each failgroup, complete the rebalance as…
Q1. You are developing a user callout procedure to send an email to the helpdesk whenever a RAC database instance fails to restart after node failure. Examine these tasks: 1.Create a shell-script with the name callout.sh to send an email for the instance event. 2.Create a shell script with any name to send an email for the instance event. 3.Store the script in the /racg/usrco…
Q1. Which two statements are true about database service administration in a RAC environment? A. When services are created with srvctl, tnsnames.ora is automatically updated. B. When services are created with srvctl, the service is not started automatically. C. Service attributes can be modified, unless an instance hosting the service is in restricted mode. D. When the DBMS_SERVICE package is used to modify a…
Q1. Examine this command: SQL> CREATE DISKROUP data NORMAL REDANDUNCY: FAILGROUP fgrpl DISK ‘/dev/disk1’ NAME disk1, ‘/dev/disk2’ NAME disk2, ‘/dev/disk3’ NAME disk3, FAILGROUP fgrpl2 DISK ‘/dev/disk4’ NAME disk4, ‘/dev/disk5’ NAME disk5, ‘/dev/disk6’ NAME disk6, FAILGROUP fgrpl3 DISK ‘/dev/disk7’ NAME disk7, ‘/dev/disk8’ NAME disk8, ‘/dev/disk9’ NAME disk9, ATTRIBUTE ‘au_size’=’4M’, ‘compatible.asm’ = ’11.12’, ‘compatible.rdbms’ = ’11.12’, ‘compatible.advm’ = ’11.12’, ‘content_type’ = ‘recovery’; Which two statements a true about this disk group, created using Grid Infrastructure 12.1? A. Each disk in each of…
Q1. PROD1, PROD2 and PROD3 are three instances that have multitenant container database PROD open. PROD contains multiple PDBs. Examine these successful commands: $ srvctl add service –db PROD –pdb PRDPDB1 –service SRVPDB1 $ srvctl start service –db PROD –service SRVPDB1 Which statement is true about the srvctl start service command? A. It opens the PRDPDB1 PDB if not already opened. B. It can open…