100% Free 1z0-078 Exam Dumps Use Real Oracle Database Dumps With 80 Questions!
Pass Your 1z0-078 Exam Easily With 100% Exam Passing Guarantee [2024]
NEW QUESTION # 21
Examine this command:
Which two statements are true about this disk group, created using Grid Infrastructure 19c? (Choose two.)
- A. Any database instance with the COMPATIBLE parameter set to 12.2 or later can access it.
- B. It can contain ASM Dynamic Volume Manager (ADVM) volumes.
- C. The ASM compatible attributes can be changed to 12. l for this disk group.
- D. Each disk in each of the three fail groups is a mirror of the corresponding disk of the other two failure groups.
- E. Files created in this disk group always have two copies for each allocation unit: one primary and one secondary.
Answer: A,B
NEW QUESTION # 22
Examine the output of this command:
The ACFS disk group is a normal redundancy disk group with 5 GB of free space.
To increase the size of the ACFS file system, you execute this command as the root user:
$ /sbin/acfsutil size +200M /u01/app/grid/acfsmount
Which two statements are true regarding the outcome of this command? (Choose two.)
- A. It fails to resize the filesystem because it must be unmounted before resizing.
- B. It fails to resize voli because it must be executed as a user belonging to the sysasm group.
- C. It resizes voli.
- D. It succeeds but leaves the file system unmounted.
- E. It resizes the filesystem mounted on /u01/app/grid/acfsmount.
Answer: C,E
NEW QUESTION # 23
Which three statements are true about the services created when the DBCA is used to create a RAC database? (Choose three.)
- A. They can be administrator managed for a multitenant database.
- B. They can be policy managed for a multitenant database.
- C. A server pool must be created with srvct1 before creating a policy-managed RAC database that uses that server pool for a service.
- D. Policy-managed services specified for a database allow the creation of a new server pool using dbca.
- E. Singleton services are not permitted for multitenant databases.
Answer: A,B,D
NEW QUESTION # 24
Which two actions guarantee that time is synchronized properly on all nodes in a cluster after installing Oracle Grid Infrastructure 19c? (Choose two.)
- A. If network time protocol (NTP) time servers are unreachable on any cluster node, then Oracle Cluster Time Synchronization Service (CTSSD) will start automatically in active mode when the clusterware is started.
- B. Deactivate network time protocol (NTP) on all cluster nodes; Oracle Cluster Time Synchronization Service (CTSSD) will then start automatically in active mode when the clusterware is started.
- C. If network time protocol (NJP) is not configured properly on all cluster nodes, then Oracle Cluster Time Synchronization Service (CTSSD) will start automatically in active mode when the clusterware is started.
- D. Configure network time protocol (NTP) on all cluster nodes, and then start the Oracle Cluster Time Synchronization Service (CTSSD) in active mode on all cluster nodes.
- E. Configure network time protocol (NTP) on all cluster nodes; Oracle Cluster Time Synchronization Service (CTSSD) will then start automatically in observer mode when the clusterware is started.
Answer: C,E
NEW QUESTION # 25
Which three statements are true about undo management in a RAC environment? (Choose three.)
- A. You can dynamically assign a newly created undo tablespace to an instance.
- B. A mixture of automatic undo management and manual undo management is supported within a RAC database.
- C. An instance that performs instance recovery can write to the undo tablespace of a failed instance.
- D. In a policy-managed RAC database, an undo tablespace may automatically be created if OMF is enabled for the database.
- E. It is necessary to assign a specific undo tablespace to a specific instance.
Answer: A,C,D
NEW QUESTION # 26
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 crsctl delete node -n host04 command as root on host04.
- B. Run the crsct1 unpin css - host04 command as root on host04.
- C. Run the rootcrs.pl -deconfig -force command as root on host04.
- D. Run the crsctl delete node -n host04 command as root on host01, or on either host02 or host03.
- E. Run the rootcrs.pl -deconfig -force command as root on host01, or on either host02 or host03.
- F. Run the crsctl unpin css - host04 command as root on host01, or on either host02 or host03.
Answer: C,D
NEW QUESTION # 27
Which statement is true concerning the installation of an Oracle Grid Infrastructure 19c patchset and its status during the installation?
- A. When performing rolling patches, the vips for the node being patched are relocated to another node.
- B. When performing rolling patches, crsctl query crs softwareversion always displays the earliest version of the software running anywhere in the cluster.
- C. They can be applied in-place.
- D. Some Grid Infrastructure patchsets may not be intalled in a rolling fashion.
Answer: D
NEW QUESTION # 28
Which statement is true about Oracle Database 19c SGA Management?
- A. Oracle RAC Resource Management only allows assignment of the SGA during instance startup.
- B. Oracle RAC Resource Runtime Management allows for automatic and runtime adjustment of the SGA.
- C. Oracle RAC Resource Management requires the same SGA value for all the instances of a RAC database which is configured during database startup only.
- D. Oracle RAC Resource Management only allows assignment of the SGA during database startup.
Answer: B
NEW QUESTION # 29
Which three statements are true about ASM Cloud File System (ACFS) auditing? (Choose three.)
- A. acfsutil audit purge can be run by an audit manager.
- B. Audit information gathered by each cluster node can be consolidated into the unified ACFS audit trail.
- C. acfsutil audit init must be run by a system administrator.
- D. acfsutil audit archive must be used to archive audit files that are larger than 10 MB.
- E. acfsutil audit read marks audit files to indicate that it is safe to purge them.
Answer: A,B,C
NEW QUESTION # 30
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 oifcfg setif to stop the VIP on host01.
- B. Use srvctl modify nodeapps to change the VIP on host01.
- C. Use srvctl stop vip to stop the VIP on host01.
- D. Use srvctl start vip to start the VIP on host01.
- E. Use oifcfg setif to start the VIP on host01.
Answer: A,B,C
NEW QUESTION # 31
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. Normal Redundancy ASM Disk Groups used for Clusterware files will contain three voting files regardless of the number of
- D. High Redundancy ASM Disk Groups used for Clusterware files will contain two OCRs.
- E. The Grid Infrastructure Management Repository is only required when using ASM.
Answer: B,C
NEW QUESTION # 32
Which three events occur when a node fails in an Oracle Clusterware 19c Cluster? (Choose three.)
- A. The node is evicted from the cluster
- B. Cluster resources running on the failed node must be recovered when the node is restarted.
- C. Cluster Resources running on the failed node are relocated to one or more surviving hub nodes.
- D. Cluster Resources running on the failed node are suspended until the node is restarted.
- E. Sessions connected to the failed node could be relocated to one or more surviving nodes.
Answer: A,C,E
NEW QUESTION # 33
Which statement describes the purpose of colocation_tag for client routing with Oracle database 19c?
- A. When possible, clients with the same colocation_tag are routed to the same available instance when a preferred instance is not available.
- B. When possible, clients with the same colocation_tag are routed to the same available instance even if a preferred instance is available.
- C. When possible, clients with the same colocation_tag are routed to the same instance that offers a given service.
- D. When possible, clients with the same colocation_tag could be routed across a set of preferred instances based on a specific load balancing option.
Answer: C
NEW QUESTION # 34
Which three statements are true about diagnostic reporting for the OCR and OLR files? (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 OCRCONFIG utility can be used to repair a corrupt OCR file in an online fashion with the clusterware running on all nodes.
- C. The OCRCHECK utility can check the OLRWhich two statements are true about resources defined by an administrator and registered with Oracle 19c Clusterware for high availability? (Choose two.) in an online fashion with the clusterware running on all nodes.
- D. The CLUVFY utility can check the integrity of the OCR but not the OLR.
- E. The OCRDUMP utility can dump specific keys from the OLR in an online fashion with the clusterware running on all nodes.
Answer: A,C,E
NEW QUESTION # 35
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 disabling of volume does not destroy data in the file system.
- B. The ACFS mount registry with Oracle restart is automatically deleted.
- C. The volume can be enabled and the file system can be mounted back again to access the existing data.
- D. The ACFS file system will be permanently removed from the volume.
- E. The ACFS file system will be permanently removed from the volume only if the file system is empty.
Answer: A,C
NEW QUESTION # 36
Which three statements are true about ASM Cloud File System (ACFS) encryption? (Choose three.)
- A. An ACFS snapshot can be ACFS encrypted.
- B. A copy of an encrypted file is not encrypted unless it is created in an encrypted directory.
- C. acfsutil encr off can be run by an encryption manager who may not have system administrator privileges.
- D. acfsucil encr on can be used to specify the encryption key length for a directory or file.
- E. acfsutil encr inic is used to establish role separation between encryption managers and encryption auditors.
Answer: A,D,E
NEW QUESTION # 37
Which three statements are true concerning Automatic Database Diagnostic Monitor (ADDM) for RAC? (Choose three.)
- A. It can analyze performance over any given time period.
- B. It can only analyze performance on the instance running the ADDM job.
- C. It can diagnose skew in response time.
- D. It runs automatically in Instance ADDM mode after each AWR snapshot is created.
- E. It can analyze performance using data captured on all instances.
- F. It can diagnose latency problems in the Cluster Interconnect.
Answer: A,C,E
NEW QUESTION # 38
Which two operating system users and groups must be created on each node before installing Oracle Grid Infrastructure 19c? (Choose two.)
- A. an 0/S user to own the Oracle Database installation
- B. an O/S user to own the Grid Infrastructure installation
- C. A group to own Automatic Storage Management (ASM) Filter Driver-provisioned storage
- D. an O/S group called dba
- E. an O/S user to own the Clusterware installation and a different O/S user own the Automatic Storage Management (ASM) installation
- F. an O/S group to own the software inventory
Answer: B,F
NEW QUESTION # 39
Secure Cluster Communication protects the cluster interconnect from common security threats when used together with Single Network Support. Secure Cluster Communication includes message digest mechanisms, protection against fuzzing, and uses Transport Layer Security (TLS) to provide privacy and data integrity between the cluster members.
Which statement is true about securing cluster interconnect communication?
- A. Security for the cluster interconnect is invoked by auto-generated server certificates that will be assigned to each cluster node as part of a new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c.
- B. Security for the cluster interconnect is invoked automatically as part of a new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c and Database administrators or cluster administrators do not need to make any configuration changes for this feature.
- C. Database administrators or cluster administrators must provide an encryption key during new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c to secure the interconnect communication.
- D. Security for the cluster interconnect is invoked automatically as part of a new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c using an auto-generated encryption key that is stored locally on each node of the cluster in an Oracle Wallet and Database administrators or cluster administrators must provide a valid path for the Wallet file.
- E. Database administrators or cluster administrators must provide a valid server certificate and an Oracle Wallet for each node during new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c to secure the interconnect communication.
Answer: B
NEW QUESTION # 40
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 = IMMEDIATE, 1 = ABORT
- B. 3 = NORMAL, 2 = ABORT, 1 = IMMEDIATE
- C. 2 = NORMAL, 3 = TRANSACTIONAL, 1 = ABORT
- D. 3 = NORMAL, 2 = TRANSACTIONAL, 1 = ABORT
- E. 2 = NORMAL, 3 = IMMEDIATE, 1 = ABORT
Answer: A,B
NEW QUESTION # 41
......
Study resources for the Valid 1z0-078 Braindumps: https://pass4sure.practicedump.com/1z0-078-exam-questions.html