Latest 1z0-078 Actual Free Exam Updated 80 Questions
Online Questions - Valid Practice 1z0-078 Exam Dumps Test Questions
NEW QUESTION # 43
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. They listen only for database instances 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 listen only for the ASM instance on the same node.
Answer: A,C
NEW QUESTION # 44
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. You must enable the Name Server Cache Daemon
- C. A DHCP service on the public network for the cluster is required to allocate virtual IP addresses as required by the cluster.
- D. DNS must be configured to delegate name resolution for the cluster subdomain to the cluster.
- E. A DHCP service on the private network for the cluster is required to allocate virtual IP addresses for HAIP.
- F. You must create a Grid Management Repository database.
Answer: B,C,D
NEW QUESTION # 45
Examine this command and output:
Examine this command:
Which statement must be true for the successful execution of the second command?
- A. The disk group compatibility attribute for advm must be set to 12. l or higher.
- B. The parent snapshot must be read/write.
- C. The underlying advm volume must be configured with high redundancy.
- D. The parent snapshot must be read-only.
Answer: D
NEW QUESTION # 46
Which two statements are true about High Availability NFS (HANFS)? (Choose two.)
- A. HANFS provides high availability in case of cluster node failure.
- B. HANFS does not depend on NFS services provided by the underlying operating system.
- 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 an NFS client failure.
- E. HANFS' performance depends on the characteristics of the underlying ASM disks.
Answer: A,E
NEW QUESTION # 47
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 Server Pool
- B. an application VIP
- C. a script agent
- D. an application resource
- E. a resource dependency definition
Answer: C,D
NEW QUESTION # 48
Which three statements are true concerning Automatic Database Diagnostic Monitor (ADDM) for RAC? (Choose three.)
- A. It can diagnose latency problems in the Cluster Interconnect.
- B. It runs automatically in Instance ADDM mode after each AWR snapshot is created.
- 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 using data captured on all instances.
- F. It can analyze performance over any given time period.
Answer: C,E,F
NEW QUESTION # 49
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. Each disk in each of the three fail groups is a mirror of the corresponding disk of the other two failure groups.
- E. It can contain ASM Dynamic Volume Manager (ADVM) volumes.
Answer: C,E
NEW QUESTION # 50
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. acfsutil encr inic is used to establish role separation between encryption managers and encryption auditors.
- 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. A copy of an encrypted file is not encrypted unless it is created in an encrypted directory.
Answer: A,B,D
NEW QUESTION # 51
Which three statements are true about services and load balancing for Oracle 19c clients connecting to Oracle 19c RAC database instances? (Choose three.)
- A. Load balancing can be done by the client, the listener, or both, for any one connection request.
- B. In server-side load balancing, node listener redirects the client to another node listener for connection to an instance.
- C. Client-side connect-time load balancing can balance connection requests across SCAN listeners.
- D. Services support the balancing of client connections across RAC database instances.
- E. Load balancing can be done by the client or the listener, but not both, for any one connection request.
Answer: A,B,D
NEW QUESTION # 52
Which three statements are true about an Oracle Database RAC software installation? (Choose three.)
- A. The software can be installed into an ACFS file system.
- B. SSH user equivalence for the Oracle user can be set up before the software installation.
- C. The software must be installed into a local file system on each node.
- D. Fix-up scripts generated during the installation must be run as root on UNIX platforms.
- E. The software must be installed on all nodes in the cluster.
- F. RAC installations require Oracle Enterprise Edition.
- G. The software must be installed into a cluster file system.
Answer: B,D,F
NEW QUESTION # 53
Which two tasks must be performed before launching the Oracle universal installer to install Oracle Database Software for RAC? (Choose two.)
- A. Grid Infrastructure must be installed on all cluster nodes where the Database software will be installed.
- B. ssh user equivalence for the Oracle software owner must be configured on all cluster nodes where the Database software will be installed.
- C. The Clusterware stack must be up on all cluster nodes where the Database software will be installed.
- D. Grid Infrastructure must be installed on all cluster nodes.
- E. The Clusterware stack must be up on all cluster nodes.
- F. SSH user equivalence for the Oracle software owner must be configured on all cluster nodes.
Answer: B,D
NEW QUESTION # 54
You administer a RAC database that currently runs on a four-node cluster but which has three instances.
Which two statements are always true about redo logs for this RAC database? (Choose two.)
- A. A thread of redo must be created before starting a fourth instance if a thread is not already available.
- B. A thread of redo is automatically dropped when an instance is removed from a RAC database by using SRVCTL.
- C. A thread of redo must contain at least two log groups before it can be enabled.
- D. A redo log group added using alter database add logfile without the instance clause is added to each instance.
- E. All the instances must have the same number of redo log groups and each group must have the same number of redo log members.
Answer: A,C
NEW QUESTION # 55
Which three statements are true about accessing ASM files? (Choose three.)
- A. 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
- B. Database instances perform read I/O directly to ASM Disks.
- C. Database instances perform read I/O using an ASM instance as an I/O Server.
- D. ASM instances can write metadata to ASM diskgroups.
- E. Database instances can write metadata to ASM diskgroups.
Answer: B,D,E
NEW QUESTION # 56
Examine this command:
SQL> CREATE PLUGGABLE DATABASE pdb3 FROM pdb1;
Which three conditions must be true for successful execution of this command on a RAC database? (Choose three.)
- A. The source PD3 must be in read only mode on all CD3 instances if the CDB is in No Archive mode.
- B. The source PD3 must be closed on the CDS instance from where the command is executed.
- C. Oracle Managed Files must be enabled or PD3 file name convert must be set.
- D. It can be executed only by a common user with the create pluggable database system privilege connected to the root container.
- E. All running CDB instances must be open in restricted mode.
- F. The source pdb must use a global temporary
Answer: B,C,D
NEW QUESTION # 57
Which three statements are true regarding multitenant architecture for RAC databases? (Choose three.)
- A. One undo tablespace for each instance is required.
- B. PDBs must use shared Temporary
- C. You can open one, several, or all PD3s on one, several, or all cdb instances.
- D. One undo tablespace for each pdb is required.
- E. PDBs can have local temporary
- F. It requires the cdb to use shared undo management.
Answer: C,E,F
NEW QUESTION # 58
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 (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.
- B. 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.
- C. 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.
- 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. 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.
Answer: B,C
NEW QUESTION # 59
Which two statements are true regarding ASM Dynamic Volume Manager (ADVM)? (Choose two.)
- A. ADVM extends ASM by providing a device driver interface to storage backed by an ASM disk group.
- B. Only one ADVM volume can be created in an ASM disk group.
- C. To create an ADVM volume, disk group attributes COMPATIBLE.ASM and COMPATIBLE.ADVM must be minimally set to 12.1.<.span>.
- D. File systems contained in ADVM volumes may only contain database files.
- E. An ADVM volume is individually named and can contain only one file system.
Answer: A,E
NEW QUESTION # 60
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 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.
- B. 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.
- C. Zero Downtime Patching can be fully automated by selecting the option to automatically run the root.sh script.
- D. 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.
- E. When using Zero Downtime Patching, the root.sh script must be executed manually with -nodriver update option.
Answer: B,D,E
NEW QUESTION # 61
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, and display the same output.
- C. They exist in both ASM and RDBMS instances, but they can display different outputs depending on the instance type.
- D. Their names can be seen in dice when connected to an ASM instance.
- E. gv$asm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in the cluster.
Answer: C,E
NEW QUESTION # 62
Which two methods exist for enabling the collection of additional resource debugging information for specific resources controlled by Oracle 19c Clusterware? (Choose two.)
- A. Use the crsct1 set log res "resource_name=debugging_level2" command.
- B. Use the crsct1 set trace res "resource_name=debugging_level" command.
- C. Set the environment variable _USR_ORA_DEBUG=1 and then stop and restart the resource that requires resource debugging data to be collected.
- D. Use the cluvfy comp command for the specific resource within a component.
Answer: B,C
NEW QUESTION # 63
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 is created on the default network by the appvipcfg utility.
- E. An application VIP can be created with the crsccl utility.
Answer: D,E
NEW QUESTION # 64
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. alter sequence seql order;
- C. alter sequence seql keep;
- D. exec sys.dbms shared pool.keep('SEQ1','Q'>
- E. alter sequence seal cache 10000;
Answer: A,E
NEW QUESTION # 65
You must deploy several Oracle 19c databases on an Oracle Grid Infrastructure Managed Cluster, and are required to have the ability to perform these actions without down time:
1. Apply a Grid Infrastructure interim patch.
2. Apply a Grid Infrastructure Patch Set Update (PSU).
3. Apply a database on-line patch.
4. Apply a Grid Infrastructure patchset.
5. Apply a database patchset.
6. Upgrade Grid Infrastructure from one release to another.
7. Upgrade databases from one release to another.
Your plan is to perform these tasks:
1. Install and configure Oracle Grid Infrastructure on a local file system.
2. Install Oracle Database software on an ACFS file system.
3. Create several RAC One Node databases.
Which of the seven requirements are met by your plan?
- A. 2, 3, 4, 5 and 6.
- B. 2, 3, 4 and 6.
- C. 1, 2, 3, 4, 5, 6 and 7.
- D. 1, 2, 3, 4, 5 and 6.
- E. 1, 2, 3, 4 and 6.
- F. 1, 2, 3 and 4.
Answer: F
NEW QUESTION # 66
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. Transactions on database objects stored in tablespaces in the dgrpi disk group fail.
- 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. The redundancy is lowered until the FGl failgroup is restored and the disk group resynchronized.
Answer: B,C
NEW QUESTION # 67
Which two operating system users and groups must be created on each node before installing Oracle Grid Infrastructure 19c? (Choose two.)
- A. an 0/S user to own the Oracle Database installation
- B. A group to own Automatic Storage Management (ASM) Filter Driver-provisioned storage
- C. an O/S group to own the software inventory
- D. an O/S user to own the Clusterware installation and a different O/S user own the Automatic Storage Management (ASM) installation
- E. an O/S user to own the Grid Infrastructure installation
- F. an O/S group called dba
Answer: C,E
NEW QUESTION # 68
......
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 |
|
1z0-078 Exam PDF [2024] Tests Free Updated Today with Correct 80 Questions: https://pass4sure.exam-killer.com/1z0-078-valid-questions.html
