PassLeader now are offering 100% pass ensure 1Z0-068 dumps! All 1Z0-068 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-068 VCE dumps and PDF dumps: https://www.passleader.com/1z0-068.html (157 Q&As)
BTW: Download PassLeader 1Z0-068 dumps from Google Drive for free: https://drive.google.com/open?id=1aan7QmA8swwzUXqfcTLbpcNjfWXKdX0c
NEW QUESTION 131
Which two statements are tuning recommendations for RAC database? (Choose two.)
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.
Answer: DF
NEW QUESTION 132
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? (Choose two.)
A. A thread of redo must be created before starting a fourth instance if a thread is not already available.
B. A thread of redo must contain at least two log groups before it can be enabled.
C. A redo log group added using ALTER DATABASE ADD LOGFILE without the INSTANCE clause is added to each instance.
D. All the instances must have the same number of redo log groups and each group must have the same number of redo log members.
E. A thread of redo is automatically dropped when an instance is removed from a RAC database by using SRVCTL.
Answer: AB
NEW QUESTION 133
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
Answer: AD
NEW QUESTION 134
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.
Answer: C
NEW QUESTION 135
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. Apply a Grid Infrastructure interim patch
2. Apply a Grid Infrastructure Patch Set Update (PSU)
3. Apply a database on-line patch
4. Apply a Grid Infrastructure patchset
5. Apply a database patchset
6. Upgrade Grid Infrastructure from one release to another
7. Upgrade databases from one release to another
Your plan is to perform these tasks:
1. Install and configure Oracle Grid Infrastructure on a local file system
2. Install Oracle Database software on an ACFS file system
3. Create several RAC One Node databases
Which of the 7 requirements are met by your plan?
A. 1, 2, 3, 4, 5, 6 and 7.
B. 1, 2, 3, 4 and 6.
C. 1, 2, 3, 4, 5 and 6.
D. 1, 2, 3 and 4.
E. 2, 3, 4 and 6.
F. 2, 3, 4, 5 and 6.
Answer: F
NEW QUESTION 136
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:
1. Create a template and image files from the single-instance database by using DBCA
2. Perform an RMAN backup of the single-instance database
3. Validate the cluster using CLUVFY
4. Copy the template and image files to a cluster node
5. Restore the RMAN backup to the recovery area disk group on the cluster
6. Perform an Oracle Database 12c RAC installation
7. Create a RAC database with DBCA using the RMAN backup
8. 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
Answer: B
NEW QUESTION 137
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), and Fast Connection Failover (FCF) must be enabled. Which two statements are true? (Choose two.)
A. The application may use the JDBC thin driver.
B. The ons.jar file must be present in the CLASSPATH.
C. The ONS daemon must be started on the middle tier running the Java application.
D. You must configure TAF, either on the client or for the service.
E. The ONS daemon must be started on the middle tier and client machines to enable FCF.
Answer: AE
NEW QUESTION 138
Which two statements are true about resource profiles for administrator-managed RAC database services? (Choose two.)
A. It is automatically created when a service is created using SRVCTL ADD SERVICE.
B. It contains a list of server pools on which the instances hosting the service can run.
C. It contains a node list and instance-to-node mapping information for the service.
D. It specifies the instance to which the service should fail over, if the preferred instance shuts down or fails.
E. It is automatically created when a service is created using DBMS_SERVICE.CREATE_SERVICE.
Answer: AC
NEW QUESTION 139
Which three statements are true concerning backups of the OCR and OLR in Oracle Clusterware 12c? (Choose three.)
A. The OCR can be backed up using ocrconfig.
B. The OCR is backed up automatically every four hours.
C. The OCR is backed up by default to a cluster file system location.
D. The OLR can be backed up using ocrconfig.
E. The OLR is backed up automatically every four hours.
F. The OLR is backed up by default to a cluster file system location.
Answer: ADF
NEW QUESTION 140
Identify two reasons for the gc current block busy wait event. (Choose two.)
A. A block is busy in the local cache.
B. A block is busy in the remote cache.
C. The Cluster Interconnect is congested.
D. Either the local or remote CPUs have too large a run queue.
Answer: AB
NEW QUESTION 141
Which two statements are true concerning the installation of Oracle Grid Infrastructure 12c when using a Standard Cluster? (Choose two.)
A. The Clusterware binaries may be installed without installing ASM binaries.
B. The Grid Infrastructure Management Repository is only required when using ASM.
C. Specifying the use of Grid Naming Service is optional.
D. Normal Redundancy ASM Disk Groups used for Clusterware flies will contain three voting files regardless of the number of failgroups.
E. High Redundancy ASM Disk Groups used for Clusterware files will contain two OCRs.
Answer: AD
NEW QUESTION 142
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.)
A. Single Client Access Name (SCAN) virtual IP addresses (VIPs)
B. Grid Naming Service (GNS) VIPs
C. ASM Listener VIPs
D. High Available IP (HAIP) addresses uses for the cluster interconnect
E. Intelligent Platform Management Interface (IPMI) IP addresses
Answer: DE
NEW QUESTION 143
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 defined. The Oracle 10g Release 2 database clients connect to the database instances using the public VIP. The Oracle 11g Release 2 and 12c Release 1 clients connect to the database instances using the Single Client Access Name (SCAN). You must change the public VIPS. Which three steps must be done to change the VIPs on host01, the first node in the cluster? (Choose three.)
A. Use srvctl stop vip to stop the VIP on host01.
B. Use oifcfg setif to stop the VIP on host01.
C. Use srvctl start vip to start the VIP on host01.
D. Use srvctl modify nodeapps to change the VIP on host01.
E. Use oifcfg setif to start the VIP on host01.
Answer: ACD
NEW QUESTION 144
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)?
A. Adding a node to a Standard Cluster requires the specification of the CLUSTER_NEW_NODE_ROLES parameter.
B. Multiple nodes may be added to a standard cluster by a single execution of addNode.sh.
C. Nodes in a Standard Cluster must have a VIP specified when adding the node to a cluster.
D. Nodes in a Standard Cluster must have a High Availability IP (HAIP) adaptor specified when adding the node to a cluster.
Answer: A
NEW QUESTION 145
Identify three prerequisites for the successful installation of Oracle Grid Infrastructure 12c for a standard cluster when using Full Featured Grid Naming Service (GNS). (Choose three.)
A. You must create a Grid Management Repository database.
B. You must enable the Name Server Cache Daemon (NSCD).
C. A DHCP service on the private network for the cluster is required to allocate virtual IP addresses for HAIP.
D. Each cluster node must have at least two network interface cards.
E. DNS must be configured to delegate name resolution for the cluster subdomain to the cluster.
F. A DHCP service on the public network for the cluster is required to allocate virtual IP addresses as required by the cluster.
Answer: CEF
NEW QUESTION 146
Which three statements are true about diagnostic reporting for the OCR and OLR flies? (Choose three.)
A. The OCRDUMP utility can dump specific keys from the OCR in an online fashion with the clusterware running on all nodes.
B. The OCRDUMP utility can dump specific keys from the OLR in an online fashion with the clusterware running on all nodes.
C. The OCRCONFIG utility can be used to repair a corrupt OCR file in an online fashion with the clusterware running on all nodes.
D. The OCRCHECK utility can check the OLR in an online fashion with the clusterware running on all nodes.
E. The CLUVFY utility can check the integrity of the OCR but not the OLR.
Answer: ACE
NEW 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.)
A. Pluggable Databases (PDBs)
B. administrator-defined resources
C. local resources
D. database transactions
E. cluster resources
Answer: ABE
NEW 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.)
A. crsctl stop crs
B. crsctl stop cluster
C. crsctl disable crs
D. crsctl config crs
Answer: AC
NEW QUESTION 149
Which three are characteristics of leaf nodes in an Oracle Clusterware 12c Flex Cluster? (Choose three.)
A. They can be on a different subnet to the hub nodes.
B. Grid Naming Service (GNS) must exist on one of the leaf nodes.
C. They discover hub nodes automatically at startup.
D. They require direct access to shared storage.
E. They may discover hub nodes without having the DNS delegation configured by network administrators.
F. Oracle database 12c RAC instances may not run on leaf nodes.
Answer: CEF
NEW QUESTION 150
……
PassLeader now are offering 100% pass ensure 1Z0-068 dumps! All 1Z0-068 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-068 VCE dumps and PDF dumps: https://www.passleader.com/1z0-068.html (157 Q&As)
BTW: Download PassLeader 1Z0-068 dumps from Google Drive for free: https://drive.google.com/open?id=1aan7QmA8swwzUXqfcTLbpcNjfWXKdX0c