Download Oracle.1z0-068.PracticeTest.2018-08-01.88q.vcex

Download Exam

File Info

Exam Oracle Database 12c: RAC and Grid Infrastructure Administration
Number 1z0-068
File Name Oracle.1z0-068.PracticeTest.2018-08-01.88q.vcex
Size 519 KB
Posted Aug 01, 2018
Download Oracle.1z0-068.PracticeTest.2018-08-01.88q.vcex

How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase

Coupon: MASTEREXAM
With discount: 20%





Demo Questions

Question 1

Which two statements are true concerning ASM diskgroups using disks with a 4k sector size?


  1. Their COMPATIBLE.ASM attributes must be set to 12.1 or higher.
  2. Their COMPATIBLE.ASM attributes must be set to 11.2 or higher.
  3. Performance of ACFS is improved by using these diskgroups.
  4. Their COMPATIBLE.RDBMS attributes must beset to 11.2 or higher.
  5. Their sector size attributes can be changed using the ALTER DISKGROUP command.
Correct answer: BD
Explanation:
The values for SECTOR_SIZE can be set to 512, 4096, or 4K if the disks support those values. The default value is platform dependent. The COMPATIBLE.ASM and COMPATIBLE.RDBMS disk group attributes must be set to 11.2 or higher to set the sector size to a value other than the default value. Incorrect Answers:C: Oracle ASM provides support for 4 KB sector disk drives without negatively affecting performance.Reference: https://docs.oracle.com/database/121/OSTMG/GUID-8B656725-D347-4166-8775-1070B6C4D580.htm#OSTMG10203
The values for SECTOR_SIZE can be set to 512, 4096, or 4K if the disks support those values. The default value is platform dependent. The COMPATIBLE.ASM and COMPATIBLE.RDBMS disk group attributes must be set to 11.2 or higher to set the sector size to a value other than the default value. 
Incorrect Answers:
C: Oracle ASM provides support for 4 KB sector disk drives without negatively affecting performance.
Reference: https://docs.oracle.com/database/121/OSTMG/GUID-8B656725-D347-4166-8775-1070B6C4D580.htm#OSTMG10203



Question 2

Examine the output of this command:
   ASMCMD> volinfo –G ACFS -a 
   Diskgroup Name: ACFS
   Volume Name: VOL1
   Volume Device: /dev/asm/vol1-280
   State: ENABLED
   Size (MB): 248
   Resize Unit (MB): 32
   Redundancy: MIRROR
   Stripe Columns: 4
   Stripe Width (K): 128
   Usage: ACFS
   Mountpath: /u01/app/grid/acfsmount
The ACFS disk group is a normal redundancy disk group with 5 GB of free space. 
To increase the size of the ACFS file system, you execute this command as the root user:
   $ /sbin/acfsutil size +200M /u01/app/grid/acfsmount 
Which two statements are true regarding the outcome of this command?


  1. It resizes VOL1.
  2. It fails to resize the filesystem because it must be unmounted before resizing.
  3. It fails to resize VOL1 because it must be executed as a user belonging to the SYSASM group.
  4. It succeeds but leaves the filesystem unmounted.
  5. It resizes the filesystem mounted on /u01/app/grid/acfsmount.
Correct answer: AD



Question 3

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?


  1. HR is uniformly managed across all instances in prod_pool.
  2. srvctl stop service only closes PDB_1 in the instance on HOST01.
  3. srvctl stop service closes PDB_1 on all CDB1 instances.
  4. srvctl stop service prevents logins for HR only to CDB1 on HOST01.
  5. srvctl stop service prevents logins to any instance of CDB1 using service HR.
  6. HR is available on a single instance of prod_pool.
Correct answer: AE



Question 4

Which three statements are true about the services created when the DBCA is used to create a RAC database?


  1. They can be policy managed for a multitenant database.
  2. Singleton services are not permitted for multitenant databases.
  3. A server-pool must be created with SRVCTL before creating a policy-managed RAC database that uses that server-pool for a service.
  4. Policy-managed services specified for a database allow the creation of a new server pool using DBCA.
  5. They can be administrator managed for a multitenant database.
Correct answer: ADE
Explanation:
Because policy-managed configuration was selected, the server pool to host the new CDB must be defined. Choose between using an existing server pool or creating a new one and specifying the detail of the new server pool to be used by the CDB. Policy-managed deployments facilitate consolidation. In the case of schema consolidation, where multiple applications are being hosted in a single database (CDB) separated into PDBs, since server pools determine which services run together or separately, you can configure and maintain required affinity or isolation of PDB services. Managing a policy-managed database requires less configuration and reconfiguration steps than an administrator-managed one with respect to creation, sizing, patching, and load balancing. Also, because any server in the server pools within the cluster can run any of the CDB instances and PDB services, you do not have to create and maintain CDB instance-to node-name mappings and PDB service-to-node-name mappings.
Because policy-managed configuration was selected, the server pool to host the new CDB must be defined. Choose between using an existing server pool or creating a new one and specifying the detail of the new server pool to be used by the CDB. 
Policy-managed deployments facilitate consolidation. In the case of schema consolidation, where multiple applications are being hosted in a single database (CDB) separated into PDBs, since server pools determine which services run together or separately, you can configure and maintain required affinity or isolation of PDB services. 
Managing a policy-managed database requires less configuration and reconfiguration steps than an administrator-managed one with respect to creation, sizing, patching, and load balancing. Also, because any server in the server pools within the cluster can run any of the CDB instances and PDB services, you do not have to create and maintain CDB instance-to node-name mappings and PDB service-to-node-name mappings.



Question 5

Which three statements are true about the Global Enqueue Service and Global Enqueue Service (GES) Resources in Oracle 12c RAC?


  1. The mastering instance for a GES resource is never the same as the instance that owns the enqueue in exclusive mode.
  2. The LMD0 runs only on the instance that masters all GES resources.
  3. When a GES resource is dequeued, converters if any exist for that resource, are processed before any waiter for that resource.
  4. The LMD0 process on the requesting instance communicates with the LMD0 process on the mastering instance if they are not the same instance.
  5. The mastering instance for a GES resource is never the same as the instance that owns an enqueue in shared mode.
  6. An LMD0 process runs on all instances.
  7. The foreground process on the requesting instance communicates with the LMD0 process on the mastering instance if they are not the same instance.
Correct answer: DEG



Question 6

Which two statements are true concerning buffer states as shown in GV$BH.STATUS in Oracle 12c RAC?


  1. An XCUR block image may exist for a specific database block in only one instance.
  2. A CR image may get served from one instance to another to satisfy a read request.
  3. An XCUR image is not downgraded to a SCUR image for shipping to another instance until commits occur for updated rows on the block.
  4. A PI block image may exist for a specific database block in only one instance.
Correct answer: AB
Explanation:
A: xcur is a RAM block that has been acquired in exclusive current mode. According the Oracle documentation, if a buffer state is exclusive current (XCUR), an instance owns the resource in exclusive mode.B: cr mode indicates a "cloned" RAM block (a "stale" block), that was once in xcur mode. The instance has shared access to the block and can only perform reads.  The cr state means the owning instance can perform a consistent read of the block, if the instance holds an older version of the data.References: http://www.dba-oracle.com/t_v$bh_status_free_buffer_blocks.htm
A: xcur is a RAM block that has been acquired in exclusive current mode. According the Oracle documentation, if a buffer state is exclusive current (XCUR), an instance owns the resource in exclusive mode.
B: cr mode indicates a "cloned" RAM block (a "stale" block), that was once in xcur mode. The instance has shared access to the block and can only perform reads.  The cr state means the owning instance can perform a consistent read of the block, if the instance holds an older version of the data.
References: http://www.dba-oracle.com/t_v$bh_status_free_buffer_blocks.htm



Question 7

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?


  1. AR runs as a singleton service in the server pool prod_pool and the AR service is available in each of the CDB1 instances.
  2. AR is available on any one available CDB1 instance in prod_pool at any one time.
  3. AR can fail over to any one of the available CDB1 instances.
  4. AR is available only on the CDB1 instance on HOST01.
  5. AR can fail over to any other available CDB1 instance in prod_pool.
Correct answer: BE



Question 8

Which two statements are true about the Global Enqueue Service, Instance Locks, and global enqueues in Oracle 12c RAC?


  1. In a RAC One Node database, there is no LMD0 process if only one instance is running.
  2. Global Enqueues and Instance Locks replace mutexes completely in RAC database instances.
  3. In a RAC database, there is no LMD0 process if only one instance is running.
  4. Global Enqueues and Instance Locks replace latches completely in RAC database instances.
  5. Global Enqueues may have owners and waiters in the same instance.
  6. Global Enqueues may have converters and waiters in the same instance.
Correct answer: AF
Explanation:
F: A convert queue is a queue of locks that are waiting to be converted to particular mode, this is the process of changing a lock from one mode to another, even a NULL is a lock. A resource has a lock value block (LVB). The Global Resource Manager (GRM) keeps the lock information valid and correct across the cluster. Oracle 10g release 2 and beyond replaced some latch mechanisms with the mutex approach, claiming that they are faster and more efficient than traditional locking mechanisms.  Incorrect Answers:B, D: Mutexes are objects that exist within the operating system to provide access to shared memory structures. They are similar to latches.References: http://www.datadisk.co.uk/html_docs/rac/grd.htm
F: A convert queue is a queue of locks that are waiting to be converted to particular mode, this is the process of changing a lock from one mode to another, even a NULL is a lock. A resource has a lock value block (LVB). The Global Resource Manager (GRM) keeps the lock information valid and correct across the cluster. Oracle 10g release 2 and beyond replaced some latch mechanisms with the mutex approach, claiming that they are faster and more efficient than traditional locking mechanisms.  
Incorrect Answers:
B, D: Mutexes are objects that exist within the operating system to provide access to shared memory structures. They are similar to latches.
References: http://www.datadisk.co.uk/html_docs/rac/grd.htm



Question 9

Which three statements are true regarding multitenant architecture for RAC databases?


  1. One UNDO tablespace for each PDB is required.
  2. One UNDO tablespace for each instance is required.
  3. PDBs can have local temporary tablespaces.
  4. All the containers share the same SYSTEM and SYSAUX tablespaces.
  5. You can open one, several, or all PDBs on one, several, or all CDB instances.
Correct answer: BCE
Explanation:
B: For an Oracle RAC CDB, one active undo tablespace exists for each instance.C: From a physical perspective, a CDB has basically the same structure as a non-CDB, except that each PDB has its own set of tablespaces (including its own SYSTEM and SYSAUX tablespaces) and data files.References: https://docs.oracle.com/database/121/CNCPT/cdblogic.htm#CNCPT89268
B: For an Oracle RAC CDB, one active undo tablespace exists for each instance.
C: From a physical perspective, a CDB has basically the same structure as a non-CDB, except that each PDB has its own set of tablespaces (including its own SYSTEM and SYSAUX tablespaces) and data files.
References: https://docs.oracle.com/database/121/CNCPT/cdblogic.htm#CNCPT89268



Question 10

Which two statements are true about database service administration in a RAC environment?


  1. When services are created with srvctl, tnsnames.ora is automatically updated.
  2. When services are created with srvctl, the service is not started automatically.
  3. Service attributes can be modified, unless an instance hosting the service is in restricted mode.
  4. When the DBMS_SERVICE package is used to modify a service, the CRS resource is automatically synchronized with the changes.
  5. When the DBMS_SERVICE package is used to delete a service, it is automatically removed from the OCR.
  6. When services are started with srvctl, they are automatically added to the data dictionary of the hosting database if not already defined.
Correct answer: BF
Explanation:
B: To start the service you need to use the START_SERVICE procedure.F: When the service is started by Oracle Clusterware or Oracle Restart, the service is modified in the database to match the resource defined to either Oracle Clusterware or Oracle Restart.Incorrect Answers:A: Srvctl manages CRS (OCR), but does not modify tnsnames.ora.C: Users can modify the edition attribute while the service is up and runningD: If you are using Clustered Managed Services with Oracle Clusterware, or using Oracle Restart with your single instance database, you must modify services using the srvctl command rather than DBMS_SERVICE.E: You cannot use the DBMS_SERVICE.DELETE_SERVICE subprogram if your services are managed by Oracle Clusterware, Oracle Restart, or Oracle Global Data Services.Note: Oracle Clusterware is the cross platform cluster software required to run the Real Application Clusters (RAC) option for Oracle Database.References:https://docs.oracle.com/database/121/ARPLS/d_serv.htm#ARPLS68022
B: To start the service you need to use the START_SERVICE procedure.
F: When the service is started by Oracle Clusterware or Oracle Restart, the service is modified in the database to match the resource defined to either Oracle Clusterware or Oracle Restart.
Incorrect Answers:
A: Srvctl manages CRS (OCR), but does not modify tnsnames.ora.
C: Users can modify the edition attribute while the service is up and running
D: If you are using Clustered Managed Services with Oracle Clusterware, or using Oracle Restart with your single instance database, you must modify services using the srvctl command rather than DBMS_SERVICE.
E: You cannot use the DBMS_SERVICE.DELETE_SERVICE subprogram if your services are managed by Oracle Clusterware, Oracle Restart, or Oracle Global Data Services.
Note: Oracle Clusterware is the cross platform cluster software required to run the Real Application Clusters (RAC) option for Oracle Database.
References:
https://docs.oracle.com/database/121/ARPLS/d_serv.htm#ARPLS68022









CONNECT US

Facebook

Twitter

PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount!

Get Now!


HOW TO OPEN VCEX FILES

Use ProfExam Simulator to open VCEX files