Authentic Oracle 1z0-078 Exam Dumps PDF - May-2024 Updated
1z0-078 Dumps Special Discount for limited time Try FOR FREE
NEW QUESTION # 32
Which two statements are true concerning the installation of Oracle Grid Infrastructure 19c Cluster? (Choose two.)
- A. Normal Redundancy ASM Disk Groups used for Clusterware files will contain three voting files regardless of the number of
- B. The Clusterware binaries may be installed without installing ASM binaries.
- C. Specifying the use of Grid Naming Service is optional.
- D. The Grid Infrastructure Management Repository is only required when using ASM.
- E. High Redundancy ASM Disk Groups used for Clusterware files will contain two OCRs.
Answer: A,C
NEW QUESTION # 33
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 can be fully automated by selecting the option to automatically run the root.sh script.
- 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. 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.
- D. When using Zero Downtime Patching, the root.sh script must be executed manually with -nodriver update option.
- E. 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.
Answer: C,D,E
NEW QUESTION # 34
You support a RAC database with these characteristics:
1. There are six instances.
2. Server Pool prod has a maximum of four servers.
3. CRM is a policy managed, uniform service using Server Pool prod.
4. ERP is a policy managed, singleton service using Server Pool prod.
5. Grid infrastructure is installed and running in its default configuration.
Which four benefits are provided by this configuration in Oracle 19c? (Choose four.)
- A. Load balancing of connection requests for ERP across all database instances running on servers in the prod pool
- B. Load balancing of client connection requests for ERP across three Single Client Access Name (SCAN) listeners
- C. Load balancing of connection requests for CRM across all database instances running on servers in the prod pool
- D. High availability for the ERP service
- E. Load balancing of connection requests across all six database instances
- F. Load balancing of client connection requests for CRM across four Single Client Access Name (SCAN) listeners
- G. High availability for the CRM service
Answer: C,D,F,G
NEW QUESTION # 35
Which three statements are true concerning Automatic Database Diagnostic Monitor (ADDM) for RAC? (Choose three.)
- A. It runs automatically in Instance ADDM mode after each AWR snapshot is created.
- B. It can analyze performance using data captured on all instances.
- C. It can diagnose skew in response time.
- D. It can only analyze performance on the instance running the ADDM job.
- E. It can analyze performance over any given time period.
- F. It can diagnose latency problems in the Cluster Interconnect.
Answer: B,C,E
NEW QUESTION # 36
Which two statements are true regarding ASM Dynamic Volume Manager (ADVM)? (Choose two.)
- A. Only one ADVM volume can be created in an ASM disk group.
- B. An ADVM volume is individually named and can contain only one file system.
- C. To create an ADVM volume, disk group attributes COMPATIBLE.ASM and COMPATIBLE.ADVM must be minimally set to 12.1.<.span>.
- D. ADVM extends ASM by providing a device driver interface to storage backed by an ASM disk group.
- E. File systems contained in ADVM volumes may only contain database files.
Answer: B,D
NEW QUESTION # 37
Which two statements are true concerning Oracle 19c Clusterware-managed application VIPs? (Choose two.)
- A. An application VIP is created on the interconnect network by the crsccl utility.
- B. Application VIPs do not fail over to surviving cluster nodes when the node hosting the VIP fails.
- C. If an application sends messages to be displayed and sets the display variable, then an application VIP is required.
- D. An application VIP can be created with the crsccl utility.
- E. An application VIP is created on the default network by the appvipcfg utility.
Answer: D,E
NEW QUESTION # 38
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 created and started on only one instance when using policy-managed database configuration.
- C. It is not automatically registered in the OCR.
- D. It is uniformly available on all instances for administrator-managed databases.
- E. It is automatically registered in the OCR.
Answer: E
NEW QUESTION # 39
You administer a six-instance, policy-managed, multitenant RAC database CDB1 with three PDBs: PDB_1,PDB_2, and PDB_3.
Server pool prod_pool has a cardinality of three and all six hosts of the cluster are up.
Examine these commands executed on HOST01:
Which two statements are true regarding the AR service? (Choose two.)
- A. AR runs as a singleton service in the server pool prod pool and the AR service is available in each of the CDBl instances.
- B. AR is available on any one available CDBl instance in prod pool at any one time.
- C. AR can fail over to any one of the available CD31 instances.
- D. AR is available only on the CDBl instance on host01.
- E. AR can fail over to any other available CDBl instance in prod pool.
Answer: B,E
NEW QUESTION # 40
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 seql keep;
- B. alter sequence seql order;
- C. alter sequence seql noorder;
- D. exec sys.dbms shared pool.keep('SEQ1','Q'>
- E. alter sequence seal cache 10000;
Answer: C,E
NEW QUESTION # 41
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 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.
- C. 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.
- 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 and Database administrators or cluster administrators do not need to make any configuration changes for this feature.
- E. 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.
Answer: D
NEW QUESTION # 42
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 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 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.
- E. The CLUVFY utility can check the integrity of the OCR but not the OLR.
Answer: A,B,D
NEW QUESTION # 43
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 or the listener, but not both, for any one connection request.
- D. Client-side connect-time load balancing can balance connection requests across SCAN listeners.
- E. Load balancing can be done by the client, the listener, or both, for any one connection request.
Answer: A,B,E
NEW QUESTION # 44
Which two statements are true about initialization parameters for Clustered ASM instances? (Choose two.)
- A. A change to ASM_DISKSTRING requires a restart of all ASM instances for the change to take effect.
- B. The ASM_DISKGOUPS parameter is optional.
- C. The default value of INSTANCE_TYPE is ASM.
- D. The maximum value of ASM_POWER_LIMIT is 1024.
- E. ASM_POWER_LIMIT controls the number of RDBMS instances that can access a disk group while it is being rebalanced.
Answer: B,C
NEW QUESTION # 45
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 HOST02.
- B. It succeeds and 19c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST01.
- C. It fails because the ASM instance has not been shut down first on HOST03.
- D. It succeeds and starts an ASM instance on HOST02 and shuts down the ASM instance on HOST03.
- E. It fails because an ASM instance is not configured to run on HOST02.
- 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: A,E,F
NEW QUESTION # 46
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 only allows assignment of the SGA during database startup.
- D. Oracle RAC Resource Management requires the same SGA value for all the instances of a RAC database which is configured during database startup only.
Answer: B
NEW QUESTION # 47
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.
- B. The volume can be enabled and the file system can be mounted back again to access the existing data.
- C. The ACFS file system will be permanently removed from the volume only if the file system is empty.
- D. The disabling of volume does not destroy data in the file system.
- E. The ACFS mount registry with Oracle restart is automatically deleted.
Answer: B,D
NEW QUESTION # 48
Which three statements are true about Quality of Service Management (QoS)? (Choose three.)
- A. It can manage database services only if they are defined as UNIFORM services.
- B. Databases managed by QoS can be administrator managed or policy managed.
- 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. A server pool can be managed by QoS even if it does have database instances running on any server in the pool.
Answer: B,C,D
NEW QUESTION # 49
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. Transparent Application Failover (TAF)
- C. Fast Connection Failover (FCF)
- D. Fast Connection Failover (FCF) with Transparent Application Failover (TAF)
Answer: C
NEW QUESTION # 50
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. Policy-managed services specified for a database allow the creation of a new server pool using dbca.
- 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. They can be policy managed for a multitenant database.
- E. Singleton services are not permitted for multitenant databases.
Answer: A,B,D
NEW QUESTION # 51
Which two statements are true about v$asm- views in a clustered environment? (Choose two.)
- A. Their names can be seen in dice when connected to an ASM instance.
- 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. They exist in both ASM and RDBMS instances, but they can display different outputs depending on the instance type.
- E. Their names can be seen in v$fixed_table when connected to an instance of any type that is started.
Answer: C,D
NEW QUESTION # 52
......
1z0-078 Dumps for success in Actual Exam: https://pass4sure.verifieddumps.com/1z0-078-valid-exam-braindumps.html
