[Jan 17, 2024] 1z0-078 PDF Dumps is essential on your 1z0-078 Exam Questions Certain Success!
1z0-078 PDF Questions - Perfect Prospect To Go With 1z0-078 Practice Exam
NEW QUESTION # 25
Which three statements are true regarding multitenant architecture for RAC databases? (Choose three.)
- A. It requires the cdb to use shared undo management.
- B. You can open one, several, or all PD3s on one, several, or all cdb instances.
- C. One undo tablespace for each instance is required.
- D. One undo tablespace for each pdb is required.
- E. PDBs must use shared Temporary
- F. PDBs can have local temporary
Answer: A,B,F
NEW QUESTION # 26
Which three statements are true about an Oracle Database RAC software installation? (Choose three.)
- A. The software must be installed into a cluster 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. The software can be installed into an ACFS file system.
- E. Fix-up scripts generated during the installation must be run as root on UNIX platforms.
- F. The software must be installed on all nodes in the cluster.
- G. RAC installations require Oracle Enterprise Edition.
Answer: B,E,G
NEW QUESTION # 27
A Java application using thick JDBC connections will soon be deployed, and you must configure a RAC database to support highly available connections.
Broken connections must be re-established as quickly as possible.
Which feature will support this requirement?
- A. Transparent Application Failover (TAF)
- B. Transparent Application Failover (TAF) using Fast Application Notification (FAN)
- C. Fast Connection Failover (FCF) with Transparent Application Failover (TAF)
- D. Fast Connection Failover (FCF)
Answer: D
NEW QUESTION # 28
Which three events occur when a node fails in an Oracle Clusterware 19c Cluster? (Choose three.)
- A. The node is evicted from the cluster
- B. Cluster Resources running on the failed node are suspended until the node is restarted.
- C. Sessions connected to the failed node could be relocated to one or more surviving nodes.
- D. Cluster Resources running on the failed node are relocated to one or more surviving hub nodes.
- E. Cluster resources running on the failed node must be recovered when the node is restarted.
Answer: A,C,D
NEW QUESTION # 29
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. A database instance on a node cannot be a client of an ASM instance running on other nodes.
- C. ASM Cluster File System (ACFS) can be deployed on any nodes.
- D. A database instance on a node uses an ASM instance as an I/O server when requesting I/O to diskgroups.
- E. A database instance on a node can be a client of an ASM instance running on any node.
- F. An ASM instance and database instances can coexist on the same node.
Answer: D,E,F
NEW QUESTION # 30
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 autoextend on clause to the command.
- B. lAdd the DATAFILE '/CURRENT YR/sales.dbf clause to the command.
- C. Create the current yr directory in the root directory (+).
- D. Create the current yr directory in the +data disk group.
- E. Add the DATAFILE '+DATA/CURRENT YR/sales.dbf clause to the command.
Answer: D,E
NEW QUESTION # 31
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. 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. ASM instances can write metadata to ASM diskgroups.
Answer: B,C,E
NEW QUESTION # 32
Which three statements are true concerning activation of a user-defined policy in Oracle 19c Clusterware? (Choose three.)
- A. When a policy is activated, nodes may be reassigned to server pools based on the policy definition.
- B. When a policy is first created, it is initially inactive.
- 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 activated, resources cannot be automatically started to comply with the policy definition.
- F. When a policy is activated, resources can be automatically stopped to comply with the policy definition.
Answer: B,D,F
NEW QUESTION # 33
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. an application VIP
- D. a resource dependency definition
- E. A Server Pool
Answer: A,B
NEW QUESTION # 34
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 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.
- 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, the root.sh script must be executed manually with -nodriver update option.
- D. 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.
- E. Zero Downtime Patching can be fully automated by selecting the option to automatically run the root.sh script.
Answer: A,C,D
NEW QUESTION # 35
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 provides high availability in case of an NFS client failure.
- C. HANFS does not depend on NFS services provided by the underlying operating system.
- D. NFS client requests are distributed by DNS in a round-robin fashion to the cluster nodes that export the NFS
- E. HANFS' performance depends on the characteristics of the underlying ASM disks.
Answer: A,E
NEW QUESTION # 36
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. Services support the balancing of client connections across RAC database instances.
- C. Client-side connect-time load balancing can balance connection requests across SCAN listeners.
- D. In server-side load balancing, node listener redirects the client to another node listener for connection to an instance.
- 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 # 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 OLR in an online fashion with the clusterware running on all nodes.
- B. The OCRDUMP utility can dump specific keys from the OCR in an online fashion with the clusterware running on all nodes.
- C. The OCRCONFIG utility can be used to repair a corrupt OCR file in an online fashion with the clusterware running on all nodes.
- D. The CLUVFY utility can check the integrity of the OCR but not the OLR.
- E. 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.
Answer: A,B,E
NEW QUESTION # 38
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. Some Grid Infrastructure patchsets may not be intalled in a rolling fashion.
- C. They can be applied in-place.
- D. When performing rolling patches, crsctl query crs softwareversion always displays the earliest version of the software running anywhere in the cluster.
Answer: B
NEW QUESTION # 39
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. You must create a Grid Management Repository database.
- D. A DHCP service on the private network for the cluster is required to allocate virtual IP addresses for HAIP.
- 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 # 40
Examine this command:
Which two statements are required for this command to succeed? (Choose two.)
- A. newtemplate must be defined for the +DATA disk group.
- B. User-defined subdirectories ORCL and USERS must already exist.
- C. Existing data files in TBS1 must also use the same template.
- D. The +DATA disk group should not be part of Flex ASM.
- E. The DB_CREATE_FILE_DEST parameter must be set to +DATA(newtemplate).
Answer: A,B
NEW QUESTION # 41
Which three statements are true about undo management in a RAC environment? (Choose three.)
- A. It is necessary to assign a specific undo tablespace to a specific instance.
- B. You can dynamically assign a newly created undo tablespace to an instance.
- C. In a policy-managed RAC database, an undo tablespace may automatically be created if OMF is enabled for the database.
- D. A mixture of automatic undo management and manual undo management is supported within a RAC database.
- E. An instance that performs instance recovery can write to the undo tablespace of a failed instance.
Answer: B,C,E
NEW QUESTION # 42
Which two statements are true regarding ASM Dynamic Volume Manager (ADVM)? (Choose two.)
- A. An ADVM volume is individually named and can contain only one file system.
- B. To create an ADVM volume, disk group attributes COMPATIBLE.ASM and COMPATIBLE.ADVM must be minimally set to 12.1.<.span>.
- C. ADVM extends ASM by providing a device driver interface to storage backed by an ASM disk group.
- D. File systems contained in ADVM volumes may only contain database files.
- E. Only one ADVM volume can be created in an ASM disk group.
Answer: A,C
NEW QUESTION # 43
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 Clusterware installation and a different O/S user own the Automatic Storage Management (ASM) installation
- B. an O/S group to own the software inventory
- C. A group to own Automatic Storage Management (ASM) Filter Driver-provisioned storage
- D. an O/S group called dba
- E. an 0/S user to own the Oracle Database installation
- F. an O/S user to own the Grid Infrastructure installation
Answer: B,F
NEW QUESTION # 44
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.
- B. SSH user equivalence for the Oracle software owner must be configured on all cluster nodes.
- C. ssh user equivalence for the Oracle software owner must be configured on all cluster nodes where the Database software will be installed.
- D. Grid Infrastructure must be installed on all cluster nodes where the Database software will be installed.
- E. Grid Infrastructure must be installed on all cluster nodes.
- F. The Clusterware stack must be up on all cluster nodes where the Database software will be installed.
Answer: C,E
NEW QUESTION # 45
Examine the output of this command:
The ACFS disk group is a normal redundancy disk group with 5 GB of free space.
To increase the size of the ACFS file system, you execute this command as the root user:
$ /sbin/acfsutil size +200M /u01/app/grid/acfsmount
Which two statements are true regarding the outcome of this command? (Choose two.)
- A. It resizes the filesystem mounted on /u01/app/grid/acfsmount.
- B. It fails to resize the filesystem because it must be unmounted before resizing.
- C. It succeeds but leaves the file system unmounted.
- D. It resizes voli.
- E. It fails to resize voli because it must be executed as a user belonging to the sysasm group.
Answer: A,D
NEW QUESTION # 46
Which two statements are true about node listeners in a Grid Infrastructure Cluster using ASM? (Choose two.)
- A. There can be only one node listener per 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. They run from the Grid Infrastructure home by default.
- E. They listen only for database instances on the same node.
Answer: C,D
NEW QUESTION # 47
......
1z0-078 Exam with Accurate Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration PDF Questions: https://www.examsreviews.com/1z0-078-pass4sure-exam-review.html
True Oracle Exam Extraordinary Practice For the 1z0-078 Exam: https://drive.google.com/open?id=1HoMWD8OsLcuZPw9dvasCFNdS-lApJzg0