Latest 1z0-078 exam dumps with real Oracle questions and answers
1z0-078 Exam in First Attempt Guaranteed
Oracle 1z0-078 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
| Topic 9 |
|
| Topic 10 |
|
| Topic 11 |
|
NEW QUESTION # 39
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 stop crs
- B. crsctl disable crs
- C. crsctl config crs
- D. crsctl stop cluster
Answer: A,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 = ABORT, 1 = IMMEDIATE
- B. 2 = NORMAL, 3 = IMMEDIATE, 1 = ABORT
- C. 2 = NORMAL, 3 = TRANSACTIONAL, 1 = ABORT
- D. 3 = NORMAL, 2 = TRANSACTIONAL, 1 = ABORT
- E. 3 = NORMAL, 2 = IMMEDIATE, 1 = ABORT
Answer: A,E
NEW QUESTION # 41
Which three statements are true about the Global Resource Directory (GRD) in Oracle 19c RAC database and in Clustered ASM? (Choose three.)
- A. Clustered ASM has GRD resources distributed among all ASM instances.
- B. RAC databases have GRD cache resources distributed among all the database instances and stored in the shared pool of each instance.
- C. All GRD Enqueue Resource master metadata is held in the large pool of the same database instance.
- D. All GRD Enqueue Resource master metadata is held in the shared pool of the same database instance.
- E. Shadow GRD resources may exist in more than one database instance for a resource.
- F. RAC databases have GRD cache resources distributed among all the database instances and stored in the large pool of each instance.
- G. Only one GRD shadow resource may exist for an Enqueue Resource.
Answer: A,E,F
NEW QUESTION # 42
Identify three prerequisites for the successful installation of Oracle Grid Infrastructure 19c when using Full Featured Grid Naming Service (GNS). (Choose three.)
- A. DNS must be configured to delegate name resolution for the cluster subdomain to the cluster.
- B. Each cluster node must have at least two network interface cards.
- 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. A DHCP service on the public network for the cluster is required to allocate virtual IP addresses as required by the cluster.
- F. You must enable the Name Server Cache Daemon
Answer: A,E,F
NEW QUESTION # 43
Which two statements are true about resources defined by an administrator and registered with Oracle 19c Clusterware for high availability? (Choose two.)
- A. The action script is automatically set when using a policy-managed resource.
- B. A policy-managed resource can be started manually using crsct1.
- C. An administrator-managed resource can be started manually using crsct1.
- D. An administrator-managed resource can be started manually using srvct1.
- E. A policy-managed resource can be started manually using srvct1.
- F. Resource dependencies are automatically set when using a policy-managed resource.
Answer: B,C
NEW QUESTION # 44
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 even if a preferred instance is available.
- B. When possible, clients with the same colocation_tag are routed to the same instance that offers a given service.
- C. When possible, clients with the same colocation_tag are routed to the same available instance when a preferred instance is not available.
- 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: B
NEW QUESTION # 45
Examine this command:
Which two statements are required for this command to succeed? (Choose two.)
- A. User-defined subdirectories ORCL and USERS must already exist.
- B. The DB_CREATE_FILE_DEST parameter must be set to +DATA(newtemplate).
- C. newtemplate must be defined for the +DATA disk group.
- D. The +DATA disk group should not be part of Flex ASM.
- E. Existing data files in TBS1 must also use the same template.
Answer: A,C
NEW QUESTION # 46
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 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.
- C. The OCRDUMP utility can dump specific keys from the OLR in an online fashion with the clusterware running on all nodes.
- D. The OCRCONFIG utility can be used to repair a corrupt OCR file 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,C
NEW QUESTION # 47
Which two statements are true about Oracle Clustered ASM performance? (Choose two.)
- A. All ASM Disks belonging to a disk group should be of the same size for optimal performance.
- B. All ASM Disks belonging to a disk group should have the same hardware specifications and storage attributes for optimal performance.
- C. Data files, redo logs, and RMAN backup pieces must be stored in different ASM disk groups for optimal performance.
- D. To improve performance a database must have two disk groups; one for data and one for the fast recovery area.
- E. Hardware-based mirroring combined with ASM mirroring guarantees optimal performance.
Answer: A,B
NEW QUESTION # 48
Which two statements are true about v$asm- views in a clustered environment? (Choose two.)
- A. Their names can be seen in v$fixed_table when connected to an instance of any type that is started.
- B. They exist in both ASM and RDBMS instances, but they can display different outputs depending on the instance type.
- C. They exist in both ASM and RDBMS instances, and display the same output.
- D. gv$asm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in the cluster.
- E. Their names can be seen in dice when connected to an ASM instance.
Answer: B,D
NEW QUESTION # 49
Which two statements are true about the Global Enqueue Service, Instance Locks, and global enqueues in Oracle 19c RAC? (Choose two.)
- A. Global Enqueues may have owners and waiters in the same instance.
- B. Global Enqueues and Instance Locks replace latches completely in RAC database instances.
- C. Global Enqueues may have converters and waiters in the same instance.
- D. In a RAC One Node database, there is no LMD) process if only one instance is running.
- E. Global Enqueues and Instance Locks replace mutexes completely in RAC database instances.
- F. In a RAC database, there is no LMDO process if only one instance is running.
Answer: A,F
NEW QUESTION # 50
Which two statements are true about load balancing using a database service in a RAC environment? (Choose two.)
- A. Server-side load balancing connections are always distributed across instances based on the fastest response time for the service.
- B. Client-side connect time load balancing is done at the time of the initial connection attempt to the database service.
- C. In client-side load balancing, the SCAN listener uses the Load Balancing Advisory to direct a connection request to the least loaded instance hosting the service.
- D. Client-side connect time load balancing works only if it uses a tnsnames entry specifying load BALANCE=yes.
- E. Server-side connect time load balancing is done at the time of the initial connection attempt to the database service.
Answer: B,E
NEW QUESTION # 51
Which three statements are true about the Oracle Clusterware 19c Flex Cluster architecture? (Choose three.)
- A. Hub nodes require direct access to the voting disks.
- B. Each leaf node must be connected to storage shared across all cluster nodes.
- C. Each hub node must be connected to storage shared across all hub nodes.
- D. Leaf nodes require direct access to the voting disks.
- E. Hub nodes require direct access to the OCR file.
- F. Each leaf node must be connected to storage shared across all leaf nodes.
Answer: A,C,E
NEW QUESTION # 52
Which two tasks must be performed before launching the Oracle universal installer to install Oracle Database Software for RAC? (Choose two.)
- A. The Clusterware stack must be up on all cluster nodes where the Database software will be installed.
- B. Grid Infrastructure must be installed on all cluster nodes where the Database software will be installed.
- C. The Clusterware stack must be up on all cluster nodes.
- D. Grid Infrastructure must be installed on all cluster nodes.
- E. SSH user equivalence for the Oracle software owner must be configured on all cluster nodes.
- F. ssh user equivalence for the Oracle software owner must be configured on all cluster nodes where the Database software will be installed.
Answer: D,F
NEW QUESTION # 53
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 client connection requests for ERP across three Single Client Access Name (SCAN) listeners
- B. Load balancing of connection requests across all six database instances
- C. High availability for the CRM service
- D. Load balancing of client connection requests for CRM across four Single Client Access Name (SCAN) listeners
- E. Load balancing of connection requests for ERP across all database instances running on servers in the prod pool
- F. High availability for the ERP service
- G. Load balancing of connection requests for CRM across all database instances running on servers in the prod pool
Answer: C,D,F,G
NEW QUESTION # 54
Which three statements are true about the administration and use of policy sets in Oracle 19c Clusterware? (Choose three.)
- A. Servers in a server pool outside the control of the policy set are never affected by policy changes, when user-defined policy management is used.
- B. Clusterware administrators cannot directly modify the policy set when Quality of Service (QoS) Management is used.
- C. A server pool can have the same attributes defined for different policies in the policy set, when user-defined policy management is used.
- D. All server pools in a cluster are controlled by the policy set, when user-defined policy management is used.
- E. A server pool can have different attributes defined for different policies in the policy set, when user-defined policy management is used.
Answer: C,D,E
NEW QUESTION # 55
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. Any database instance with the COMPATIBLE parameter set to 12.2 or later can access it.
- D. It can contain ASM Dynamic Volume Manager (ADVM) volumes.
- E. Each disk in each of the three fail groups is a mirror of the corresponding disk of the other two failure groups.
Answer: C,D
NEW QUESTION # 56
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 crsct1 unpin css - host04 command as root on host04.
- B. Run the rootcrs.pl -deconfig -force command as root on host04.
- C. Run the rootcrs.pl -deconfig -force command as root on host01, or on either host02 or host03.
- D. Run the crsctl delete node -n host04 command as root on host04.
- E. Run the crsctl delete node -n host04 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: B,E
NEW QUESTION # 57
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. Cluster resources
- B. Pluggable Databases (PDBs)
- C. Administrator-defined resources
- D. Local resources
- E. Database transactions
Answer: A,C,D
NEW QUESTION # 58
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 order;
- B. exec sys.dbms shared pool.keep('SEQ1','Q'>
- C. alter sequence seql keep;
- D. alter sequence seql noorder;
- E. alter sequence seal cache 10000;
Answer: D,E
NEW QUESTION # 59
......
Exam Sure Pass Oracle Certification with 1z0-078 exam questions: https://gocertify.actual4labs.com/Oracle/1z0-078-actual-exam-dumps.html