Oracle Database 12c: RAC and Grid Infrastructure Administrator - 1z0-068 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Which two statements are true about vsam views in a clustered environment
?

A. Their names can be seen in vfixed_table when connected to an instance of any type that is started. B. gvasm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in the cluster. C. Their names can be seen in dict when connected to an ASM instance. D. They exist in both in ASM and RDBSM instances, but they can display different outputs depending on the instance type. E. They exist both in ASM and RDBMS instances, and display the same output.

Discussion 0

Correct Answer: C,D Vote an answer

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

Question 2

Examine this command and output:

Examine this list of commands:
1. srvct1 convert db -db ron -dbtype rac -node o16n1
2. srvct1 convert db -db ron -dbtype raconenode -node 016n1
3. srvct1 add instance -db ron -instance ron_1 -node 016n1
4. srvct1 add instance -db ron -in5tance ron_2 -node 016n2
5. srvct1 start instance -db ron -instance ron_1
6. srvct1 start instance -db ron -instance ron_2
Currently, there is an instance of database ron running on o16n1.
You want to convert ron to a RAC database and make all instances available.
Identify the commands required, in the correct order, to accomplish this.

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

Discussion 0

Correct Answer: F Vote an answer

Question 3

Which two utilities support the "what-if" command evaluation?

A. asmcmd B. oifcfg C. crsctl D. srvctl E. ocrconfig

Discussion 0

Correct Answer: C,D Vote an answer

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

Question 4

Identify three prerequisites for the successful installation of Oracle Grid Infrastructure 12c for a standard cluster when using Full Featured Grid Naming Service (GNS).

A. DNS must be configured to delegate name resolution for the cluster subdomain to the cluster. B. Each cluster node must have at least two network interface cards, C. A DHCP service on the public network for the cluster is required to allocate virtual IP addresses as required by the cluster. D. You must create a Grid Management Repository database. E. You must enable the Name Server Cache Daemon (NSCD). F. A DHCP service on the private network for the cluster is required to allocate virtual IP addresses for HAIP.

Discussion 0

Correct Answer: A,C,F Vote an answer

Question 5

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

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

Discussion 0

Correct Answer: A,B,C Vote an answer

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

Question 6

You performed these steps to disable an ADVM volume containing an ACFS file system:
1. Dismount the file system.
2. Disable the volume with the ASMCMD voldisable command.
Which two statements are true regarding the actions performed? (Choose two.)

A. The ACFS file system will be permanently removed from the volume. B. The ACFS le system will be permanently removed from the volume only if the file system is empty. C. The disabling of volume does not destroy data in the file system. D. The ACFS mount registry with Oracle restart is automatically deleted. E. The volume can be enabled and the le system can be mounted back again to access the existing data.

Discussion 0

Correct Answer: C,E Vote an answer

Question 7

Which two statements are tuning recommendations for RAC database? (Choose two.)

A. Set PARALLEL_DEGREE_POLICY=AUTO to enable automatic Parallel Statement Queueing. B. Use Locally Managed Tablespaces with large uniform extent sizes. C. Use sequences with CACHE and NOORDER, if possible. D. Set PARALLEL_DEGREE_POLICY=AUTO to enable In Memory Parallel Query. E. Use Locally Managed Tablespaces with autoallocate. F. Use sequences with CACHE and ORDER, if possible.

Discussion 0

Correct Answer: C,E Vote an answer

Question 8

Which task must be performed before running the OPatch utility to patch Oracle Grid Infrastructure 12c?

A. Stage the patch on the cluster nodes. B. Stage the patch on the cluster node where the OPatch utility will be executed. C. Update the PATH environment variable on the node where will run the OPatch utility to point to the
$ORACLE_HOME/OPatch directory. D. Update the PATH environment variable on each cluster node to point to the $ORACLE_HOME/OPatch directory.

Discussion 0

Correct Answer: C Vote an answer

Question 9

You are installing Oracle Grid Infrastructure 12c and configuring a Flex Cluster?
Which two elements are required to support this configuration? (Choose two.)

A. a network interface for the public network B. a network interface for private interconnect only C. a Grid Management Cluster Health Management (CHM) application server D. a Grid Management Repository database E. a network interface for ASM and private interconnect traffic

Discussion 0

Correct Answer: B,D Vote an answer

Question 10

Which two statements are true regarding ASM when installing Oracle Grid Infrastructure 12c? (Choose two.)

A. If ASM disk groups are configured for the Clusterware files, then ASM must be used for all databases on the cluster. B. The Installer permits the creation of a disk group to be used for the Recovery Area for the ASM instance. C. The Installer permits the creation of a disk group for use by the voting disks and OCR file. D. If no ASM disk groups are specified during installation, then ASM instances are not started after the installation completes on any cluster node. E. ASM disk groups used for voting files and OCR files require a quorum failgroup.

Discussion 0

Correct Answer: A,E Vote an answer

Question 11

Which three options have a RAC-specific tuning component?

A. sequence definitions B. contention for archived redo log files C. contention on index leaf blocks D. the size of the online redo log buffers E. the load on the Cluster Interconnect F. contention for online redo log files

Discussion 0

Correct Answer: A,C,E Vote an answer

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

Question 12

Examine this query and output:
SQL> select order_flag, cache_size, session_flag, keep_value,
2 from user_sequences where sequence_name = 'SEQ1';
O CACHE_SIZE S K
-- ------------------- -- --
Y 10 N N
Performance analysis revealed severe SQ enqueue contention on the SEQ1 sequence.
The SEQ1 sequence is incremented from all instances equally and is frequently used.
Which two statements should you execute to reduce SQ enqueue contention?

A. alter sequence seq1 keep; B. exec sys.dbms_shared_pool.keep ('SEQ1', 'Q') C. alter sequence seq1 cache 10000; D. alter sequence seq1 noorder; E. alter sequence seq1 order;

Discussion 0

Correct Answer: C,D Vote an answer

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

Question 13

Examine these commands:
srvctl add service -db RACDB -service CRM -preferred RACDB_1 -available RACDB_2 - tafpolicy preconnect srvcl start service -db RACDB -service CRM Instances RACDB_1 and RACDB_2 run on host0l and host02, respectively.
This is the only TNS entry in the client side tnsnames.ora:
CRM =
(DESCRIPTION =(FAILOVER=ON) (LOAD_BALANCE=ON)
(ADDRESS= (PROTOCOL=TCP) (HOST=host0l-VIP.example.com)(PORT=1521))
(ADDRESS= (PROTOCOL=TCP) (HOST=host02-VIP.example.com)(PORT=1521))
(CONNECT_DATA = (SERVICE_NAME = CRM)
(FAILOVER_MODE = (BACKUP=CRM_PRECONNECT)
(TYPE=SESSION)(METHOD=PRECONNECT))))
Which statement is true regarding the TAF settings?

A. The configuration is incomplete because the TNS entry for the preconnected backup session is missing. B. Clients using this configuration fail over and restart any active queries automatically. C. This configuration will work only for a policy-managed RAC database. D. Clients using this configuration fail over and restart any active transactions automatically.

Discussion 0

Correct Answer: A Vote an answer

Question 14

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

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

Discussion 0

Correct Answer: A,B Vote an answer

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

Question 15

Which three statements are true concerning backups of the OCR and OLR in Oracle Clusterware 12c? (Choose three.)

A. The OCR is backed up by default to a cluster file system location. B. The OCR is backed up automatically every four hours. C. The OLR can be backed up using ocrconfig. D. The OLR is backed up automatically every four hours. E. The OLR is backed up by default to a cluster file system location. F. The OCR can be backed up using ocrconfig.

Discussion 0

Correct Answer: C,E,F Vote an answer