1z0-068
Free trial
Verified
Question 1
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.
Question 2
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
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:
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.
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 your free questions
You’ve reached the preview limit for 1z0-068Consider upgrading to gain full access!
Free preview mode
Enjoy the free questions and consider upgrading to gain full access!