[Full-Version] 2024 New Preparation Guide of Oracle 1z0-078 Exam
1z0-078 Practice Exam - 79 Unique Questions
NEW QUESTION # 32
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 # 33
Identify three prerequisites for the successful installation of Oracle Grid Infrastructure 19c when using Full Featured Grid Naming Service (GNS). (Choose three.)
- A. Each cluster node must have at least two network interface cards.
- B. A DHCP service on the public network for the cluster is required to allocate virtual IP addresses as required by the cluster.
- C. DNS must be configured to delegate name resolution for the cluster subdomain to the cluster.
- D. You must create a Grid Management Repository database.
- E. You must enable the Name Server Cache Daemon
- F. A DHCP service on the private network for the cluster is required to allocate virtual IP addresses for HAIP.
Answer: B,C,E
NEW QUESTION # 34
Which two statements are true about server categorization in Oracle 19c Clusterware? (Choose two.)
- A. Server categories can only be used for nodes running an application server.
- B. All nodes in a cluster belong to the same Oracle-supplied category.
- C. All server attributes used for categorization are administrator modifiable.
- D. All server attributes that may be used to determine the server category are discovered automatically by Oracle Clusterware.
- E. A server may be added to only one category using the crsctl utility.
- F. Different nodes in a cluster may belong to separate administrator-defined categories.
Answer: E,F
NEW QUESTION # 35
Which task must be performed before running the OPatch utility to patch Oracle Grid Infrastructure 19c?
- A. Stage the patch on all cluster nodes.
- B. Update the path environment variable on each cluster node to point to the 50RACLE HOME/OPacch directory
- C. Stage the patch on the cluster node where the OPacch utility will be executed.
- D. Update the path environment variable on the node where you will run the OPatch utility to point to the SORacle HOME/OPacch directory.
Answer: A
NEW QUESTION # 36
Which three statements are true about ASM Cloud File System (ACFS) encryption? (Choose three.)
- A. acfsucil encr on can be used to specify the encryption key length for a directory or file.
- 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. An ACFS snapshot can be ACFS encrypted.
- E. acfsutil encr inic is used to establish role separation between encryption managers and encryption auditors.
Answer: A,D,E
NEW QUESTION # 37
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. 2 = NORMAL, 3 = IMMEDIATE, 1 = ABORT
- C. 3 = NORMAL, 2 = ABORT, 1 = IMMEDIATE
- D. 2 = NORMAL, 3 = TRANSACTIONAL, 1 = ABORT
- E. 3 = NORMAL, 2 = TRANSACTIONAL, 1 = ABORT
Answer: A,C
NEW QUESTION # 38
Which three statements are true regarding ASM on a four-node cluster? (Choose three.)
- A. A database instance on a node can only be a client of an ASM instance running on the same node.
- B. ASM Cluster File System (ACFS) can be deployed on any nodes.
- C. A database instance on a node uses an ASM instance as an I/O server when requesting I/O to diskgroups.
- D. A database instance on a node can be a client of an ASM instance running on any node.
- E. A database instance on a node cannot be a client of an ASM instance running on other nodes.
- F. An ASM instance and database instances can coexist on the same node.
Answer: C,D,F
NEW QUESTION # 39
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 # 40
Which three statements are true about undo management in a RAC environment? (Choose three.)
- A. A mixture of automatic undo management and manual undo management is supported within a RAC database.
- B. In a policy-managed RAC database, an undo tablespace may automatically be created if OMF is enabled for the database.
- C. You can dynamically assign a newly created undo tablespace to an instance.
- D. An instance that performs instance recovery can write to the undo tablespace of a failed instance.
- E. It is necessary to assign a specific undo tablespace to a specific instance.
Answer: B,C,D
NEW QUESTION # 41
Which three statements are true about accessing ASM files? (Choose three.)
- A. ASM instances can write metadata to ASM diskgroups.
- B. Database instances perform read I/O directly to ASM Disks.
- C. Database instances can write metadata to ASM diskgroups.
- D. If a database instance writes to an ASM-based datafile whose redundancy attribute is set to mirror, then the ASM instance writes the mirror copy
- E. Database instances perform read I/O using an ASM instance as an I/O Server.
Answer: A,B,C
NEW QUESTION # 42
Which four statements are true concerning the upgrading of Oracle Grid Infrastructure 19c? (Choose four.)
- A. The cluster verification utility cluvfy.sh can verify that the cluster is ready for an upgrade.
- B. The oracle SID environment variable must be set to the SID of the ASM instance in the installation owner's environment.
- C. The upgrade must be done in-place.
- D. Upgrade validation may be done using the Oracle Universal Installer which in turn invokes the built-in cluster verification utility.
- E. The cluster verification utility cluvfy.sh can generate fixup scripts to run on all nodes of the cluster.
- F. The oracle home environment variable must be set to the Grid Infrastructure home directory in the installation owner's environment.
- G. The upgrade must be done out-of-place.
Answer: A,D,E,F
NEW QUESTION # 43
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. Database transactions
- B. Pluggable Databases (PDBs)
- C. Administrator-defined resources
- D. Local resources
- E. Cluster resources
Answer: C,D,E
NEW QUESTION # 44
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 # 45
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 and with no need for a DBA to have any knowledge of the application or make application code changes.
- B. Transparent Application Continuity is enabled when failover type=All
- C. 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.
- D. Transparent Application Continuity is enabled when failover type=auto.
- E. Recovery of the user database session is done safely by enabling auto recover within the user database session.
Answer: A,D
NEW QUESTION # 46
Which three statements are true about the Global Resource Directory (GRD) in Oracle 19c RAC database and in Clustered ASM? (Choose three.)
- A. All GRD Enqueue Resource master metadata is held in the large pool of the same database instance.
- B. Shadow GRD resources may exist in more than one database instance for a resource.
- C. RAC databases have GRD cache resources distributed among all the database instances and stored in the large pool of each instance.
- D. Only one GRD shadow resource may exist for an Enqueue Resource.
- E. All GRD Enqueue Resource master metadata is held in the shared pool of the same database instance.
- F. Clustered ASM has GRD resources distributed among all ASM instances.
- G. RAC databases have GRD cache resources distributed among all the database instances and stored in the shared pool of each instance.
Answer: B,C,F
NEW QUESTION # 47
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 # 48
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 # 49
Which two components must always be defined or specified by an administrator to make an application highly available using Oracle 92c Clusterware? (Choose two.)
- A. a script agent
- B. an application resource
- C. a resource dependency definition
- D. A Server Pool
- E. an application VIP
Answer: A,B
NEW QUESTION # 50
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 # 51
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 # 52
Which two commands will stop the Oracle High Availability Services (OHAS) and prevent it from starting automatically at system boot on the local node? (Choose two.)
- A. crsctl disable crs
- B. crsctl stop crs
- C. crsctl config crs
- D. crsctl stop cluster
Answer: A,B
NEW QUESTION # 53
......
Oracle 1z0-078 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
Latest Questions 1z0-078 Guide to Prepare Free Practice Tests: https://www.examcost.com/1z0-078-practice-exam.html
Reliable 1z0-078 Dumps Questions Available as Web-Based Practice Test Engine: https://drive.google.com/open?id=1uD0siekhrFjfX6MyOeazmjBsQCxM5XH6
