[Apr 09, 2024] Latest 1z0-078 PDF Dumps & Real Tests Free Updated Today
1z0-078 Dumps With 100% Verified Q&As - Pass Guarantee or Full Refund
NEW QUESTION # 11
Examine this command:
Which two statements are true about this disk group, created using Grid Infrastructure 19c? (Choose two.)
- A. Files created in this disk group always have two copies for each allocation unit: one primary and one secondary.
- B. The ASM compatible attributes can be changed to 12. l for this disk group.
- C. Each disk in each of the three fail groups is a mirror of the corresponding disk of the other two failure groups.
- D. It can contain ASM Dynamic Volume Manager (ADVM) volumes.
- E. Any database instance with the COMPATIBLE parameter set to 12.2 or later can access it.
Answer: D,E
NEW QUESTION # 12
Which two statements are true about v$asm- views in a clustered environment? (Choose two.)
- A. They exist in both ASM and RDBMS instances, but they can display different outputs depending on the instance type.
- B. They exist in both ASM and RDBMS instances, and display the same output.
- C. gv$asm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in the cluster.
- D. Their names can be seen in v$fixed_table when connected to an instance of any type that is started.
- E. Their names can be seen in dice when connected to an ASM instance.
Answer: A,C
NEW QUESTION # 13
Which two statements are true concerning the installation of Oracle Grid Infrastructure 19c Cluster? (Choose two.)
- A. The Clusterware binaries may be installed without installing ASM binaries.
- B. Specifying the use of Grid Naming Service is optional.
- C. The Grid Infrastructure Management Repository is only required when using ASM.
- D. Normal Redundancy ASM Disk Groups used for Clusterware files will contain three voting files regardless of the number of
- E. High Redundancy ASM Disk Groups used for Clusterware files will contain two OCRs.
Answer: B,D
NEW QUESTION # 14
Which two statements are true concerning diagnostic components and requirements of Oracle 19c Clusterware? (Choose two.)
- A. The oclumon utility may be used to get and set parameters for the cluster health monitor (CHM) repository.
- B. There is one ologgerd service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
- C. The diagcolleccion.pl script must be run from the Grid home directory as the arid infrastructure owner.
- D. There is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
- E. The clusterware log files are stored inside the Grid Infrastructure Management Repository database used by the cluster health monitor
Answer: A,C
NEW QUESTION # 15
Which two steps must always be performed to delete node host04 from an Oracle 19c Clusterware cluster that does not use Grid Naming Service (GNS)? (Choose two.)
- A. Run the rootcrs.pl -deconfig -force command as root on host04.
- B. Run the crsctl unpin css - host04 command as root on host01, or on either host02 or host03.
- C. Run the crsctl delete node -n host04 command as root on host01, or on either host02 or host03.
- D. Run the rootcrs.pl -deconfig -force command as root on host01, or on either host02 or host03.
- E. Run the crsct1 unpin css - host04 command as root on host04.
- F. Run the crsctl delete node -n host04 command as root on host04.
Answer: A,C
NEW QUESTION # 16
Which two statements are true about server categorization in Oracle 19c Clusterware? (Choose two.)
- A. All nodes in a cluster belong to the same Oracle-supplied category.
- B. A server may be added to only one category using the crsctl utility.
- C. Different nodes in a cluster may belong to separate administrator-defined categories.
- D. All server attributes that may be used to determine the server category are discovered automatically by Oracle Clusterware.
- E. Server categories can only be used for nodes running an application server.
- F. All server attributes used for categorization are administrator modifiable.
Answer: B,C
NEW QUESTION # 17
Identify three prerequisites for the successful installation of Oracle Grid Infrastructure 19c when using Full Featured Grid Naming Service (GNS). (Choose three.)
- A. A DHCP service on the public network for the cluster is required to allocate virtual IP addresses as required by the cluster.
- B. DNS must be configured to delegate name resolution for the cluster subdomain to the cluster.
- C. A DHCP service on the private network for the cluster is required to allocate virtual IP addresses for HAIP.
- D. You must create a Grid Management Repository database.
- E. Each cluster node must have at least two network interface cards.
- F. You must enable the Name Server Cache Daemon
Answer: A,B,F
NEW QUESTION # 18
Which two statements are true about Transparent Application Continuity in Oracle RAC 19c? (Choose two.)
- A. Recovery of the user database session is done safely by enabling auto recover within the user database session.
- B. Transparent Application Continuity is enabled when failover type=All
- C. Recovery of the user database session is done safely and with no need for a DBA to have any knowledge of the application or make application code changes.
- D. Transparent Application Continuity is automatically enabled for a session when a database session reaches a safe place (such as a connection test or a known recoverable point) and the transactions are drained at the database.
- E. Transparent Application Continuity is enabled when failover type=auto.
Answer: C,E
NEW QUESTION # 19
Which two statements are true about Oracle Clustered ASM performance? (Choose two.)
- A. To improve performance a database must have two disk groups; one for data and one for the fast recovery area.
- B. All ASM Disks belonging to a disk group should be of the same size for optimal performance.
- C. Data files, redo logs, and RMAN backup pieces must be stored in different ASM disk groups for optimal performance.
- D. All ASM Disks belonging to a disk group should have the same hardware specifications and storage attributes for optimal performance.
- E. Hardware-based mirroring combined with ASM mirroring guarantees optimal performance.
Answer: B,D
NEW QUESTION # 20
Zero Downtime Patching uses Fleet Patching and Provisioning to patch Oracle Grid Infrastructure without bringing down Oracle RAC database instances.
Which three statements are true about Zero-Downtime Oracle Grid Infrastructure Patching? (Choose three.)
- A. Zero Downtime Patching requires out-of-place patching of Oracle Grid Infrastructure 19c with Oracle RAC or Oracle RAC One Node databases of 19c or later releases and only the binaries in the Oracle Grid Infrastructure user space are patched.
- B. Zero Downtime Patching requires in-place patching of Oracle Grid Infrastructure 19c with Oracle RAC or Oracle RAC One Node databases of 19c or later releases and only the binaries in the Oracle Grid Infrastructure user space are patched.
- C. Zero Downtime Patching can be fully automated by selecting the option to automatically run the root.sh script.
- D. When using Zero Downtime Patching, the root.sh script must be executed manually with -nodriver update option.
- E. When using Zero Downtime Patching, Oracle Grid Infrastructure OS system software, kernel modules and system commands including ACFS, AFD, OLFS, and OKA are not updated.
Answer: A,D,E
NEW QUESTION # 21
Examine these descriptions of ASM instance shutdown behavior:
1) The ASM instance shuts down immediately without an orderly dismount of disk groups.
2) Active SQL statements are allowed to complete before an orderly dismount of all disk groups occurs and then the ASM instance shuts down without waiting for connected sessions to disconnect. If any ASM clients are connected to the instance, then the shutdown returns an error.
3) Active SQL statements are allowed to complete before an orderly dismount of all of disk groups occurs and then the ASM instance shuts down after waiting for connected sessions to disconnect. If any ASM clients are connected to the instance, then the shutdown returns an error.
Which two lists are correct matches for these descriptions? (Choose two.)
- A. 3 = NORMAL, 2 = ABORT, 1 = IMMEDIATE
- B. 2 = NORMAL, 3 = TRANSACTIONAL, 1 = ABORT
- C. 2 = NORMAL, 3 = IMMEDIATE, 1 = ABORT
- D. 3 = NORMAL, 2 = IMMEDIATE, 1 = ABORT
- E. 3 = NORMAL, 2 = TRANSACTIONAL, 1 = ABORT
Answer: A,D
NEW QUESTION # 22
Which two statements are true about node listeners in a Grid Infrastructure Cluster using ASM? (Choose two.)
- A. They listen only for the ASM instance on the same node.
- B. They listen only for database instances on the same node.
- C. They listen on behalf of any ASM instance and all database instances on the same node.
- D. There can be only one node listener per node.
- E. They run from the Grid Infrastructure home by default.
Answer: C,E
NEW QUESTION # 23
You performed these steps to disable an ADVM volume containing an ACFS file system:
1. Dismount the file system.
2. Disable the volume with the ASMCMD voldisable command.
Which two statements are true regarding the actions performed? (Choose two.)
- A. The ACFS file system will be permanently removed from the volume only if the file system is empty.
- B. The volume can be enabled and the file system can be mounted back again to access the existing data.
- C. The disabling of volume does not destroy data in the file system.
- D. The ACFS mount registry with Oracle restart is automatically deleted.
- E. The ACFS file system will be permanently removed from the volume.
Answer: B,C
NEW QUESTION # 24
Your four-node cluster runs Oracle 19c Clusterware and supports a mix of RAC databases from Oracle 10g Release 2 to Oracle 19c.
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, 12c Release 1, and 19c clients connect to the database instances using the Single Client Access Name (SCAN).
You must change the public VIPs.
Which three actions must be performed to change the VIPs on host01, the first node in the cluster? (Choose three.)
- A. Use srvctl modify nodeapps to change the VIP on host01.
- B. Use srvctl stop vip to stop the VIP on host01.
- C. Use oifcfg setif to start the VIP on host01.
- D. Use srvctl start vip to start the VIP on host01.
- E. Use oifcfg setif to stop the VIP on host01.
Answer: A,B,E
NEW QUESTION # 25
Which two statements are true about resources defined by an administrator and registered with Oracle 19c Clusterware for high availability? (Choose two.)
- A. Resource dependencies are automatically set when using a policy-managed resource.
- B. A policy-managed resource can be started manually using srvct1.
- C. A policy-managed resource can be started manually using crsct1.
- D. The action script is automatically set when using a policy-managed resource.
- E. An administrator-managed resource can be started manually using srvct1.
- F. An administrator-managed resource can be started manually using crsct1.
Answer: C,F
NEW QUESTION # 26
A Java application using thick JDBC connections will soon be deployed, and you must configure a RAC database to support highly available connections.
Broken connections must be re-established as quickly as possible.
Which feature will support this requirement?
- A. Transparent Application Failover (TAF) using Fast Application Notification (FAN)
- B. Fast Connection Failover (FCF) with Transparent Application Failover (TAF)
- C. Fast Connection Failover (FCF)
- D. Transparent Application Failover (TAF)
Answer: C
NEW QUESTION # 27
Examine the output of the asmcmd and srvctl commands:
Then you execute this command:
$ srvctl relocate asm -currentnode host03 -targetnode host02
Which three statements are true regarding the execution of this command based on the output shown? (Choose three.)
- A. It succeeds and 19c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST01.
- B. It fails because an ASM instance is not configured to run on HOST02.
- C. It fails because the ASM instance has not been shut down first on HOST03.
- D. It succeeds and 19c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST02.
- E. It succeeds and starts an ASM instance on HOST02 but the ASM instance on HOST03 is not shut down until all connected clients disconnect.
- F. It succeeds and starts an ASM instance on HOST02 and shuts down the ASM instance on HOST03.
Answer: B,D,E
NEW QUESTION # 28
For which three entities can the "what-if" command evaluation be used to determine the impact of clusterware management operations in Oracle 19c Clusterware? (Choose three.)
- A. Local resources
- B. Cluster resources
- C. Database transactions
- D. Pluggable Databases (PDBs)
- E. Administrator-defined resources
Answer: A,B,E
NEW QUESTION # 29
Which three statements are true about ASM Cloud File System (ACFS) auditing? (Choose three.)
- A. acfsutil audit archive must be used to archive audit files that are larger than 10 MB.
- B. acfsutil audit read marks audit files to indicate that it is safe to purge them.
- C. acfsutil audit purge can be run by an audit manager.
- D. acfsutil audit init must be run by a system administrator.
- E. Audit information gathered by each cluster node can be consolidated into the unified ACFS audit trail.
Answer: C,D,E
NEW QUESTION # 30
Which three events occur when a node fails in an Oracle Clusterware 19c Cluster? (Choose three.)
- A. Sessions connected to the failed node could be relocated to one or more surviving nodes.
- B. The node is evicted from the cluster
- C. Cluster Resources running on the failed node are suspended until the node is restarted.
- D. Cluster Resources running on the failed node are relocated to one or more surviving hub nodes.
- E. Cluster resources running on the failed node must be recovered when the node is restarted.
Answer: A,B,D
NEW QUESTION # 31
Examine this command:
SQL> CREATE PLUGGABLE DATABASE pdb3 FROM pdb1;
Which three conditions must be true for successful execution of this command on a RAC database? (Choose three.)
- A. The source PD3 must be in read only mode on all CD3 instances if the CDB is in No Archive mode.
- B. All running CDB instances must be open in restricted mode.
- C. It can be executed only by a common user with the create pluggable database system privilege connected to the root container.
- D. Oracle Managed Files must be enabled or PD3 file name convert must be set.
- E. The source PD3 must be closed on the CDS instance from where the command is executed.
- F. The source pdb must use a global temporary
Answer: C,D,E
NEW QUESTION # 32
Which two statements are true about the Global Enqueue Service, Instance Locks, and global enqueues in Oracle 19c RAC? (Choose two.)
- A. In a RAC One Node database, there is no LMD) process if only one instance is running.
- B. Global Enqueues may have owners and waiters in the same instance.
- C. In a RAC database, there is no LMDO process if only one instance is running.
- D. Global Enqueues and Instance Locks replace latches completely in RAC database instances.
- E. Global Enqueues may have converters and waiters in the same instance.
- F. Global Enqueues and Instance Locks replace mutexes completely in RAC database instances.
Answer: B,C
NEW QUESTION # 33
......
Oracle 1z0-078 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
2024 Valid 1z0-078 test answers & Oracle Exam PDF: https://www.actual4labs.com/Oracle/1z0-078-actual-exam-dumps.html
Pass Oracle 1z0-078 Exam With Practice Test Questions Dumps Bundle: https://drive.google.com/open?id=1arBNjzs6WJgvM_1GDsTobLygljEaqvsu