1z0-068 — Free Practice Questions
10 free sample questions from a bank of 62, with the correct answers and explanations. No signup required — start practising right now.
1Which two statements are true regarding ASM Dynamic Volume manager (ADVM)?
- To create an ADVM volume, disk group attributes COMAPTIBLE.ASM and COMPATIBLE.ADVM must be minimally set to 12.1.
- An ADVM volume is individually named and can contain only one file system.
- Only one ADVM volume can be created in an ASM disk group.
- ADVM extends ASM by providing a device driver interface to storage backed by an ASM disk group.
- File systems contained in ADVM volumes may only contain database files.
Answer:
2You just added an ASM disk to the DATA diskgroup.
Which two can be used to monitor the rebalancing?
- ams_cmd lsop
- v$asm_disk
- v$asm_operation
- v$asm_diskgroup
- v$session_longops
- amscmd lsdg
Answer:
3Examine 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.)
- The DB_CREATE_FILE_DEST parameter must be set to +DATA(newtemplate).
- newtemplate must be defined for the +DATA disk group.
- Existing data files in TBS1 must also use the same template.
- The +DATA disk group should not be part of Flex ASM.
- User-defined subdirectories ORCL and USERS must already exist.
Answer:
4Examine 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.)
- It is enabled only when LOAD_BALANCE=YES is coded in the client-side TNS entry used by the client.
- The SCAN listeners redirect clients to the node listener serving the instance that has the fewest sessions for the SRVB1 service.
- The SCAN listeners automatically balance the connections across the instances accepting logins for the SRVB1 service.
- It is disabled because the -c1bgoal attribute is set to LONG.
- The SCAN listeners redirect clients to the node listener serving the instance that has the fastest response time for the SRVB1 service.
Answer:
5Examine 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.)
- The host name in the tnsnames entry must be changed if nodes are added or removed from the Cluster.
- Clients using EZConnect can benefit from connect time load balancing because the tnsnames entry refers to a SCAN listener.
- Client connection requests are automatically balanced across all IP addresses defined for the SCAN.
- A client connection request is received by a SCAN listener that creates the connection to the least-loaded database instance.
- Client connection requests are automatically failed over to another SCAN listener if the chosen SCAN listener is not available.
Answer:
6Which two statements are true concerning Oracle Enterprise Manager Cloud Control Cluster Database performance pages? (Choose two.)
- The Interconnects page shows the load contributed by database instances on the public network.
- The Interconnects page shows the load contributed by database instances on the private interconnect and the public network.
- The Interconnects page shows throughput contributed by individual sessions on the private interconnect.
- The Cluster Cache Coherency page shows which block classes are subject to intense global cache activity.
- The Cluster Cache Coherency page shows which instances are responsible for intense global cache activity.
Answer:
7Which three are benefits of using RAC databases with multiple instances? (Choose three.)
- surviving node failures
- surviving storage network failures
- surviving interconnect failures
- automatic workload management for services on local connections
- automatic workload management for services on Oracle Net connections
- parallel execution across all instances supporting a balanced policy-management service
- parallel execution across all instances supporting a singleton policy-management service
Answer:
8Which three statements are tuning recommendations for RAC database? (Choose three.)
- Set PARALLEL_DEGREE_POLICY=AUTO to enable In Memory Parallel Query.
- Use sequences with CACHE and ORDER, if possible.
- Use Locally Managed Tablespaces with large uniform extent sizes.
- Use Locally Managed Tablespaces with autoallocate.
- Set PARALLEL_DEGREE_POLICY=AUTO to enable automatic Parallel Statement Queueing.
- Use sequences with CACHE and NOORDER, if possible.
Answer:
9You 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.)
- PDB_3 must be closed on all CDB1 instances.
- Manually created services for PDB_3 are not removed automatically from the OCR when dropping PDB_3.
- CDB1 must be open in restricted mode on all cluster nodes.
- PDB_3 must be open READ ONLY in all CDB1 instances.
- Manually created services for PDB_3 are removed automatically from the OCR when dropping PDB_3.
Answer:
10Which two actions can restrict the number of instances used for parallel execution of a SQL statement? (Choose two.)
- setting the PARALLEL_DEGREE_POLICY to LIMITED
- setting the PARALLEL_FORGE_LOCAL to TRUE
- setting the PARALLEL_SERVERS_TARGET value equal to that of PARALLEL_MAX_SERVERS
- using a database service to limit the number of instances that participate in parallel execution
- creating a UNIFORM service for a policy-managed RAC database
Answer:
Want the full bank of 62 questions for 1z0-068? See all practice exams.