Is this exam completely free?

ExamCademy offers a free preview for every exam, covering around 20% of the total questions. Full access to all questions is available for free by signing up for an account. Optional supporters unlock AstroTutor (AI tutor) and advanced study modes.

Can I practice IT certification exams from Microsoft, AWS, or CompTIA?

Yes! ExamCademy supports a wide range of IT certification exams including Microsoft Azure, AWS Cloud Practitioner, and CompTIA A+ and Security+.

How accurate are the mock exams?

Our practice questions are community-created and moderator-reviewed to align with realistic exam objectives, style, and difficulty.

1z0-068 by Oracle - Page 1 | ExamCademy

Mode Selection

Question 1

Question 2

Question 3

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? (Choose two.)

A The DB_CREATE_FILE_DEST parameter must be set to +DATA(newtemplate).
B newtemplate must be defined for the +DATA disk group.
C Existing data files in TBS1 must also use the same template.
D The +DATA disk group should not be part of Flex ASM.
E User-defined subdirectories ORCL and USERS must already exist.

Question 4

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-side connect-time load balancing using SCAN listeners for this service? (Choose two.)

A It is enabled only when LOAD_BALANCE=YES is coded in the client-side TNS entry used by the client.
B The SCAN listeners redirect clients to the node listener serving the instance that has the fewest sessions for the SRVB1 service.
C The SCAN listeners automatically balance the connections across the instances accepting logins for the SRVB1 service.
D It is disabled because the -c1bgoal attribute is set to LONG.
E The SCAN listeners redirect clients to the node listener serving the instance that has the fastest response time for the SRVB1 service.

Question 5

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_DATA=(SERVICE_NAME=HRSRV)))
Which two statements are true about clients using this entry to connect? (Choose two.)

A The host name in the tnsnames entry must be changed if nodes are added or removed from the Cluster.
B Clients using EZConnect can benefit from connect time load balancing because the tnsnames entry refers to a SCAN listener.
C Client connection requests are automatically balanced across all IP addresses defined for the SCAN.
D A client connection request is received by a SCAN listener that creates the connection to the least-loaded database instance.
E Client connection requests are automatically failed over to another SCAN listener if the chosen SCAN listener is not available.

Question 6

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

A The Interconnects page shows the load contributed by database instances on the public network.
B The Interconnects page shows the load contributed by database instances on the private interconnect and the public network.
C The Interconnects page shows throughput contributed by individual sessions on the private interconnect.
D The Cluster Cache Coherency page shows which block classes are subject to intense global cache activity.
E The Cluster Cache Coherency page shows which instances are responsible for intense global cache activity.

Question 7

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

A surviving node failures
B surviving storage network failures
C surviving interconnect failures
D automatic workload management for services on local connections
E automatic workload management for services on Oracle Net connections
F parallel execution across all instances supporting a balanced policy-management service
G parallel execution across all instances supporting a singleton policy-management service

Question 8

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

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

Question 9

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? (Choose two.)

A PDB_3 must be closed on all CDB1 instances.
B Manually created services for PDB_3 are not removed automatically from the OCR when dropping PDB_3.
C CDB1 must be open in restricted mode on all cluster nodes.
D PDB_3 must be open READ ONLY in all CDB1 instances.
E Manually created services for PDB_3 are removed automatically from the OCR when dropping PDB_3.

Question 10

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

A setting the PARALLEL_DEGREE_POLICY to LIMITED
B setting the PARALLEL_FORGE_LOCAL to TRUE
C setting the PARALLEL_SERVERS_TARGET value equal to that of PARALLEL_MAX_SERVERS
D using a database service to limit the number of instances that participate in parallel execution
E creating a UNIFORM service for a policy-managed RAC database

Question 11

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 statement is true?

A An SPFILE is created and contains parameter settings only for PROD1.
B An SPFILE is created and contains parameter settings for all instances.
C An SPFILE is created for each instance containing instance-specific parameter settings only.
D An SPFILE is created for each instance and contains parameter settings for all instances.

Question 12

Examine this command and output:

Question 13

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 four-node cluster.
Examine this list of possible conversion steps:

Create a template and image files from the single-instance database by using DBCA.
Perform an RMAN backup of the single-instance database.
Validate the cluster using CLUVFY.
Copy the template and image files to a cluster node.
Restore the RMAN backup to the recovery area disk group on the cluster.
Perform an Oracle Database 12c RAC installation.
Create a RAC database with DBCA using the RMAN backup.
Create a RAC database with DBCA using the template.
Which statement correctly lists the minimum steps required to perform the conversion?

A 1, 3, 4, 6, 8
B 2, 3, 5, 7
C 2, 5, 6, 7
D 1, 4, 6, 8
E 1, 4, 8
F 2, 5, 7

That's the end of the Preview

Create a free account to unlock all questions for this exam.

Log In / Sign Up

Page 1 of 3 • Questions 1-25 of 62

1 2 3

→

Know a question that should be here? Contribute to this exam

Which two statements are true regarding ASM Dynamic Volume manager (ADVM)?

A To create an ADVM volume, disk group attributes COMAPTIBLE.ASM and COMPATIBLE.ADVM must be minimally set to 12.1.
B An ADVM volume is individually named and can contain only one file system.
C Only one ADVM volume can be created in an ASM disk group.
D ADVM extends ASM by providing a device driver interface to storage backed by an ASM disk group.
E File systems contained in ADVM volumes may only contain database files.

You just added an ASM disk to the DATA diskgroup.
Which two can be used to monitor the rebalancing?

A ams_cmd lsop
B v$asm_disk
C v$asm_operation
D v$asm_diskgroup
E v$session_longops
F amscmd lsdg

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

A The database must be stored on shared storage.
B The database must have at least two UNDO tablespaces.
C The database must have at least two redo threads defined by the DBA.
D Database clients must disconnect before the online relocation timeout expires.
E Database clients must use Transaction Guard to prevent them from losing their connection.
F The database must be open.