1z0-078 Exam Questions Get Updated [2024] with Correct Answers
Practice 1z0-078 Questions With Certification guide Q&A from Training Expert TestPDF
NEW QUESTION # 25
Which statement describes the usage of Dynamic Service Fallback in Oracle RAC 19c?
- A. 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.
- B. 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.
- C. 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".
- D. Dynamic Service Fallback allows a service to relocate to an available instance when the service is stopped on a preferred instance.
Answer: B
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 about initialization parameters for Clustered ASM instances? (Choose two.)
- A. ASM_POWER_LIMIT controls the number of RDBMS instances that can access a disk group while it is being rebalanced.
- B. A change to ASM_DISKSTRING requires a restart of all ASM instances for the change to take effect.
- C. The ASM_DISKGOUPS parameter is optional.
- D. The maximum value of ASM_POWER_LIMIT is 1024.
- E. The default value of INSTANCE_TYPE is ASM.
Answer: C,E
NEW QUESTION # 27
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. lAdd the DATAFILE '/CURRENT YR/sales.dbf clause to the command.
- B. Add the autoextend on 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 # 28
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. It can be executed only by a common user with the create pluggable database system privilege connected to the root container.
- B. The source PD3 must be in read only mode on all CD3 instances if the CDB is in No Archive mode.
- C. The source PD3 must be closed on the CDS instance from where the command is executed.
- D. The source pdb must use a global temporary
- E. Oracle Managed Files must be enabled or PD3 file name convert must be set.
- F. All running CDB instances must be open in restricted mode.
Answer: A,C,E
NEW QUESTION # 29
Which two statements are true regarding ASM when installing Oracle Grid Infrastructure 19c? (Choose two.)
- A. If no ASM disk groups are specified during installation, then ASM instances are not started after the installation completes on any cluster node.
- B. The Installer permits the creation of a disk group for use by the voting disks and OCR file.
- C. If ASM disk groups are configured for the Clusterware files, then ASM must be used for all databases on the cluster.
- D. The Installer permits the creation of a disk group to be used for the Recovery Area for the ASM instance.
- E. ASM disk groups used for voting files and OCR files require a quorum failqroup.
Answer: A,B
NEW QUESTION # 30
Which three statements are true about Quality of Service Management (QoS)? (Choose three.)
- A. It can manage database services only if they are defined as UNIFORM services.
- B. It requires Oracle Grid Infrastructure for a Cluster to be installed and Clusterware to be running.
- C. A server pool can be managed by QoS even if it does have database instances running on any server in the pool.
- D. It supports multiple databases assigned to the same server pool.
- E. Databases managed by QoS can be administrator managed or policy managed.
Answer: B,D,E
NEW QUESTION # 31
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. 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.
- C. 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.
- 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: A,C
NEW QUESTION # 32
Identify three prerequisites for the successful installation of Oracle Grid Infrastructure 19c when using Full Featured Grid Naming Service (GNS). (Choose three.)
- A. You must enable the Name Server Cache Daemon
- B. Each cluster node must have at least two network interface cards.
- C. A DHCP service on the public network for the cluster is required to allocate virtual IP addresses as required by the cluster.
- D. You must create a Grid Management Repository database.
- E. DNS must be configured to delegate name resolution for the cluster subdomain to the cluster.
- F. A DHCP service on the private network for the cluster is required to allocate virtual IP addresses for HAIP.
Answer: A,C,E
NEW QUESTION # 33
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 voli.
- 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 succeeds but leaves the file system unmounted.
- E. It resizes the filesystem mounted on /u01/app/grid/acfsmount.
Answer: A,E
NEW QUESTION # 34
Which three statements are true about the Global Resource Directory (GRD) in Oracle 19c RAC database and in Clustered ASM? (Choose three.)
- A. RAC databases have GRD cache resources distributed among all the database instances and stored in the shared pool of each instance.
- B. Shadow GRD resources may exist in more than one database instance for a resource.
- C. Only one GRD shadow resource may exist for an Enqueue Resource.
- D. All GRD Enqueue Resource master metadata is held in the shared pool of the same database instance.
- E. RAC databases have GRD cache resources distributed among all the database instances and stored in the large pool of each instance.
- F. Clustered ASM has GRD resources distributed among all ASM instances.
- G. All GRD Enqueue Resource master metadata is held in the large pool of the same database instance.
Answer: B,E,F
NEW QUESTION # 35
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. New allocation units are mirrored in the FG2 failure group until FGl is restored and the disk group resvnchronized-
- B. New allocation units are not mirrored but changes to allocation units are tracked in the FG2 failure group.
- C. Transactions on database objects stored in tablespaces in the dgrpi disk group fail.
- D. The redundancy is lowered until the FGl failgroup is restored and the disk group resynchronized.
Answer: A,B
NEW QUESTION # 36
Secure Cluster Communication protects the cluster interconnect from common security threats when used together with Single Network Support. Secure Cluster Communication includes message digest mechanisms, protection against fuzzing, and uses Transport Layer Security (TLS) to provide privacy and data integrity between the cluster members.
Which statement is true about securing cluster interconnect communication?
- A. Database administrators or cluster administrators must provide a valid server certificate and an Oracle Wallet for each node during new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c to secure the interconnect communication.
- B. Security for the cluster interconnect is invoked automatically as part of a new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c and Database administrators or cluster administrators do not need to make any configuration changes for this feature.
- C. Security for the cluster interconnect is invoked by auto-generated server certificates that will be assigned to each cluster node as part of a new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c.
- D. Security for the cluster interconnect is invoked automatically as part of a new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c using an auto-generated encryption key that is stored locally on each node of the cluster in an Oracle Wallet and Database administrators or cluster administrators must provide a valid path for the Wallet file.
- E. Database administrators or cluster administrators must provide an encryption key during new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c to secure the interconnect communication.
Answer: B
NEW QUESTION # 37
Which method should be used to convert a single-instance Oracle 19c Database to a RAC Database?
- A. Using the rconfig utility to migrate the database to shared storage and then using dbca to start one or more RAC database instances on the cluster
- B. Using dbca to create a template from the single-instance database and then to create a RAC database on the cluster using that template
- C. Using the rconfig utility to create a template from the single-instance database and then using dbca to create a RAC database on the cluster using that template
- D. Using dbca to migrate the database to shared storage and then to start one or more RAC database instances on the cluster
Answer: D
NEW QUESTION # 38
Which two statements are true concerning the installation of Oracle Grid Infrastructure 19c Cluster? (Choose two.)
- A. The Clusterware binaries may be installed without installing ASM binaries.
- B. Specifying the use of Grid Naming Service is optional.
- C. Normal Redundancy ASM Disk Groups used for Clusterware files will contain three voting files regardless of the number of
- D. The Grid Infrastructure Management Repository is only required when using ASM.
- E. High Redundancy ASM Disk Groups used for Clusterware files will contain two OCRs.
Answer: B,C
NEW QUESTION # 39
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 and 6.
- B. 1, 2, 3, 4, 5, 6 and 7.
- C. 1, 2, 3 and 4.
- D. 1, 2, 3, 4, 5 and 6.
- E. 2, 3, 4, 5 and 6.
- F. 1, 2, 3, 4 and 6.
Answer: C
NEW QUESTION # 40
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. exec sys.dbms shared pool.keep('SEQ1','Q'>
- C. alter sequence seql keep;
- D. alter sequence seal cache 10000;
- E. alter sequence seql order;
Answer: A,D
NEW QUESTION # 41
Which three statements are true about diagnostic reporting for the OCR and OLR files? (Choose three.)
- A. 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.
- B. The OCRDUMP utility can dump specific keys from the OCR in an online fashion with the clusterware running on all nodes.
- C. The OCRDUMP utility can dump specific keys from the OLR 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 OCRCONFIG utility can be used to repair a corrupt OCR file in an online fashion with the clusterware running on all nodes.
Answer: A,B,C
NEW QUESTION # 42
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. An application VIP can be created with the crsccl utility.
- 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. Application VIPs do not fail over to surviving cluster nodes when the node hosting the VIP fails.
Answer: B,D
NEW QUESTION # 43
Which three statements are true about the administration and use of policy sets in Oracle 19c Clusterware? (Choose three.)
- A. Servers in a server pool outside the control of the policy set are never affected by policy changes, when user-defined policy management is used.
- B. All server pools in a cluster are controlled by the policy set, when user-defined policy management is used.
- C. A server pool can have the same attributes defined for different policies in the policy set, when user-defined policy management is used.
- D. A server pool can have different attributes defined for different policies in the policy set, when user-defined policy management is used.
- E. Clusterware administrators cannot directly modify the policy set when Quality of Service (QoS) Management is used.
Answer: B,C,D
NEW QUESTION # 44
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, crsctl query crs softwareversion always displays the earliest version of the software running anywhere in the cluster.
- C. When performing rolling patches, the vips for the node being patched are relocated to another node.
- D. Some Grid Infrastructure patchsets may not be intalled in a rolling fashion.
Answer: D
NEW QUESTION # 45
Examine this command:
Which two statements are required for this command to succeed? (Choose two.)
- A. User-defined subdirectories ORCL and USERS must already exist.
- B. The DB_CREATE_FILE_DEST parameter must be set to +DATA(newtemplate).
- C. The +DATA disk group should not be part of Flex ASM.
- D. newtemplate must be defined for the +DATA disk group.
- E. Existing data files in TBS1 must also use the same template.
Answer: A,D
NEW QUESTION # 46
......
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 |
|
Prepare Top Oracle 1z0-078 Exam Audio Study Guide Practice Questions Edition: https://braindumps.testpdf.com/1z0-078-practice-test.html
