Prepare For Realistic 1z1-078 Dumps PDF - 100% Passing Guarantee
Check the Available 1z1-078 Exam Dumps with 80 Q's
NEW QUESTION # 10
Which two statements are true regarding ASM when installing Oracle Grid Infrastructure 19c? (Choose two.)
- A. ASM disk groups used for voting files and OCR files require a quorum failqroup.
- B. The Installer permits the creation of a disk group to be used for the Recovery Area for the ASM instance.
- C. If no ASM disk groups are specified during installation, then ASM instances are not started after the installation completes on any cluster node.
- D. The Installer permits the creation of a disk group for use by the voting disks and OCR file.
- E. If ASM disk groups are configured for the Clusterware files, then ASM must be used for all databases on the cluster.
Answer: C,D
NEW QUESTION # 11
Which two statements are true concerning buffer states as shown in GV$BH.STATUS in Oracle 19c RAC? (Choose two.)
- A. An xcur image is not shipped to another instance until commits occur for updated rows on the block.
- B. An xcur block image may exist for a specific database block in only one instance.
- C. A Pi block image may exist for a specific database block in only one instance.
- D. A CR image may get served from one instance to another to satisfy a read request.
- E. An xcur image is not downgraded to a SCUR image for shipping to another instance until commits occur for updated rows on the block.
Answer: B,D
NEW QUESTION # 12
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 succeeds but leaves the file system unmounted.
- B. It fails to resize the filesystem because it must be unmounted before resizing.
- C. It fails to resize voli because it must be executed as a user belonging to the sysasm group.
- D. It resizes voli.
- E. It resizes the filesystem mounted on /u01/app/grid/acfsmount.
Answer: D,E
NEW QUESTION # 13
You administer a six-instance, policy-managed, multitenant RAC database CDB1 with three PDBs: PDB_1,PDB_2, and PDB_3.
Server pool prod_pool has a cardinality of three and all six hosts of the cluster are up.
Examine these commands executed on HOST01:
Which two statements are true regarding the AR service? (Choose two.)
- A. AR can fail over to any other available CDBl instance in prod pool.
- B. AR is available on any one available CDBl instance in prod pool at any one time.
- C. AR runs as a singleton service in the server pool prod pool and the AR service is available in each of the CDBl instances.
- D. AR is available only on the CDBl instance on host01.
- E. AR can fail over to any one of the available CD31 instances.
Answer: A,B
NEW QUESTION # 14
Which two statements are true concerning diagnostic components and requirements of Oracle 19c Clusterware? (Choose two.)
- A. There is one ologgerd service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
- B. The diagcolleccion.pl script must be run from the Grid home directory as the arid infrastructure owner.
- C. There is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
- D. The clusterware log files are stored inside the Grid Infrastructure Management Repository database used by the cluster health monitor
- E. The oclumon utility may be used to get and set parameters for the cluster health monitor (CHM) repository.
Answer: B,E
NEW QUESTION # 15
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 srvctl modify nodeapps to change the VIP on host01.
- B. Use srvctl stop vip to stop the VIP on host01.
- C. Use srvctl start vip to start the VIP on host01.
- D. Use oifcfg setif to stop the VIP on host01.
- E. Use oifcfg setif to start the VIP on host01.
Answer: A,B,D
NEW QUESTION # 16
Which task must be performed before running the OPatch utility to patch Oracle Grid Infrastructure 19c?
- A. Update the path environment variable on each cluster node to point to the 50RACLE HOME/OPacch directory
- B. Update the path environment variable on the node where you will run the OPatch utility to point to the SORacle HOME/OPacch directory.
- C. Stage the patch on all cluster nodes.
- D. Stage the patch on the cluster node where the OPacch utility will be executed.
Answer: C
NEW QUESTION # 17
Which two statements are true about Transparent Application Continuity in Oracle RAC 19c? (Choose two.)
- A. Transparent Application Continuity is enabled when failover type=All
- B. 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.
- C. 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.
- D. Transparent Application Continuity is enabled when failover type=auto.
- E. Recovery of the user database session is done safely by enabling auto recover within the user database session.
Answer: C,D
NEW QUESTION # 18
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 available instance even if a preferred instance is available.
- C. When possible, clients with the same colocation_tag are routed to the same instance that offers a given service.
- 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: C
NEW QUESTION # 19
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 used to reference existing ASM files.
- C. They are system Generated at the time of ASM file creation.
- D. They can be created only if OMF is enabled.
- E. They are the only valid form that can be used for single file creation of a control file.
Answer: B,C
NEW QUESTION # 20
Which two statements are true about v$asm- views in a clustered environment? (Choose two.)
- A. They exist in both ASM and RDBMS instances, and display the same output.
- B. They exist in both ASM and RDBMS instances, but they can display different outputs depending on the instance type.
- C. gv$asm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in the cluster.
- D. Their names can be seen in v$fixed_table when connected to an instance of any type that is started.
- E. Their names can be seen in dice when connected to an ASM instance.
Answer: B,C
NEW QUESTION # 21
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. 2 = NORMAL, 3 = IMMEDIATE, 1 = ABORT
- B. 3 = NORMAL, 2 = IMMEDIATE, 1 = ABORT
- C. 2 = NORMAL, 3 = TRANSACTIONAL, 1 = ABORT
- D. 3 = NORMAL, 2 = TRANSACTIONAL, 1 = ABORT
- E. 3 = NORMAL, 2 = ABORT, 1 = IMMEDIATE
Answer: B,E
NEW QUESTION # 22
You performed these steps to disable an ADVM volume containing an ACFS file system:
1. Dismount the file system.
2. Disable the volume with the ASMCMD voldisable command.
Which two statements are true regarding the actions performed? (Choose two.)
- A. The ACFS file system will be permanently removed from the volume.
- B. The ACFS file system will be permanently removed from the volume only if the file system is empty.
- C. The volume can be enabled and the file system can be mounted back again to access the existing data.
- D. The disabling of volume does not destroy data in the file system.
- E. The ACFS mount registry with Oracle restart is automatically deleted.
Answer: C,D
NEW QUESTION # 23
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. Create the current yr directory in the root directory (+).
- B. lAdd the DATAFILE '/CURRENT YR/sales.dbf clause to the command.
- C. Add the autoextend on clause to the command.
- 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 # 24
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. The +DATA disk group should not be part of Flex ASM.
- C. The DB_CREATE_FILE_DEST parameter must be set to +DATA(newtemplate).
- D. Existing data files in TBS1 must also use the same template.
- E. User-defined subdirectories ORCL and USERS must already exist.
Answer: A,E
NEW QUESTION # 25
Which statement describes the usage of Dynamic Service Fallback in Oracle RAC 19c?
- A. To enable Dynamic Service Fallback, you should specify the level of performance of a preferred instance for a service to be relocated to an available instance by setting the -fallback attribute of a service to "Low, Medium, or High".
- B. Dynamic Service Fallback allows a service to relocate to an available instance when the service is stopped on a preferred instance.
- C. Dynamic Service Fallback allows a service to fall back to a preferred instance when it becomes available after it was failed over to an available instance.
- D. Dynamic Service Fallback allows a service to fall back to a preferred instance when the available instance performance falls below a specified threshold after it was failed over to an available instance.
Answer: C
Explanation:
Dynamic Service Fallback allows a service to fall back to a preferred instance when it becomes available after it was failed over to an available instance. This is true because Dynamic Service Fallback is a new feature in Oracle RAC 19c that enables a dynamic database service to automatically relocate to a preferred instance when it is restored, after the service was failed over to an available instance due to the failure of the last preferred instance. This feature improves the availability and performance of the service by minimizing the manual intervention and the number of failovers. To enable Dynamic Service Fallback, you should specify the -failback option for the service as YES when using SRVCTL or DBCA12. Reference:
1: Oracle Database 19c Release 19.3 New Features, Dynamic Services Fallback Option1
2: Automatic Failback of a Service in a Oracle-19c-RAC-Database2
NEW QUESTION # 26
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 cannot be used to automate the opening of the PDB by the Clusterware.
- C. It is uniformly available on all instances for administrator-managed databases.
- D. It is created and started on only one instance when using policy-managed database configuration.
- E. It is not automatically registered in the OCR.
Answer: A
NEW QUESTION # 27
Which two statements are true about High Availability NFS (HANFS)? (Choose two.)
- A. NFS client requests are distributed by DNS in a round-robin fashion to the cluster nodes that export the NFS
- B. HANFS provides high availability in case of an NFS client failure.
- C. HANFS' performance depends on the characteristics of the underlying ASM disks.
- D. HANFS does not depend on NFS services provided by the underlying operating system.
- E. HANFS provides high availability in case of cluster node failure.
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 (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. 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.
- 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, and then start the Oracle Cluster Time Synchronization Service (CTSSD) in active mode on all cluster nodes.
- E. 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.
Answer: B,E
NEW QUESTION # 29
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 cannot be automatically started to comply with 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, nodes may be reassigned to server pools based on 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 # 30
Which three statements are true about Quality of Service Management (QoS)? (Choose three.)
- A. It requires Oracle Grid Infrastructure for a Cluster to be installed and Clusterware to be running.
- B. Databases managed by QoS can be administrator managed or policy managed.
- C. It can manage database services only if they are defined as UNIFORM services.
- D. A server pool can be managed by QoS even if it does have database instances running on any server in the pool.
- E. It supports multiple databases assigned to the same server pool.
Answer: A,B,E
NEW QUESTION # 31
......
Oracle 1z1-078 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
Download 1z1-078 Exam Dumps Questions to get 100% Success: https://passleader.testpassking.com/1z1-078-exam-testking-pass.html