1z0-068 by Oracle Valid Free Exam Practice Test

Question 1

Which two types of IP addresses does Oracle Clusterware 12c acquire from DHCP when it started up on a cluster node using Grid Naming Service (GNS)? (Choose two.)

A. Grid Naming Service (GNS) VIPs B. ASM Listener VIPs C. Single Client Access Name (SCAN) virtual IP addresses (VIPs) D. High Available IP (HAIP) addresses uses for the cluster interconnect E. Intelligent Platform Management Interface (IPMI) IP addresses

Correct Answer: D,E

Question 2

You plan to apply a patchset to a RAC database running on a two-node cluster.
The cluster has this configuration:
* Grid infrastructure release 12.1.0.1.0
* RAC database release 12.1.0.1.0
* All software installed on local file systems
* The database is deployed on ASM disk groups.
Examine this list of possible tasks (see exhibit).
Exhibit:

Identify the required tasks in the correct order to apply the patchset with the least amount of down time.

A. 3, 2, 5 and 8 B. 1, 2, 3, 5 and 8 C. 3, 2, 5, 2 and 8 D. 1, 3, 2, 5 and 8 E. 3, 2, 6 and 8

Correct Answer: D

Question 3

Which three statements are true concerning policy-based cluster management in Oracle 12c Clusterware?

A. All servers in a new cluster installation belong to the free server pool. B. All servers in a new cluster installation belong to the generic server pool. C. The server pool contains servers that host administrator-defined high availability resources. D. Server pools must be managed with the srvctl utility for servers hosting a database. E. Server Pools must be managed with the crsctl utility for servers hosting an application or other administrator-defined high-availability resource.

Correct Answer: A,C,D

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 4

Which two Operating System users and groups must be created on each node before installing Oracle Grid Infrastructure 12c?

A. an O/S group called dba B. an O/S group to own the software inventory C. a group to own the ASMLIB-provisioned storage D. an O/S user to own the Grid infrastructure installation E. a group to own Automatic-Storage Management (ASM) Filter Driver-provisioned storage F. an O/S user to own the Oracle Database installation G. an O/S user to own the Clusterware installation and a different O/S user to own the Automatic Storage Management (ASM) installation

Correct Answer: A,B

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 5

A directory +DATA/ORCL/DATAFILE/USERS exists in ASM.
USERS is a user created directory; ORCL and DATAFILE are system generated directories.
Which two statements are true about user-created directories?

A. You can create subdirectories under the USERS directory. B. You cannot create a user-defined directory at the root (+) level. C. You cannot create a nested subdirectory /USER1/2014 under USERS with a single CREATE DIRETORY command even if directory USER1 doesn't exist. D. You cannot rename a user-created subdirectory. E. You cannot drop a directory containing aliases unless you delete the aliases first.

Correct Answer: B,C

Question 6

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

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

Correct Answer: C,D,E

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 7

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

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

Correct Answer: C,D

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 8

PROD1, PROD2 and PROD3 are three active instances of the PROD database.
Examine these commands executed on PROD1:
SQL > ALTER SYSTEM SET PARALLEL_MIN_SERVERS=200 SCOPE=MEMORY sid='*';
SQL > ALTER SYSTEM SET PARALLEL_MIN_SERVERS=100 SCOPE=MEMORY sid='PROD1'; Which statement is true?

A. PARALLEL_MIN_SERVERS will be 100 for all instances of PROD. B. PARALLEL_MIN_SERVERS will be 200 for PROD2 and PROD3 and 100 for PROD1. C. PARALLEL_MIN_SERVERS will be 200 for all instances of PROD. D. The second statement returns an error because this parameter must be identical for all instances.

Correct Answer: B

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Oracle Database 12c: RAC and Grid Infrastructure Administrator - 1z0-068 Exam Practice Test