Latest Apr 05, 2024 Real 1z1-078 Exam Dumps Questions Valid 1z1-078 Dumps PDF
Oracle 1z1-078 Exam Dumps - PDF Questions and Testing Engine
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 |
|
NEW QUESTION # 41
Your four-node cluster runs Oracle 19c Clusterware and supports a mix of RAC databases from Oracle 10g Release 2 to Oracle 19c.
All databases have one or more services defined.
The Oracle 10g Release 2 database clients connect to the database instances using the public VIP.
The Oracle 11g Release 2, 12c Release 1, and 19c clients connect to the database instances using the Single Client Access Name (SCAN).
You must change the public VIPs.
Which three actions must be performed to change the VIPs on host01, the first node in the cluster? (Choose three.)
- A. Use oifcfg setif to stop the VIP on host01.
- B. Use srvctl modify nodeapps to change the VIP on host01.
- C. Use oifcfg setif to start the VIP on host01.
- D. Use srvctl stop vip to stop the VIP on host01.
- E. Use srvctl start vip to start the VIP on host01.
Answer: A,B,D
NEW QUESTION # 42
Which statement is true concerning the installation of an Oracle Grid Infrastructure 19c patchset and its status during the installation?
- A. They can be applied in-place.
- B. When performing rolling patches, the vips for the node being patched are relocated to another node.
- C. When performing rolling patches, crsctl query crs softwareversion always displays the earliest version of the software running anywhere in the cluster.
- D. Some Grid Infrastructure patchsets may not be intalled in a rolling fashion.
Answer: D
NEW QUESTION # 43
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 = IMMEDIATE, 1 = ABORT
- B. 3 = NORMAL, 2 = TRANSACTIONAL, 1 = ABORT
- C. 3 = NORMAL, 2 = ABORT, 1 = IMMEDIATE
- D. 2 = NORMAL, 3 = IMMEDIATE, 1 = ABORT
- E. 2 = NORMAL, 3 = TRANSACTIONAL, 1 = ABORT
Answer: A,C
NEW QUESTION # 44
Which two statements are true about the Global Enqueue Service, Instance Locks, and global enqueues in Oracle 19c RAC? (Choose two.)
- A. In a RAC database, there is no LMDO process if only one instance is running.
- B. Global Enqueues may have converters and waiters in the same instance.
- C. Global Enqueues may have owners and waiters in the same instance.
- D. Global Enqueues and Instance Locks replace mutexes completely in RAC database instances.
- E. In a RAC One Node database, there is no LMD) process if only one instance is running.
- F. Global Enqueues and Instance Locks replace latches completely in RAC database instances.
Answer: A,C
NEW QUESTION # 45
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 ASM disk groups are configured for the Clusterware files, then ASM must be used for all databases on the cluster.
- C. The Installer permits the creation of a disk group to be used for the Recovery Area for the ASM instance.
- D. If no ASM disk groups are specified during installation, then ASM instances are not started after the installation completes on any cluster node.
- E. ASM disk groups used for voting files and OCR files require a quorum failqroup.
Answer: A,D
NEW QUESTION # 46
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. Transactions on database objects stored in tablespaces in the dgrpi disk group fail.
- C. New allocation units are mirrored in the FG2 failure group until FGl is restored and the disk group resvnchronized-
- D. New allocation units are not mirrored but changes to allocation units are tracked in the FG2 failure group.
Answer: C,D
NEW QUESTION # 47
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. Oracle Managed Files must be enabled or PD3 file name convert must be set.
- B. It can be executed only by a common user with the create pluggable database system privilege connected to the root container.
- C. The source PD3 must be in read only mode on all CD3 instances if the CDB is in No Archive mode.
- D. All running CDB instances must be open in restricted mode.
- E. The source PD3 must be closed on the CDS instance from where the command is executed.
- F. The source pdb must use a global temporary
Answer: A,B,E
NEW QUESTION # 48
Which three statements are true about fully qualified file names in ASM? (Choose three.)
- A. They can be created only if OMF is enabled.
- B. They are the only valid form that can be used for single file creation of a control file.
- C. They can be used to reference existing ASM files.
- D. An alias may be created for an existing file by referring to the fully qualified file name.
- E. They are system Generated at the time of ASM file creation.
Answer: C,D,E
NEW QUESTION # 49
Which two operating system users and groups must be created on each node before installing Oracle Grid Infrastructure 19c? (Choose two.)
- A. A group to own Automatic Storage Management (ASM) Filter Driver-provisioned storage
- B. an O/S user to own the Grid Infrastructure installation
- C. an 0/S user to own the Oracle Database installation
- D. an O/S group to own the software inventory
- E. an O/S group called dba
- F. an O/S user to own the Clusterware installation and a different O/S user own the Automatic Storage Management (ASM) installation
Answer: B,D
NEW QUESTION # 50
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 can be fully automated by selecting the option to automatically run the root.sh script.
- B. When using Zero Downtime Patching, the root.sh script must be executed manually with -nodriver update option.
- C. 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.
- 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. 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.
Answer: B,C,D
NEW QUESTION # 51
Which two statements are true about Transparent Application Continuity in Oracle RAC 19c? (Choose two.)
- A. Transparent Application Continuity is enabled when failover type=auto.
- B. Recovery of the user database session is done safely by enabling auto recover within the user database session.
- C. Transparent Application Continuity is enabled when failover type=All
- D. Recovery of the user database session is done safely and with no need for a DBA to have any knowledge of the application or make application code changes.
- E. Transparent Application Continuity is automatically enabled for a session when a database session reaches a safe place (such as a connection test or a known recoverable point) and the transactions are drained at the database.
Answer: A,D
NEW QUESTION # 52
Which three events occur when a node fails in an Oracle Clusterware 19c Cluster? (Choose three.)
- A. Sessions connected to the failed node could be relocated to one or more surviving nodes.
- B. The node is evicted from the cluster
- C. Cluster Resources running on the failed node are relocated to one or more surviving hub nodes.
- D. Cluster Resources running on the failed node are suspended until the node is restarted.
- E. Cluster resources running on the failed node must be recovered when the node is restarted.
Answer: A,B,C
NEW QUESTION # 53
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 or the listener, but not both, for any one connection request.
- B. Services support the balancing of client connections across RAC database instances.
- C. In server-side load balancing, node listener redirects the client to another node listener for connection to an instance.
- D. Client-side connect-time load balancing can balance connection requests across SCAN listeners.
- E. Load balancing can be done by the client, the listener, or both, for any one connection request.
Answer: B,C,E
NEW QUESTION # 54
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. High availability for the CRM service
- B. High availability for the ERP service
- C. Load balancing of connection requests for ERP across all database instances running on servers in the prod pool
- D. Load balancing of client connection requests for CRM across four Single Client Access Name (SCAN) listeners
- E. Load balancing of client connection requests for ERP across three Single Client Access Name (SCAN) listeners
- F. Load balancing of connection requests across all six database instances
- G. Load balancing of connection requests for CRM across all database instances running on servers in the prod pool
Answer: A,B,D,G
NEW QUESTION # 55
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. An instance that performs instance recovery can write to the undo tablespace of a failed instance.
- C. A mixture of automatic undo management and manual undo management is supported within a RAC database.
- D. In a policy-managed RAC database, an undo tablespace may automatically be created if OMF is enabled for the database.
- E. You can dynamically assign a newly created undo tablespace to an instance.
Answer: B,D,E
NEW QUESTION # 56
Which two statements are true about server categorization in Oracle 19c Clusterware? (Choose two.)
- A. Server categories can only be used for nodes running an application server.
- B. Different nodes in a cluster may belong to separate administrator-defined categories.
- C. All server attributes that may be used to determine the server category are discovered automatically by Oracle Clusterware.
- D. All nodes in a cluster belong to the same Oracle-supplied category.
- E. A server may be added to only one category using the crsctl utility.
- F. All server attributes used for categorization are administrator modifiable.
Answer: B,E
NEW QUESTION # 57
Which two statements are true about load balancing using a database service in a RAC environment? (Choose two.)
- A. Client-side connect time load balancing works only if it uses a tnsnames entry specifying load BALANCE=yes.
- B. Server-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 is done at the time of the initial connection attempt to the database service.
- E. Server-side load balancing connections are always distributed across instances based on the fastest response time for the service.
Answer: B,D
NEW QUESTION # 58
Which three statements are true about ASM Cloud File System (ACFS) encryption? (Choose three.)
- A. A copy of an encrypted file is not encrypted unless it is created in an encrypted directory.
- B. acfsucil encr on can be used to specify the encryption key length for a directory or file.
- C. acfsutil encr off can be run by an encryption manager who may not have system administrator privileges.
- D. acfsutil encr inic is used to establish role separation between encryption managers and encryption auditors.
- E. An ACFS snapshot can be ACFS encrypted.
Answer: B,D,E
NEW QUESTION # 59
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. 1, 2, 3, 4, 5, 6 and 7.
- C. 2, 3, 4 and 6.
- D. 1, 2, 3, 4 and 6.
- E. 1, 2, 3, 4, 5 and 6.
- F. 1, 2, 3 and 4.
Answer: F
NEW QUESTION # 60
......
Reliable Oracle Database 1z1-078 Dumps PDF Apr 05, 2024 Recently Updated Questions: https://dumpsvce.exam4free.com/1z1-078-valid-dumps.html
