Download Oracle.PracticeTest.1z0-068.2018-08-01.1e.88q.vcex

Oracle.PracticeTest.1z0-068.2018-08-01.1e.88q.vcexOracle.PracticeTest.1z0-068.2018-08-01.1e.88q.vcexOracle.PracticeTest.1z0-068.2018-08-01.1e.88q.vcexOracle.PracticeTest.1z0-068.2018-08-01.1e.88q.vcexOracle.PracticeTest.1z0-068.2018-08-01.1e.88q.vcexOracle.PracticeTest.1z0-068.2018-08-01.1e.88q.vcex
Exam Oracle Database 12c: RAC and Grid Infrastructure Administration
Number 1z0-068
File Name Oracle.PracticeTest.1z0-068.2018-08-01.1e.88q.vcex
Size 519 Kb
Posted August 06, 2018

Download




How to open VCEX & EXAM Files?

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

Purchase
Coupon: EXAMFILESCOM

Coupon: EXAMFILESCOM
With discount: 20%






Demo Questions

Question 1

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


  • A: Their COMPATIBLE.ASM attributes must be set to 12.1 or higher.
  • B: Their COMPATIBLE.ASM attributes must be set to 11.2 or higher.
  • C: Performance of ACFS is improved by using these diskgroups.
  • D: Their COMPATIBLE.RDBMS attributes must beset to 11.2 or higher.
  • E: Their sector size attributes can be changed using the ALTER DISKGROUP command.
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?


  • A: It resizes VOL1.
  • B: It fails to resize the filesystem because it must be unmounted before resizing.
  • C: It fails to resize VOL1 because it must be executed as a user belonging to the SYSASM group.
  • D: It succeeds but leaves the filesystem unmounted.
  • E: It resizes the filesystem mounted on /u01/app/grid/acfsmount.
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?


  • A: HR is uniformly managed across all instances in prod_pool.
  • B: srvctl stop service only closes PDB_1 in the instance on HOST01.
  • C: srvctl stop service closes PDB_1 on all CDB1 instances.
  • D: srvctl stop service prevents logins for HR only to CDB1 on HOST01.
  • E: srvctl stop service prevents logins to any instance of CDB1 using service HR.
  • F: HR is available on a single instance of prod_pool.
Question 4

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


  • A: They can be policy managed for a multitenant database.
  • B: Singleton services are not permitted for multitenant databases.
  • C: A server-pool must be created with SRVCTL before creating a policy-managed RAC database that uses that server-pool for a service.
  • D: Policy-managed services specified for a database allow the creation of a new server pool using DBCA.
  • E: They can be administrator managed for a multitenant database.
Question 5

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


  • A: The mastering instance for a GES resource is never the same as the instance that owns the enqueue in exclusive mode.
  • B: The LMD0 runs only on the instance that masters all GES resources.
  • C: When a GES resource is dequeued, converters if any exist for that resource, are processed before any waiter for that resource.
  • D: The LMD0 process on the requesting instance communicates with the LMD0 process on the mastering instance if they are not the same instance.
  • E: The mastering instance for a GES resource is never the same as the instance that owns an enqueue in shared mode.
  • F: An LMD0 process runs on all instances.
  • G: The foreground process on the requesting instance communicates with the LMD0 process on the mastering instance if they are not the same instance.
Question 6

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


  • A: An XCUR block image may exist for a specific database block in only one instance.
  • B: A CR image may get served from one instance to another to satisfy a read request.
  • C: An XCUR image is not downgraded to a SCUR image for shipping to another instance until commits occur for updated rows on the block.
  • D: A PI block image may exist for a specific database block in only one instance.
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?


  • A: AR runs as a singleton service in the server pool prod_pool and the AR service is available in each of the CDB1 instances.
  • B: AR is available on any one available CDB1 instance in prod_pool at any one time.
  • C: AR can fail over to any one of the available CDB1 instances.
  • D: AR is available only on the CDB1 instance on HOST01.
  • E: AR can fail over to any other available CDB1 instance in prod_pool.
Question 8

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


  • A: In a RAC One Node database, there is no LMD0 process if only one instance is running.
  • B: Global Enqueues and Instance Locks replace mutexes completely in RAC database instances.
  • C: In a RAC database, there is no LMD0 process if only one instance is running.
  • D: Global Enqueues and Instance Locks replace latches completely in RAC database instances.
  • E: Global Enqueues may have owners and waiters in the same instance.
  • F: Global Enqueues may have converters and waiters in the same instance.
Question 9

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


  • A: One UNDO tablespace for each PDB is required.
  • B: One UNDO tablespace for each instance is required.
  • C: PDBs can have local temporary tablespaces.
  • D: All the containers share the same SYSTEM and SYSAUX tablespaces.
  • E: You can open one, several, or all PDBs on one, several, or all CDB instances.
Question 10

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 service, the CRS resource is automatically synchronized with the changes.
  • E: When the DBMS_SERVICE package is used to delete a service, it is automatically removed from the OCR.
  • F: When services are started with srvctl, they are automatically added to the data dictionary of the hosting database if not already defined.



Comments