Get Prepared for Your 1z0-078 Exam With Actual 79 Questions
Valid 1z0-078 Test Answers Full-length Practice Certification Exams
Oracle 1z0-078 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
NEW QUESTION # 27
Which two statements are true about node listeners in a Grid Infrastructure Cluster using ASM? (Choose two.)
- A. They listen only for database instances on the same node.
- B. They listen only for the ASM instance on the same node.
- C. They listen on behalf of any ASM instance and all database instances on the same node.
- D. There can be only one node listener per node.
- E. They run from the Grid Infrastructure home by default.
Answer: C,E
NEW QUESTION # 28
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. 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.
- C. 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.
- D. 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.
- 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,D
NEW QUESTION # 29
Which four statements are true concerning the upgrading of Oracle Grid Infrastructure 19c? (Choose four.)
- A. The upgrade must be done in-place.
- B. The cluster verification utility cluvfy.sh can verify that the cluster is ready for an upgrade.
- C. Upgrade validation may be done using the Oracle Universal Installer which in turn invokes the built-in cluster verification utility.
- D. The cluster verification utility cluvfy.sh can generate fixup scripts to run on all nodes of the cluster.
- E. The upgrade must be done out-of-place.
- F. The oracle SID environment variable must be set to the SID of the ASM instance in the installation owner's environment.
- G. The oracle home environment variable must be set to the Grid Infrastructure home directory in the installation owner's environment.
Answer: B,C,D,G
NEW QUESTION # 30
Which two statements are true concerning diagnostic components and requirements of Oracle 19c Clusterware? (Choose two.)
- A. The diagcolleccion.pl script must be run from the Grid home directory as the arid infrastructure owner.
- B. There is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
- C. The oclumon utility may be used to get and set parameters for the cluster health monitor (CHM) repository.
- D. There is one ologgerd service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
- E. The clusterware log files are stored inside the Grid Infrastructure Management Repository database used by the cluster health monitor
Answer: A,C
NEW QUESTION # 31
Which three statements are true about ASM Cloud File System (ACFS) encryption? (Choose three.)
- A. acfsutil encr inic is used to establish role separation between encryption managers and encryption auditors.
- B. acfsucil encr on can be used to specify the encryption key length for a directory or file.
- C. A copy of an encrypted file is not encrypted unless it is created in an encrypted directory.
- D. An ACFS snapshot can be ACFS encrypted.
- E. acfsutil encr off can be run by an encryption manager who may not have system administrator privileges.
Answer: A,B,D
NEW QUESTION # 32
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 11.2, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 11.2.
- B. Set COMPATIBLE.ASM to 12.1, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 12.1.
- C. Set COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 12.1
- D. Set COMPATIBLE.ASM to 12.1, COMPATIBLE.RDBMS to 11.2, and COMPATIBLE.ADVM to 12.1.
- E. Set COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 11.2, and COMPATIBLE.ADVM to 11.2.
Answer: B
NEW QUESTION # 33
Which three statements are true about ASM Cloud File System (ACFS) auditing? (Choose three.)
- A. acfsutil audit init must be run by a system administrator.
- B. acfsutil audit purge can be run by an audit manager.
- C. acfsutil audit read marks audit files to indicate that it is safe to purge them.
- D. acfsutil audit archive must be used to archive audit files that are larger than 10 MB.
- E. Audit information gathered by each cluster node can be consolidated into the unified ACFS audit trail.
Answer: A,B,E
NEW QUESTION # 34
Which three statements are true about fully qualified file names in ASM? (Choose three.)
- A. An alias may be created for an existing file by referring to the fully qualified file name.
- B. They can be created only if OMF is enabled.
- 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: C,E
NEW QUESTION # 35
Which two statements are true about load balancing using a database service in a RAC environment? (Choose two.)
- A. Server-side connect time load balancing is done at the time of the initial connection attempt to the database service.
- B. Client-side connect time load balancing is done at the time of the initial connection attempt to the database service.
- C. Server-side load balancing connections are always distributed across instances based on the fastest response time for the service.
- D. 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.
- E. Client-side connect time load balancing works only if it uses a tnsnames entry specifying load BALANCE=yes.
Answer: A,B
NEW QUESTION # 36
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 uniformly available on all instances for administrator-managed databases.
- C. It is created and started on only one instance when using policy-managed database configuration.
- D. It is automatically registered in the OCR.
- E. It is not automatically registered in the OCR.
Answer: D
NEW QUESTION # 37
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 OLR in an online fashion with the clusterware running on all nodes.
- C. The CLUVFY utility can check the integrity of the OCR but not the OLR.
- 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 utilty can be used to repair a corrupt OCR file in an online fashion with the clusterware running on all nodes.
Answer: A,B,D
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 be a client of an ASM instance running on any node.
- B. ASM Cluster File System (ACFS) can be deployed on any nodes.
- C. A database instance on a node can only be a client of an ASM instance running on the same node.
- D. An ASM instance and database instances can coexist on the same node.
- E. A database instance on a node uses an ASM instance as an I/O server when requesting I/O to diskgroups.
- F. A database instance on a node cannot be a client of an ASM instance running on other nodes.
Answer: A,D,E
NEW QUESTION # 39
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 for use by the voting disks and OCR file.
- 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. The Installer permits the creation of a disk group to be used for the Recovery Area for the ASM instance.
- D. If ASM disk groups are configured for the Clusterware files, then ASM must be used for all databases on the cluster.
- E. ASM disk groups used for voting files and OCR files require a quorum failqroup.
Answer: A,B
NEW QUESTION # 40
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. A Server Pool
- C. an application VIP
- D. an application resource
- E. a resource dependency definition
Answer: A,D
NEW QUESTION # 41
You want to create a tablespace, SALES, with these requirements:
1. Its data file has an alias name sales.dbf.
2. Its data file is stored in the directory CURRENT_YR in the disk group DATA.
Examine this command:
SQL> CREATE TABLESPACE sales;
Which two tasks must you perform to meet these requirements? (Choose two.)
- A. Add the DATAFILE '+DATA/CURRENT YR/sales.dbf clause to the command.
- B. lAdd the DATAFILE '/CURRENT YR/sales.dbf clause to the command.
- C. Create the current yr directory in the +data disk group.
- D. Create the current yr directory in the root directory (+).
- E. Add the autoextend on clause to the command.
Answer: A,C
NEW QUESTION # 42
Which three statements are true about accessing ASM files? (Choose three.)
- A. Database instances perform read I/O directly to ASM Disks.
- B. Database instances perform read I/O using an ASM instance as an I/O Server.
- C. Database instances can write metadata to ASM diskgroups.
- D. ASM instances can write metadata to ASM diskgroups.
- E. 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
Answer: A,C,D
NEW QUESTION # 43
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 crsctl delete node -n host04 command as root on host04.
- B. Run the crsct1 unpin css - host04 command as root on host04.
- C. Run the rootcrs.pl -deconfig -force command as root on host04.
- D. Run the crsctl unpin css - host04 command as root on host01, or on either host02 or host03.
- E. Run the rootcrs.pl -deconfig -force command as root on host01, or on either host02 or host03.
- F. Run the crsctl delete node -n host04 command as root on host01, or on either host02 or host03.
Answer: C,F
NEW QUESTION # 44
Which two benefits are obtained by using Affinity to reduce global resource contention? (Choose two.)
- A. Oracle RAC affinity for partitioned tables routes all database requests for a partition tables to a single Oracle RAC instance leading to higher Oracle RAC performance and scalability because of improved cache locality and reduced internode synchronization and block pings of the partition tables.
- B. To enhance the performance of distributed transactions with applications server that provides XA affinity, you can direct all branches of a distributed transaction to a single instance in the cluster to improve cache locality and reduce internode synchronization and block pings.
- C. Oracle RAC affinity for partitioned tables routes database requests to all available Oracle RAC instances evenly to create a global affinity in such a way that each instance always gets an even number of requests leading to higher Oracle RAC performance by using a higher levels of available global cache to reduce global resource contention.
- D. To enhance the performance of distributed transactions with applications server that provides XA affinity, you can automatically spawn new dedicated database RAC instances to isolate distributed transaction.
- E. Oracle RAC affinity for partitioned tables routes database requests to Oracle RAC instances in such a way that each instance always gets requests for a disjoint subset of rows in the database, this affinity leads to higher Oracle RAC performance and scalability because of improved cache locality and reduced internode synchronization and block pings.
Answer: A,B
NEW QUESTION # 45
Examine this command:
Which two statements are true about this disk group, created using Grid Infrastructure 19c? (Choose two.)
- A. Each disk in each of the three fail groups is a mirror of the corresponding disk of the other two failure groups.
- B. The ASM compatible attributes can be changed to 12. l for this disk group.
- C. It can contain ASM Dynamic Volume Manager (ADVM) volumes.
- D. Files created in this disk group always have two copies for each allocation unit: one primary and one secondary.
- E. Any database instance with the COMPATIBLE parameter set to 12.2 or later can access it.
Answer: C,E
NEW QUESTION # 46
Which three statements are true about the Oracle Clusterware 19c Flex Cluster architecture? (Choose three.)
- A. Each leaf node must be connected to storage shared across all cluster nodes.
- B. Each hub node must be connected to storage shared across all hub nodes.
- C. Hub nodes require direct access to the OCR file.
- D. Leaf nodes require direct access to the voting disks.
- E. Each leaf node must be connected to storage shared across all leaf nodes.
- F. Hub nodes require direct access to the voting disks.
Answer: B,C,F
NEW QUESTION # 47
......
Accurate & Verified 2024 New 1z0-078 Answers As Experienced in the Actual Test!: https://www.actualvce.com/Oracle/1z0-078-valid-vce-dumps.html
1z0-078 Certification Sample Questions certification Exam: https://drive.google.com/open?id=1vz5hCgO3IYb3kPDO1Ro3gIselENAma0u