1z1-078 Dumps To Pass Oracle Exam in 24 Hours - ITExamDownload
Buy Latest 1z1-078 Exam Q&A PDF - One Year Free Update
NEW QUESTION # 42
Which two statements are true about v$asm- views in a clustered environment? (Choose two.)
- A. gv$asm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in the cluster.
- B. They exist in both ASM and RDBMS instances, and display the same output.
- C. Their names can be seen in dice when connected to an ASM instance.
- D. Their names can be seen in v$fixed_table when connected to an instance of any type that is started.
- E. They exist in both ASM and RDBMS instances, but they can display different outputs depending on the instance type.
Answer: A,E
NEW QUESTION # 43
Which three statements are true concerning activation of a user-defined policy in Oracle 19c Clusterware? (Choose three.)
- A. When a policy is activated, resources can be automatically stopped to comply with the policy definition.
- B. When a policy is activated, nodes may be reassigned to server pools based on the policy definition.
- C. When a policy is first created, it is initially active.
- D. An administrator-defined policy may be activated using the srvctl utility.
- E. When a policy is first created, it is initially inactive.
- F. When a policy is activated, resources cannot be automatically started to comply with the policy definition.
Answer: A,D,E
NEW QUESTION # 44
Examine this sequence of commands:
The cluster consists of nodes HOST01, HOST02, HOST03 and HOST04, and the clusterware is running on all four nodes.
Which three statements are true about the result of the root user running these commands on HOST01? (Choose three.)
- A. The Oracle Clusterware stack is stopped on all nodes except host01.
- B. The Oracle Clusterware stack is started on all nodes.
- C. The Oracle Clusterware stack is prevented from being automatically started on host01.
- D. The Oracle Clusterware stack is prevented from being automatically started on all nodes.
- E. The Oracle Clusterware stack is stopped on all nodes.
- F. The Oracle Clusterware stack is started on all nodes except host01.
Answer: B,C,E
NEW QUESTION # 45
Which two statements are true about High Availability NFS (HANFS)? (Choose two.)
- A. HANFS does not depend on NFS services provided by the underlying operating system.
- B. HANFS provides high availability in case of an NFS client failure.
- C. NFS client requests are distributed by DNS in a round-robin fashion to the cluster nodes that export the NFS
- D. HANFS provides high availability in case of cluster node failure.
- E. HANFS' performance depends on the characteristics of the underlying ASM disks.
Answer: D,E
NEW QUESTION # 46
Which two statements are true about node listeners in a Grid Infrastructure Cluster using ASM? (Choose two.)
- A. They run from the Grid Infrastructure home by default.
- B. There can be only one node listener per node.
- C. They listen only for database instances on the same node.
- D. They listen only for the ASM instance on the same node.
- E. They listen on behalf of any ASM instance and all database instances on the same node.
Answer: A,E
NEW QUESTION # 47
Oracle Clusterware manages an administrator-managed database service defined with the MANUAL management policy.
Which two statements are true? (Choose two.)
- A. When manually started, the service will always start on one or more available instances rather than on their preferred instances.
- B. The service must be manually restarted with SRVCTL every time the instance hosting the service fails.
- C. The service must be manually restarted with SRVCTL after restarting the Clusterware stack on the node hosting the service.
- D. The service must be manually started with SRVCTL after a planned restart of the instance hosting the service.
- E. Clusterware will monitor the service while it is active.
Answer: D,E
NEW QUESTION # 48
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 noorder;
- B. exec sys.dbms shared pool.keep('SEQ1','Q'>
- C. alter sequence seql order;
- D. alter sequence seal cache 10000;
- E. alter sequence seql keep;
Answer: A,D
NEW QUESTION # 49
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 instance that offers a given service.
- C. When possible, clients with the same colocation_tag are routed to the same available instance even if a preferred instance is 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 # 50
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 (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.
- 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. 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.
- 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. 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.
Answer: A,C
NEW QUESTION # 51
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 # 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 cluster
- C. crsctl stop crs
- D. crsctl config crs
Answer: A,C
NEW QUESTION # 53
A cluster running 19c Grid Infrastructure supports both Oracle 11g to 19c RAC databases using ASM.
The COMPATIBLE.ASM, COMPATIBLE.RDBMS, and COMPATIBLE.ADVM parameters are currently set to 11.2 for all diskgroups..
You must support these capabilities in all diskgroups:
1. ACFS Replication
2. ACFS Encryption
To what minimum values must the compatible attributes be set?
- A. Set COMPATIBLE.ASM to 12.1, COMPATIBLE.RDBMS to 11.2, and COMPATIBLE.ADVM to 12.1.
- B. Set COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 12.1
- C. Set COMPATIBLE.ASM to 12.1, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 12.1.
- D. Set COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 11.2, and COMPATIBLE.ADVM to 11.2.
- E. Set COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 11.2.
Answer: C
NEW QUESTION # 54
Which two statements are true concerning diagnostic components and requirements of Oracle 19c Clusterware? (Choose two.)
- A. The clusterware log files are stored inside the Grid Infrastructure Management Repository database used by the cluster health monitor
- B. The oclumon utility may be used to get and set parameters for the cluster health monitor (CHM) repository.
- C. There is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
- D. There is one ologgerd service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
- E. The diagcolleccion.pl script must be run from the Grid home directory as the arid infrastructure owner.
Answer: B,E
NEW QUESTION # 55
Which two statements are true regarding ASM when installing Oracle Grid Infrastructure 19c? (Choose two.)
- A. The Installer permits the creation of a disk group to be used for the Recovery Area for the ASM instance.
- B. If no ASM disk groups are specified during installation, then ASM instances are not started after the installation completes on any cluster node.
- C. If ASM disk groups are configured for the Clusterware files, then ASM must be used for all databases on the cluster.
- D. The Installer permits the creation of a disk group for use by the voting disks and OCR file.
- E. ASM disk groups used for voting files and OCR files require a quorum failqroup.
Answer: B,D
NEW QUESTION # 56
Which three statements are true about accessing ASM files? (Choose three.)
- A. Database instances perform read I/O using an ASM instance as an I/O Server.
- B. 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
- C. Database instances can write metadata to ASM diskgroups.
- D. Database instances perform read I/O directly to ASM Disks.
- E. ASM instances can write metadata to ASM diskgroups.
Answer: C,D,E
NEW QUESTION # 57
Disk group DGRP1 has these attributes:
1. Normal redundancy
2. Two failure groups FG1 and FG2 with two disks each
3. Compatibility settings set to 19.0
The FG1 failure group goes offline due to hardware failure.
Which two statements are true? (Choose two.)
- A. The redundancy is lowered until the FGl failgroup is restored and the disk group resynchronized.
- B. New allocation units are not mirrored but changes to allocation units are tracked in the FG2 failure group.
- C. New allocation units are mirrored in the FG2 failure group until FGl is restored and the disk group resvnchronized-
- D. Transactions on database objects stored in tablespaces in the dgrpi disk group fail.
Answer: B,C
NEW QUESTION # 58
Which three statements are true regarding multitenant architecture for RAC databases? (Choose three.)
- A. PDBs must use shared Temporary
- B. It requires the cdb to use shared undo management.
- C. One undo tablespace for each pdb is required.
- D. You can open one, several, or all PD3s on one, several, or all cdb instances.
- E. One undo tablespace for each instance is required.
- F. PDBs can have local temporary
Answer: B,D,F
NEW QUESTION # 59
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 is automatically registered in the OCR.
- B. It is uniformly available on all instances for administrator-managed databases.
- C. It is not automatically registered in the OCR.
- D. It is created and started on only one instance when using policy-managed database configuration.
- E. It cannot be used to automate the opening of the PDB by the Clusterware.
Answer: A
NEW QUESTION # 60
Which two operating system users and groups must be created on each node before installing Oracle Grid Infrastructure 19c? (Choose two.)
- A. an O/S user to own the Grid Infrastructure installation
- B. an O/S group called dba
- C. an 0/S user to own the Oracle Database installation
- D. an O/S group to own the software inventory
- E. A group to own Automatic Storage Management (ASM) Filter Driver-provisioned storage
- F. an O/S user to own the Clusterware installation and a different O/S user own the Automatic Storage Management (ASM) installation
Answer: A,D
NEW QUESTION # 61
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. An application VIP is created on the default network by the appvipcfg utility.
- C. An application VIP can be created with the crsccl utility.
- D. Application VIPs do not fail over to surviving cluster nodes when the node hosting the VIP fails.
- E. If an application sends messages to be displayed and sets the display variable, then an application VIP is required.
Answer: B,C
NEW QUESTION # 62
......
Oracle 1z1-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 |
|
Download the Latest 1z1-078 Dump - 2024 1z1-078 Exam Question Bank: https://pass4sure.itexamdownload.com/1z1-078-valid-questions.html