1Z0-068 | Improved 1Z0-068 Bundle 2019

It is impossible to pass Oracle 1Z0-068 exam without any help in the short term. Come to Pass4sure soon and find the most advanced, correct and guaranteed Oracle 1Z0-068 practice questions. You will get a surprising result by our Latest Oracle Database 12c: RAC and Grid Infrastructure Administration practice guides.

NEW QUESTION 1
Which task must be performed before running the OPatch utility to patch Oracle Grid Infrastructure 12c?

  • A. Update the PATH environment variable on each cluster node to point to the $ORACLE_HOME/OPatch directory.
  • B. Stage the patch on the cluster node where the OPatch utility will be executed.
  • C. Update the PATH environment variable on the node where will run the OPatch utility to point to the$ORACLE_HOME/OPatch directory.
  • D. Stage the patch on the cluster nodes.

Answer: C

NEW QUESTION 2
You are installing Oracle Grid Infrastructure 12c and configuring a Flex Cluster? Which two elements are required to support this configuration? (Choose two.)

  • A. a Grid Management Repository database
  • B. a network interface for ASM and private interconnect traffic
  • C. a network interface for private interconnect only
  • D. a network interface for the public network
  • E. a Grid Management Cluster Health Management (CHM) application server

Answer: AC

NEW QUESTION 3
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 4
Which three statements are true about ASM Cloud File System (ACFS) tagging?

  • A. acfssettag is a command provided by a platform-independent API to tag files.
  • B. acfssettag is a command provided by a platform-dependent API to tag files.
  • C. ACFS tagging is used to mark a subset of files in an ACFS file system for replication.
  • D. acfsutil encr on can be used to specify the tag names of the files to be encrypted.
  • E. acfsutil tag set can be used to tag files.

Answer: ACE

Explanation:
A: The acfssettag command sets the tag name on an Oracle ACFS file.
Syntax
sb8 acfssettag(const oratext *path, const oratext *tagname, oratext *value,
size_t size, ub4 flags);
C: Oracle ACFS tagging assigns a common naming attribute to a group of files. Oracle ACFS Replication can use this tag to select files with a unique tag name for replication to a different remote cluster site. The tagging option avoids having to replicate an entire Oracle ACFS file system.
E: The acfsutil tag set command adds the given tag to the specified files or directories in an Oracle ACFS file system.

NEW QUESTION 5
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 6
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 7
You must replace a failed disk that was dropped from a disk group.
You want the rebalance operation to occur with minimal performance impact.
Which two options exist to achieve this? (Choose two.)

  • A. Make sure that the ASM_POWER_LIMIT parameter is set to 1 before rebalancing the disk group.
  • B. Increase the value of the DISK_REPAIR_TIME attribute for the disk group.
  • C. Use the WAIT clause with the ALTER DISKGROUP command.
  • D. Decrease the value of the DISK_REPAIR_TIME attribute for the disk group.
  • E. Set the POWER clause to 1 in the ALTER DISKGROUP command.

Answer: AB

NEW QUESTION 8
Which two statements are true about ASM alias names?

  • A. ASM files created using an alias name are not OMF files even if OMF is enabled.
  • B. Alias file names cannot be used together with templates when creating tablespaces.
  • C. ASM files created using an alias name are OMF files even if OMF is not enabled.
  • D. Alias names can be stored only in user-defined directories.
  • E. ASM files created using an alias name also have a fully qualified name and can be accessed by either name.

Answer: CE

NEW QUESTION 9
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 10
Your flex cluster has these attributes:
1. Hub nodes host01 and host02
2. Leaf nodes host03 and host04
3. Full Featured GNS is configured and running.
You attempt to run this command to add two more nodes to the cluster:
$ ./addnode.sh –silent “CLUSTER_NEW_NODES={host05,host06}” “CLUSTER_NEW_NODE_ROLES={hub,leaf}”
What is the result and the reason for this result?

  • A. It fails because no VIP was specified for the hub node host05.
  • B. It fails because hub and leaf nodes may not be added by the same execution of addNode.sh.
  • C. It fails because GNS doesn’t assign VIPs for leaf nodes and no VIP was specified in the command.
  • D. It succeeds because no VIP specification is required for leaf nodes and none need to be specified for hub nodes when using full featured GNS.

Answer: A

Explanation:
Hub Nodes always have VIPs.

NEW QUESTION 11
You support a three-instance, policy-managed, multitenant RAC database CDB1 with two PDBs PDB_1 and PDB_2.
It runs on an eight-node cluster and a serverpool prod_pool has three servers. Examine these commands executed on HOST01:
$ srvctl add service –db CDB1 –pdb PDB_1 –service HR –serverpool prod_pool
$ srvctl start service –db CDB1 –service HR
$ srvctl stop service –db CDB1 –service HR Which two statements are true?

  • A. HR is uniformly managed across all instances in prod_pool.
  • B. srvctl stop service only closes PDB_1 in the instance on HOST01.
  • C. srvctl stop service closes PDB_1 on all CDB1 instances.
  • D. srvctl stop service prevents logins for HR only to CDB1 on HOST01.
  • E. srvctl stop service prevents logins to any instance of CDB1 using service HR.
  • F. HR is available on a single instance of prod_pool.

Answer: AE

NEW QUESTION 12
You administer a three-instance, policy-managed, multitenant RAC database CDB1 with two PDBs: PDB_1 and PDB_2.
Examine these commands executed on host01:
$ srvctl add service –db CDB1 –pdb PDB_1 –serverpool prod_pool –cardinality singleton
$ srvctl start service –db CDB1 –service CRM
$ srvctl stop service –db CDB1 –service CRM Which three statements are true?

  • A. CRM is only available for new logins on the CDB1 instance on host01.
  • B. CRM is available for new logins on one CDB1 instance.
  • C. The srvctl start service command automatically opens PDB_1 if not already opened.
  • D. The srvctl stop service command does not close PDB_1 on any instance of CDB1.
  • E. The CRM service is not available for new logins on any instance of CDB1.

Answer: CDE

NEW QUESTION 13
Which three statements are true about Oracle Enterprise Manager Topology Viewer?

  • A. It displays which listeners listen on behalf of which instances.
  • B. It displays the relationship between targets of different target types in a cluster.
  • C. It displays the status of all cluster components.
  • D. It displays the status of Pluggable Databases (PDBs) in a multitenant container database (CDB).
  • E. It displays the relationship between clustered ASM and cluster databases if the database is stored in ASM.
  • F. It displays the type of network used by RAC database instance.

Answer: ABE

Explanation:
Using the topology view you can quickly see the components that comprise your cluster database environment, such as database instances, listeners, Oracle ASM instances, hosts, and interfaces.
Note: Enterprise Manager provides a Topology Viewer which is a graphical representation of routing relationships across targets, components and elements. You can easily determine how requests are routed across components. For example, you can see how requests are routed from Oracle Web Cache, to Oracle HTTP Server, to a Managed Server, to a data source.
The Topology Viewer allows you to view the relationships between components, nodes, or objects within different Oracle applications.
References: https://docs.oracle.com/database/121/TDPRC/racmon2.htm#TDPRC350

NEW QUESTION 14
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.

Answer: AD

NEW QUESTION 15
Oracle Clusterware manages an administrator-managed database service defined with the MANUAL management policy.
Which two statements are true?

  • A. The service must be manually restarted with SRVCTL every time the instance hosting the service fails.
  • B. Clusterware will monitor the service while it is active.
  • C. The service must be manually restarted with SRVCTL after restarting the Clusterware stack on the node hosting the service.
  • D. When manually started, the service will always start on one or more available instances rather than on their preferred instances.
  • E. The service must be manually started with SRVCTL after a planned restart of the instance hosting the service.

Answer: BE

Explanation:
MANUAL: The database is never automatically restarted upon restart of the database host computer. A MANUAL setting does not prevent Oracle Clusterware from monitoring the database while it is running and restarting it if a failure occurs.
Note: To prevent Oracle Clusterware from restarting your Oracle RAC database when you restart your system, or to avoid restarting failed instances more than once, configure a policy to define the degree of control. There are two policies, automatic, which is the default, and manual.
References: https://docs.oracle.com/database/121/RACAD/srvctladmin.htm

NEW QUESTION 16
Which three events occur when a hub node fails in an Oracle Clusterware 12c Flex Cluster?

  • A. The hub node is evicted from the cluster
  • B. Leaf nodes connected to the failing hub node are reconnected to a surviving hub node without service disruption.
  • C. Cluster resources running on leaf nodes connected to the failed hub node are relocated to one or more surviving hub nodes.
  • D. Cluster resources running on leaf nodes connected to the failed hub node are relocated to one or more surviving leaf nodes.
  • E. Cluster resources running on the failed hub node are relocated to one or more surviving hub nodes.
  • F. Cluster resources running on the failed hub node are relocated to one or more surviving leaf nodes.
  • G. Cluster resources running on the failed hub node are relocated to one or more surviving hub nodes or leaf nodes, or both.

Answer: ABE

NEW QUESTION 17
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 18
Which three statements are true about the Global Resource Directory (GRD) in Oracle 12c RAC database and in Clustered ASM? (Choose three.)

  • A. All GRDEnqueue Resource master metadata is held in the shared pool of the same database instance.
  • B. Clustered ASM has GRD resources distributed among all ASM instances
  • C. RAC databases have GRD cache resources distributed among all the database instances and stored in the large pool of each instance.
  • D. RAC databases have GRD cache resources distributed among all the database instances and stored in the shared pool of each instance.
  • E. All GRDEnqueue Resource master metadata is held in the large pool of the same database instance.
  • F. Shadow GRD resources may exist in more than one database instance for a resource.
  • G. Only one GRD shadow resource may exist for an Enqueue Resource.

Answer: BDF

NEW QUESTION 19
When using Oracle 12 Clusterware, which two actions are required to repair the ocr.loc file on host01 in a cluster having three other nodes called host02, host03, and host04?

  • A. Run ocr.config –repair on another node in the cluster to repair the ocr.loc file on host01
  • B. Stop the clusterware stack on host01 only.
  • C. Stop the clusterware stack on all cluster nodes.
  • D. Run ocrconfig –repair on host01.
  • E. Stop the clusterware stack on host01 and on the node used to issue the ocrconfig –repair command.

Answer: BD

Explanation:
B: You cannot repair the OCR configuration on a node on which the Oracle Cluster Ready Services daemon is running.
D: When you repair OCR on a stopped node using ocrconfig -repair, you must provide the same OCR file name (which should be case-sensitive) as the OCR file names on other nodes.

NEW QUESTION 20
Examine these commands:
$ srvctl add service –db racdb –service erp –serverpool srvpooll
- failovertype TRANSACTION –commit_outcome TRUE – replay_init_time 1800
- retention 86400 –notification TRUE –rlbgoal SERVICE_TIME –clbgoal SHORT
- failoverretry 30 – failoverdelay 10
$ srvctl start service – db racdb – service erp
Instances RACDB_1 and RACDB_2 run on host01 and host02, respectively. Which three statements are true regarding the service erp?

  • A. Connections to the database using erp benefit from Application Continuity.
  • B. erp is configured for an administrator-managed RAC database.
  • C. Load Balancing Advisory (LBA) will be disabled for this service.
  • D. Connections to the database using erp benefit from Load Balancing.
  • E. Connections to the database using erp benefit from Transaction Guard.

Answer: ADE

Explanation:
A: To enable Application Continuity for Java, set the failovertype parameter to TRANSACTION. D: -clbgoal {SHORT | LONG}
Connection Load Balancing Goal. Use a value of SHORT for this parameter for run-time load balancing, or if using an integrated connection pool.
E: Enable Transaction Guard through the -commit_outcome parameter. When it is set to TRUE, the commit outcome for a transaction is accessible after the transaction's session fails due to a recoverable outage.

NEW QUESTION 21
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 three.)

  • A. They are automatically configured to use Enterprise Manager Express.
  • B. They have their pluggable databases (PDBs) opened in each container database (CDB) instance automatically after CDB creation.
  • C. They can be policy managed.
  • D. They can be administrator managed.
  • E. They have a unique service name created for each pluggable database (PDB) automatically registered as a cluster service resource.
  • F. They can have multiple pluggable databases (PDB) when the container database (CDB) is created.

Answer: CDF

NEW QUESTION 22
Which two statements are true regarding server-side connect-time load balancing for a RAC database when using SCAN listeners?

  • A. It is based on performance metrics provided by the database instances LREG processes.
  • B. LOCAL_LISTENER must be configured to point to the SCAN to enable server-side load balancing.
  • C. The service’s connection load balancing goal must be manually configured to enable server-side connect-time load balancing.
  • D. It’s enabled only when LOAD_BALANCE=YES is included in the TNS entry used by the client.
  • E. Server-side load balancing requires the REMOTE_LISTENER to point to the SCAN.

Answer: CE

Explanation:
C: With server-side load balancing, the SCAN listener directs a connection request to the best instance currently providing the service, based on the -clbgoal and -rlbgoal settings for the service.
E: The SCAN is an essential part of Database configuration. So, by default, the REMOTE_LISTENER parameter is set to the SCAN, assuming that the Database is created using standard Oracle tools. This enables the instances to register with the SCAN Listeners as remote listeners to provide information on what services are being provided by the instance, the current load, and a recommendation on how many incoming connections should be directed to the instance.
Note: Single Client Access Name (SCAN) is an Oracle Real Application Clusters (Oracle RAC) feature that provides a single name for clients to access Oracle Databases running in a cluster.

NEW QUESTION 23
Which three statements are true about Quality of Service Management (QoS)?

  • A. A server-pool can be managed by QoS even if it does have database instances running on any server in the pool.
  • B. It can manage database services only if they are defined as UNIFORM services.
  • C. It requires Oracle Grid Infrastructure for a Cluster to be installed and Clusterware to be running.
  • D. It supports multiple databases assigned to the same server pool.
  • E. Databases managed by QoS can be administrator managed or policy managed.

Answer: BCD

Explanation:
B: Database services should be created as UNIFORM services, meaning the service is offered by every available instance running in the specified server pool. If your application requires a SINGLETON service, then, to use Oracle Database QoS Management in management mode, the service must run in a server pool that has a maximum size of one. If you use a SINGLETON service in a server pool that has a maximum size greater than one, then Oracle Database QoS Management reports a configuration violation.
C: Initial QoS configuration includes:

NEW QUESTION 24
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.

Answer: AE

NEW QUESTION 25
......

Thanks for reading the newest 1Z0-068 exam dumps! We recommend you to try the PREMIUM prep-labs.com 1Z0-068 dumps in VCE and PDF here: https://www.prep-labs.com/dumps/1Z0-068/ (153 Q&As Dumps)