Aug-2024 Latest Real4dumps 1z1-078 Exam Dumps with PDF and Exam Engine Free Updated Today!
Following are some new 1z1-078 Real Exam Questions!
NEW QUESTION # 19
Which two statements are true regarding ASM when installing Oracle Grid Infrastructure 19c? (Choose two.)
- A. ASM disk groups used for voting files and OCR files require a quorum failqroup.
- B. The Installer permits the creation of a disk group for use by the voting disks and OCR file.
- C. If no ASM disk groups are specified during installation, then ASM instances are not started after the installation completes on any cluster node.
- D. The Installer permits the creation of a disk group to be used for the Recovery Area for the ASM instance.
- E. If ASM disk groups are configured for the Clusterware files, then ASM must be used for all databases on the cluster.
Answer: B,C
NEW QUESTION # 20
Which two statements are true about High Availability NFS (HANFS)? (Choose two.)
- A. NFS client requests are distributed by DNS in a round-robin fashion to the cluster nodes that export the NFS
- B. HANFS does not depend on NFS services provided by the underlying operating system.
- C. HANFS provides high availability in case of cluster node failure.
- D. HANFS provides high availability in case of an NFS client failure.
- E. HANFS' performance depends on the characteristics of the underlying ASM disks.
Answer: C,E
NEW QUESTION # 21
Which three statements are true regarding ASM on a four-node cluster? (Choose three.)
- A. A database instance on a node uses an ASM instance as an I/O server when requesting I/O to diskgroups.
- B. ASM Cluster File System (ACFS) can be deployed on any nodes.
- C. A database instance on a node can be a client of an ASM instance running on any node.
- D. A database instance on a node cannot be a client of an ASM instance running on other nodes.
- E. A database instance on a node can only be a client of an ASM instance running on the same node.
- F. An ASM instance and database instances can coexist on the same node.
Answer: A,C,F
NEW QUESTION # 22
Examine this command and output:
Examine this command:
Which statement must be true for the successful execution of the second command?
- A. The parent snapshot must be read/write.
- B. The parent snapshot must be read-only.
- C. The disk group compatibility attribute for advm must be set to 12. l or higher.
- D. The underlying advm volume must be configured with high redundancy.
Answer: B
NEW QUESTION # 23
Which three statements are true about Quality of Service Management (QoS)? (Choose three.)
- A. Databases managed by QoS can be administrator managed or policy managed.
- B. It can manage database services only if they are defined as UNIFORM services.
- C. It supports multiple databases assigned to the same server pool.
- D. It requires Oracle Grid Infrastructure for a Cluster to be installed and Clusterware to be running.
- E. A server pool can be managed by QoS even if it does have database instances running on any server in the pool.
Answer: A,C,D
NEW QUESTION # 24
Which three statements are true about fully qualified file names in ASM? (Choose three.)
- A. They can be created only if OMF is enabled.
- B. An alias may be created for an existing file by referring to the fully qualified file name.
- C. They are system Generated at the time of ASM file creation.
- D. They are the only valid form that can be used for single file creation of a control file.
- E. They can be used to reference existing ASM files.
Answer: B,C,E
NEW QUESTION # 25
Examine this query and output:
Performance analysis revealed severe SQ enqueue contention on the SEQ1 sequence.
The SEQ1 sequence is incremented from all instances equally and is frequently used.
Which two statements should you execute to reduce SQ enqueue contention? (Choose two.)
- A. alter sequence seal cache 10000;
- B. alter sequence seql noorder;
- C. alter sequence seql keep;
- D. alter sequence seql order;
- E. exec sys.dbms shared pool.keep('SEQ1','Q'>
Answer: A,B
NEW QUESTION # 26
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. In a RAC database, there is no LMDO process if only one instance is running.
- C. Global Enqueues and Instance Locks replace mutexes completely in RAC database instances.
- D. Global Enqueues may have converters and waiters in the same instance.
- E. Global Enqueues may have owners and waiters in the same instance.
- F. Global Enqueues and Instance Locks replace latches completely in RAC database instances.
Answer: B,E
NEW QUESTION # 27
Which two statements are true regarding the default service that is automatically created upon PDB creation in a RAC database environment? (Choose two.)
- A. It cannot be used to automate the opening of the PDB by the Clusterware.
- B. It is not automatically registered in the OCR.
- C. It is uniformly available on all instances for administrator-managed databases.
- D. It is automatically registered in the OCR.
- E. It is created and started on only one instance when using policy-managed database configuration.
Answer: D
NEW QUESTION # 28
Which three statements are true about diagnostic reporting for the OCR and OLR files? (Choose three.)
- A. The CLUVFY utility can check the integrity of the OCR but not the OLR.
- B. The OCRDUMP utility can dump specific keys from the OCR 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 OCRDUMP utility can dump specific keys from the OLR in an online fashion with the clusterware running on all nodes.
- E. The OCRCONFIG utility can be used to repair a corrupt OCR file in an online fashion with the clusterware running on all nodes.
Answer: B,C,D
NEW QUESTION # 29
Which three statements are true about services and load balancing for Oracle 19c clients connecting to Oracle 19c RAC database instances? (Choose three.)
- A. Services support the balancing of client connections across RAC database instances.
- B. In server-side load balancing, node listener redirects the client to another node listener for connection to an instance.
- C. Load balancing can be done by the client, the listener, or both, for any one connection request.
- D. Load balancing can be done by the client or the listener, but not both, for any one connection request.
- E. Client-side connect-time load balancing can balance connection requests across SCAN listeners.
Answer: A,B,C
NEW QUESTION # 30
Which two statements are true about resources defined by an administrator and registered with Oracle 19c Clusterware for high availability? (Choose two.)
- A. A policy-managed resource can be started manually using srvct1.
- B. The action script is automatically set when using a policy-managed resource.
- C. Resource dependencies are automatically set when using a policy-managed resource.
- D. An administrator-managed resource can be started manually using srvct1.
- E. An administrator-managed resource can be started manually using crsct1.
- F. A policy-managed resource can be started manually using crsct1.
Answer: E,F
NEW QUESTION # 31
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 delete node -n host04 command as root on host01, or on either host02 or host03.
- C. Run the rootcrs.pl -deconfig -force command as root on host01, or on either host02 or host03.
- D. Run the crsctl unpin css - host04 command as root on host01, or on either host02 or host03.
- E. Run the crsctl delete node -n host04 command as root on host04.
- F. Run the crsct1 unpin css - host04 command as root on host04.
Answer: A,B
NEW QUESTION # 32
Which three statements are true about the Global Resource Directory (GRD) in Oracle 19c RAC database and in Clustered ASM? (Choose three.)
- A. RAC databases have GRD cache resources distributed among all the database instances and stored in the shared pool of each instance.
- B. Only one GRD shadow resource may exist for an Enqueue Resource.
- C. All GRD Enqueue Resource master metadata is held in the shared pool of the same database instance.
- D. Clustered ASM has GRD resources distributed among all ASM instances.
- E. RAC databases have GRD cache resources distributed among all the database instances and stored in the large pool of each instance.
- F. All GRD Enqueue Resource master metadata is held in the large pool of the same database instance.
- G. Shadow GRD resources may exist in more than one database instance for a resource.
Answer: D,E,G
NEW QUESTION # 33
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 fails because the ASM instance has not been shut down first on HOST03.
- B. It succeeds and 19c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST02.
- C. It succeeds and 19c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST01.
- D. It fails because an ASM instance is not configured to run on HOST02.
- E. It succeeds and starts an ASM instance on HOST02 and shuts down the ASM instance on HOST03.
- F. It succeeds and starts an ASM instance on HOST02 but the ASM instance on HOST03 is not shut down until all connected clients disconnect.
Answer: B,D,F
NEW QUESTION # 34
......
Resources From:
- 2024 Latest Real4dumps 1z1-078 Exam Dumps (PDF & Exam Engine) Free Share: https://prep4sure.real4dumps.com/1z1-078-prep4sure-exam.html
Free Resources from Real4dumps, We Devoted to Helping You 100% Pass All Exams!
