Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-068

Oracle 1z0-068 Exam Practice Questions (P. 5)

  • Full Access (149 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #21
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. A
    It resizes VOL1.
  2. B
    It fails to resize the filesystem because it must be unmounted before resizing.
  3. C
    It fails to resize VOL1 because it must be executed as a user belonging to the SYSASM group.
  4. D
    It succeeds but leaves the filesystem unmounted.
  5. E
    It resizes the filesystem mounted on /u01/app/grid/acfsmount.

Correct Answer:
AD

Question #22
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. A
    HR is uniformly managed across all instances in prod_pool.
  2. B
    srvctl stop service only closes PDB_1 in the instance on HOST01.
  3. C
    srvctl stop service closes PDB_1 on all CDB1 instances.
  4. D
    srvctl stop service prevents logins for HR only to CDB1 on HOST01.
  5. E
    srvctl stop service prevents logins to any instance of CDB1 using service HR.
  6. F
    HR is available on a single instance of prod_pool.

Correct Answer:
AE

Question #23
Which three statements are true about the services created when the DBCA is used to create a RAC database?
  1. A
    They can be policy managed for a multitenant database.
  2. B
    Singleton services are not permitted for multitenant databases.
  3. C
    A server-pool must be created with SRVCTL before creating a policy-managed RAC database that uses that server-pool for a service.
  4. D
    Policy-managed services specified for a database allow the creation of a new server pool using DBCA.
  5. E
    They can be administrator managed for a multitenant database.

Correct Answer:
BCE
C: Cluster Managed Services are no longer managed through DBCA. Instead, use the Cluster Managed Services page in Oracle Enterprise Manager Cloud
Control, if available, or SRVCTL.
E: During installation, if you select a multitenant container database (CDB), and configure pluggable databases (PDBs), then Oracle recommends that you add services to the PDBs after installation.
Incorrect Answers:
D: Cluster Managed Services are no longer managed through DBCA. Instead, use the Cluster Managed Services page in Oracle Enterprise Manager Cloud
Control, if available, or SRVCTL.
References:
https://docs.oracle.com/database/121/RIWIN/dbcacrea.htm#RIWIN1320

Question #24
Which three statements are true about the Global Enqueue Service and Global Enqueue Service (GES) Resources in Oracle 12c RAC?
  1. A
    The mastering instance for a GES resource is never the same as the instance that owns the enqueue in exclusive mode.
  2. B
    The LMD0 runs only on the instance that masters all GES resources.
  3. C
    When a GES resource is dequeued, converters if any exist for that resource, are processed before any waiter for that resource.
  4. D
    The LMD0 process on the requesting instance communicates with the LMD0 process on the mastering instance if they are not the same instance.
  5. E
    The mastering instance for a GES resource is never the same as the instance that owns an enqueue in shared mode.
  6. F
    An LMD0 process runs on all instances.
  7. G
    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 #25
Which two statements are true concerning buffer states as shown in GV$BH.STATUS in Oracle 12c RAC?
  1. A
    An XCUR block image may exist for a specific database block in only one instance.
  2. B
    A CR image may get served from one instance to another to satisfy a read request.
  3. 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.
  4. D
    A PI block image may exist for a specific database block in only one instance.

Correct Answer:
AB
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

Previous Questions Next Questions

All Pages