Oracle 1z0-068 Free Practice Exam & Test Training

Question 1

After creating a RAC One Node database using SQL statements, you want to register this database with Oracle Clusterware as a policy-managed resource.
Which command, or sequence of commands, should you use?

A. srvctl add srvpool serverpool ron importance 100 min 2 max 2 servers 016n1, 016n2 srvct1 add db db ron oraclehome $ORACLE_HOME dbtype raconenode serverpool ron
B. srvct1 add db db ron oraclehome $ORACLE_HOME dbtype raconenode server 016n1, 016n2
C. srvct1 add db –db ron –oraclehome $ORACLE_HOME –dbtype raconenode –serverpool ron –server016n1, 016n2
D. srvctl add srvpool serverpool ron importance 100 min 2 max 2 servers 016n1, 016n2 srvct1 add db db ron oraclehome $ORACLE_HOME dbtype raconenode server 016n1, 016n2

Answer : C

Question 2

Which three statements are true concerning activation of a user-defined policy in Oracle
12c Clusterware?

A. When a policy is first created, it is initially active.
B. When a policy is activated, nodes may be reassigned to server pools based on the policy definition.
C. An administrator-defined policy may be activated using the srvctl utility.
D. When a policy is activated, resources cannot be automatically started to comply with the policy definition.
E. When a policy is first created, it is initially inactive.
F. When a policy is activated, resources can be automatically stopped to comply with the policy definition.

Answer : A,C,E

Question 3

Which three statements are true concerning the Automatic Workload Repository (AWR) in a RAC environment?

A. Taking an AWR snapshot in a RAC database captures data from all instances that have the databaseopened.
B. Taking an AWR snapshot in a RAC database captures data from the local instance only.
C. Data captured by an AWR is aggregated across all instances before being stored in the database.
D. The awr_snapshot_time_offset parameter specifies the number of seconds each instance waits after thetop of the hour before taking its AWR snapshot.
E. AWR snapshots are created when control_management_pack_access is set to “none”

Answer : C,D,E

Question 4

Examine the output of the asmcmd and srvctl commands:
$ asmcmd showclustermode
ASM cluster : Flex mode enabled $ srvctl status asm detail ASM is running on host01, host03 ASM is enabled.
$ srvctl config asm

ASM home: /u01/app/12.1.0/grid -

Password file: +DATA/orapwASM -

ASM listener: LISTENER -

ASM instance count: 2 -
Cluster ASM listener: ASMNET1LSNR_ASM Then you execute this command:
$ srvctl relocate asm currentnode host03 targetnode host02
Which three statements are true regarding the execution of this command based on the output shown?

A. It fails because an ASM instance is not configured to run on HOST02.
B. It succeeds and starts an ASM instance on HOST02 and shuts down the ASM instance on HOST03.
C. It succeeds and 12c database instances connected to the ASM instance on HOST03 can be reconnectedto the ASM instance on HOST02.
D. It fails because the ASM instance has not been shut down first on HOST03.
E. It succeeds and starts an ASM instance on HOST02 but the ASM instance on HOST03 is not shut downuntil all connected clients disconnected.
F. It succeeds and 12c database instances connected to the ASM instance on HOST03 can be reconnectedto the ASM instance on HOST01.

Answer : C,E,F

Question 5

Which two methods exist for enabling the collection of additional resource debugging information for specific resources controlled by Oracle 12c Clusterware?

A. Use the cluvfy comp command for the specific resource within a component.
B. Use the crsctl set trace res “resource_name=debugging_level” command.
C. Use the crsctl set log res “resource_name=debugging_leve2” command.
D. Set the environment variable _USA_ORA_DEBUG=1 and then stop and restart the resource that requiresresource debugging data to be collected.

Answer : B,D

Question 6

Which three statements are true about Oracle Enterprise Manager Topology Viewer?

A. It displays which listeners listen on behalf of which instances.
B. It displays the relationship between targets of different target types in a cluster.
C. It displays the status of all cluster components.
D. It displays the status of Pluggable Databases (PDBs) in a multitenant container database (CDB).
E. It displays the relationship between clustered ASM and cluster databases if the database is stored in ASM.
F. It displays the type of network used by RAC database instance.

Answer : A,C,D

Question 7

Which two types of network adapters are required in which quantity in order to comply with
Oracle recommendations for hardware in a cluster?

A. at least one for the public network
B. at least one for the storage network
C. at least one for the interconnect
D. at least two for the public network
E. at least two for the storage network
F. at least two for the interconnect

Answer : D,E

Question 8

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 the three fail groups is a mirror of the corresponding disk of the other two failuregroups.
B. File created in this disk group always has two copies for each allocation unit: one primary and onesecondary.
C. It can contain ASM Dynamic Volume Manager (ADVM) volumes.
D. Any database instance with the COMPATIBLE parameter set to 11.2 or higher can access it.
E. The ASM compatible attributes can be changed to 11.1 for this disk group.

Answer : B,E

Question 9

Which two statements are true about Flex ASM in a Flex Cluster?

A. Oracle databases from releases older than 12c cannot use Flex ASM.
B. ASFS may only be configured on a hub node running an ASM instance.
C. Instances of ASM-based databases on hosts that have no ASM instance running, require Flex ASM.
D. Flex ASM requires that I/Os requests be sent through an ASM Proxy Instance, regardless of database andASM instance placement in a cluster.
E. Hub nodes with connections from multiple leaf nodes must run an ASM instance.

Answer : A,E

Question 10

When installing Oracle Grid Infrastructure 12c, which three options exist for the configuration of Grid naming Service (GNS)?

A. using Shared GNS for the leaf nodes and local GNS for the hub nodes in a Flex Cluster
B. using Shared GNS running on another cluster
C. using Shared GNS for the hub nodes and local GNS for the leaf nodes in a Flex Cluster
D. creation of a new GNS for this cluster
E. using DHCP to assign Node Virtual IP addresses for nodes in the cluster

Answer : A,B,E

Question 11

Which three statements are true about the administration and use of policy sets in Oracle
12c Clusterware?

A. All server pools in a cluster are controlled by the policy set, when user-defined policy management is used.
B. Servers in a server pool outside the control of policy set are never affected by policy changes, when user-defined policy management is used.
C. Clusterware administrators cannot directly modify the policy set when Quality of Service (QoS)Management is used.
D. A server pool can have the same attributes defined for different policies in the policy set, when user-definedpolicy management is used.
E. A server pool can have different attributes defined for different policies in the policy set, when user-definedpolicy management is used.

Answer : A,C,E

Question 12

Which three statements are true concerning diagnostic components and requirements of
Oracle 12c Clusterware?

A. There is one ologgered service for the cluster health monitor (CHM) on each cluster node regardless ofcluster size.
B. The Grid Infrastructure Management Repository database must run on a hub node if Flex Clusters areused.
C. There is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless ofcluster size.
D. The oclumon utility may be used to get and set parameters for the cluster health monitor (CHM) repository.
E. The diagcollection.pl script must be run from the Grid home directory as the Grid infrastructure owner.
F. The clusterware log files are stored inside the Grid Infrastructure Management Repository database usedby the cluster health monitor (CHM).

Answer : B,C,E

Question 13

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 isntance of CDB1 using service HR.
F. HR is available on a single instance of prod_pool.

Answer : B,F

Question 14

Your flex cluster has these attributes:
1.Hub nodes host01 and host02
2.Leaf nodes host03 and host04
3.Full Featured GNS is configured and running.
You attempt to run this command to add two more nodes to the cluster:
$ ./addnode.sh silent CLUSTER_NEW_NODES={host05,host06}
CLUSTER_NEW_NODE_ROLES={hub,leaf}
What is the result and the reason for this result?

A. It fails because no VIP was specified for the hub node host05.
B. It fails because hub and leaf nodes may not be added by the same execution of addNode.sh.
C. It fails because GNS doesnt assign VIPs for leaf nodes and no VIP was specified in the command.
D. It succeeds because no VIP specification is required for leaf nodes and none need to be specified for hubnodes when using full featured GNS.

Answer : B

Question 15

Which three statements are true regarding ACFS snapshots in Oracle 12c ASM?

A. They are contained in a directory on the same volume as their parent file system.
B. All ACFS snapshot operations for all filesystem are serialized clusterwide.
C. You can create a snapshot from an existing snapshot.
D. They can be administered using ASMCMD.
E. They can only be accessed when the file system is mounted.
F. They are always point-in-time copies of the parent file system.

Answer : B,C,E

Explanation:
All Oracle ACFS snapshot operations are serialized clusterwide in the kernel. you chose to create a snapshot image on an existing snapshot group, select a snapshot group from the existing snapshot group table (make sure you select a snapshot group that has not reached its maximum limit of snapshot images).
Before you can access the files on a file system, you need to mount the file system.
Reference: https://docs.oracle.com/database/121/OSTMG/GUID-5A3EF695-A795-4FEA-
8BE2AF657BD2238C.htm#OSTMG33000
http://mysupport.netapp.com/NOW/public/eseries/amw/index.html#page/
SANtricity_v11.20_Array_Management_Window_Help/create_PIT_image.html (Creating a
Snapshot image 3rd point, 1st line).
https://docs.oracle.com/cd/E19455-01/805-7228/6j6q7ueup/index.html (1st paragraph, 1st line).

Popular Vendors

Oracle Database 12c: RAC and Grid Infrastructure Administration v7.0 (1z0-068)

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15