1Z0-068 Exam Questions
162 real 1Z0-068 exam questions with expert-verified answers and explanations. Page 3 of 4.
- Question #102
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...
- Question #103
Which three statements are true about fully qualified file names in ASM? (Choose three.)
- Question #104
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?
- Question #105
Which three statements are true about using ADVM volumes and mounting ACFS file systems from leaf nodes in a Flex Cluster? (Choose three.)
- Question #106
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...
- Question #107
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? (...
- Question #108
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.)
- Question #109
Which three file types can be stored in an ASM Cluster file system (ACFS) and used by the relevant software? (Choose three.)
- Question #110
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...
- Question #111
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...
- Question #112
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-...
- Question #113
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...
- Question #114
Which three statements are true about the Global Resource Directory (GRD) in Oracle 12c RAC database and in Clustered ASM? (Choose three.)
- Question #115
Which three statements are true about an Oracle Database RAC software installation? (Choose three.)
- Question #116
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...
- Question #117
Identify two placeholder wait events that can be observed while a session is waiting to access a block. (Choose two.)
- Question #118
Which three resources are managed using global concurrency control in an Oracle 12c RAC multi- instance database? (Choose three.)
- Question #119
Which two statements are true concerning Oracle Enterprise Manager Cloud Control Cluster Database performance pages? (Choose two.)
- Question #120
Which three are benefits of using RAC databases with multiple instances? (Choose three.)
- Question #121
Which two statements are true about Instance Locks in Oracle 12c RAC? (Choose two.)
- Question #122
Which two statements are tuning recommendations for RAC database? (Choose two.)
- Question #123
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?...
- Question #124
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...
- Question #125
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...
- Question #126
Which two actions can restrict the number of instances used for parallel execution of a SQL statement? (Choose two.)
- Question #127
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...
- Question #128
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?
- Question #129
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...
- Question #130
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.)
- Question #131
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...
- Question #132
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...
- Question #133
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.)
- Question #134
Which two statements are true about resource profiles for administrator-managed RAC database services? (Choose two.)
- Question #135
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....
- Question #136
Which three statements are true concerning backups of the OCR and OLR in Oracle Clusterware 12c? (Choose three.)
- Question #137
Identify two reasons for the gc current block busy wait event. (Choose two.)
- Question #138
Which task must be performed before running the OPatch utility to patch Oracle Grid Infrastructure 12c?
- Question #139
Which two statements are true concerning the installation of Oracle Grid Infrastructure 12c when using a Standard Cluster? (Choose two.)
- Question #140
Which two actions guarantee that time is synchronized properly on all nodes in a cluster after installing Oracle Grid Infrastructure 12c? (Choose two.)
- Question #141
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.)
- Question #142
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...
- Question #143
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)?
- Question #144
Identify three prerequisites for the successful installation of Oracle Grid Infrastructure 12c for a standard cluster when using Full Featured Grid Naming Service (GNS).
- Question #145
Which three statements are true about diagnostic reporting for the OCR and OLR flies? (Choose three.)
- Question #146
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...
- Question #147
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.)
- Question #148
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.)
- Question #149
Which three are characteristics of leaf nodes in an Oracle Clusterware 12c Flex Cluster? (Choose three.)
- Question #150
Which three commands can be used to verify the integrity of Oracle Clusterware 12c OCR and OLR files? (Choose three.)
- Question #151
You are installing Oracle Grid Infrastructure 12c and configuring a Flex Cluster? Which two elements are required to support this configuration? (Choose two.)