1Z0-068 Exam Questions

Examine this command and output: [root@host01 ~]# / sbin/acfsutil snap create snap001 /u0l/app/grid/acfsmount/ acfsutil snap create: Snapshot operation is complete. Examine this co...

Which three statements are true about fully qualified file names in ASM? (Choose three.)

A clustered ASM Instance has the DATA diskgroup mounted. Which two can be used to display information about databases accessing files in the DATA diskgroup?

Which three statements are true about using ADVM volumes and mounting ACFS file systems from leaf nodes in a Flex Cluster? (Choose three.)

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...

Examine this command: SQL> ALTER TABLESPACE TBS1 ADD DATAFILE '+DATA(newtemplate)/ORCL/USERS/ mytab.dbf' SIZE 100M; Which two statements are required for this command to succeed? (...

Which three statements are true concerning the behavior of an Oracle Clusterware 12c Flex Cluster in response to hub or leaf node failures? (Choose three.)

Which three file types can be stored in an ASM Cluster file system (ACFS) and used by the relevant software? (Choose three.)

You administer an Oracle 12c RAC database whose clients connect to the database instances using SCAN listeners. Which two statements are true regarding client-side connect-time loa...

Which three statements are true about Oracle 12c multitenant RAC databases created using the Database Configuration Assistant (DBCA) on a cluster from a RAC database home? (Choose...

Examine this command: $ srvctl modify service -db RACDB -service SRVBl -clbgoal LONG This three-Instance RAC database uses Flex ASM. Which two statements are true regarding server-...

Examine this tnsnames entry from a RAC configuration using a SCAN listener: HR=(DESCRIPTION= (LOAD_BALANCE =on) (ADDRESS=(PROTOCOL=TCP)(HOST=cluster01-scan)(FORT=1521)) (CONNECT_DA...

Which three statements are true about the Global Resource Directory (GRD) in Oracle 12c RAC database and in Clustered ASM? (Choose three.)

Which three statements are true about an Oracle Database RAC software installation? (Choose three.)

PROD1, PROD2, and PROD3 are three Instance that have the PROD database open. The OLTP service was created using: $ srvctl add service -db prod -service OLTP -preferred PROD1, PROD2...

Identify two placeholder wait events that can be observed while a session is waiting to access a block. (Choose two.)

Which three resources are managed using global concurrency control in an Oracle 12c RAC multi- instance database? (Choose three.)

Which two statements are true concerning Oracle Enterprise Manager Cloud Control Cluster Database performance pages? (Choose two.)

Which three are benefits of using RAC databases with multiple instances? (Choose three.)

Which two statements are true about Instance Locks in Oracle 12c RAC? (Choose two.)

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

You administer a RAC database that currently runs on a four-node cluster but which has three instances. Which two statements are always true about redo logs for this RAC database?...

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...

You administer a three-instance, policy-managed, multitenant RAC database CDB1 with three PDBs: PDB_1, PDB_2, and PDB_3. You want to drop PDB_3. Which two statements are true? (Cho...

Which two actions can restrict the number of instances used for parallel execution of a SQL statement? (Choose two.)

You are administering an ORACLE RAC database with multiple instances. Examine this command executed from the PROD1 instance which succeeds: CREATE SPFILE FROM MEMORY; Which stateme...

Examine this command executed on the first node of a four-node cluster: $ <DATABASE_ORACLE_HOME>/0Patch/opatch apply 18031528 What does this command do?

You must deploy several Oracle 12c databases on an Oracle Grid Infrastructure Managed Cluster, and are required to have the ability to perform these actions without down time: 1. A...

Examine this command and output: You want to relocate this database online to node 016n2. Which two statements must be true for a successful online migration? (Choose two.)

You plan to use DBCA to convert a single-instance Oracle 12c database on a local filesystem on a stand- alone server to RAC by using ASM. You installed Grid Infrastructure 12c on a...

A Java application will be deployed, and you must configure a RAC database to support highly available connections. The application will use the Universal Connection Pool (UCP), an...

Examine this command: SQL> CREATE PLUGGABLE DATABASE pdb3 FROM pdb1; Which three conditions must be true for successful execution of this command on a RAC database? (Choose three.)

Which two statements are true about resource profiles for administrator-managed RAC database services? (Choose two.)

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....

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

Identify two reasons for the gc current block busy wait event. (Choose two.)

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

Which two statements are true concerning the installation of Oracle Grid Infrastructure 12c when using a Standard Cluster? (Choose two.)

Which two actions guarantee that time is synchronized properly on all nodes in a cluster after installing Oracle Grid Infrastructure 12c? (Choose two.)

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.)

Your four-node cluster runs Oracle 12c Clusterware and supports a mix of RAC databases from Oracle 10g Release 2 to Oracle 12c Release 1. All databases have one or more services de...

Which statement is true concerning the execution of the addNode.sh script for adding a node to an Oracle 12c Clusterware Standard Cluster that uses Grid Naming Service (GNS)?

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

Which three statements are true about diagnostic reporting for the OCR and OLR flies? (Choose three.)

You created a RAC database with DBCA and decide to verify it. The server pool large_db has four servers. Examine the output shown: Which two statements are true based on this outpu...

For which three entities can the "what-if" command evaluation be used to determine the impact of clusterware management operations in Oracle 12c Clusterware? (Choose three.)

Which two commands will stop the Oracle High Availability Services (OHAS) and prevent it from starting automatically at system boot on the local node? (Choose two.)

Which three are characteristics of leaf nodes in an Oracle Clusterware 12c Flex Cluster? (Choose three.)

Which three commands can be used to verify the integrity of Oracle Clusterware 12c OCR and OLR files? (Choose three.)

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