Answer AE QUESTION 133 Examine this command SQL CREATE PLUGGABLE DATABASE pdb3

Answer ae question 133 examine this command sql

This preview shows page 61 - 64 out of 70 pages.

Answer: AE QUESTION 133 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.) A. It can be executed only by a common user with the CREATE PLUGGABLE DATABASE system privilege connected to the root container. B. The source PDB must use a global temporary tablespace. C. The source PDB must be in READ ONLY mode on all CDB instances. D. Oracle Managed Files must be enabled or PDB_FILE_NAME_CONVERT must be set. E. All running CDB instances must be open in restricted mode.
Image of page 61
Get Latest & Actual 1Z0-068 Exam's Question and Answers from Braindump2go. 61 F. The source PDB must be closed on the CDB instance from where the command is executed. Answer: ACD QUESTION 134 Which two statements are true about resource profiles for administrator-managed RAC database services? (Choose two.) A. It is automatically created when a service is created using SRVCTL ADD SERVICE. B. It contains a list of server pools on which the instances hosting the service can run. C. It contains a node list and instance-to-node mapping information for the service. D. It specifies the instance to which the service should fail over, if the preferred instance shuts down or fails. E. It is automatically created when a service is created using DBMS_SERVICE.CREATE_SERVICE. Answer: AC QUESTION 135 Examine this command and output: Examine this list of commands: 1. srvct1 convert db -db ron -dbtype rac -node o16n1 2. srvct1 convert db -db ron -dbtype raconenode -node 016n1 3. srvct1 add instance -db ron -instance ron_1 -node 016n1
Image of page 62
Get Latest & Actual 1Z0-068 Exam's Question and Answers from Braindump2go. 62 4. srvct1 add instance -db ron -in5tance ron_2 -node 016n2 5. srvct1 start instance -db ron -instance ron_1 6. srvct1 start instance -db ron -instance ron_2 Currently, there is an instance of database ron running on o16n1. You want to convert ron to a RAC database and make all instances available. Identify the commands required, in the correct order, to accomplish this. A. 1, 3, 4, 5 and 6 B. 2, 3, 4, 5 and 6 C. 1, 4, 5 and 6 D. 2, 4, 5 and 6 E. 1, 4 and 6 F. 2, 4 and 6 Answer: A QUESTION 136 Which three statements are true concerning backups of the OCR and OLR in Oracle Clusterware 12c? (Choose three.) A. The OCR can be backed up using ocrconfig. B. The OCR is backed up automatically every four hours. C. The OCR is backed up by default to a cluster file system location. D. The OLR can be backed up using ocrconfig. E. The OLR is backed up automatically every four hours. F. The OLR is backed up by default to a cluster file system location. Answer: ADF QUESTION 137 Identify two reasons for the gc current block busy wait event. (Choose two.) A. A block is busy in the local cache. B. A block is busy in the remote cache. C. The Cluster Interconnect is congested.
Image of page 63
Image of page 64

You've reached the end of your free preview.

Want to read all 70 pages?

  • Fall '15

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture