[Feb 25, 2024] New Real 1z0-078 Exam Dumps Questions
Pass Your 1z0-078 Exam Easily with Accurate Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration PDF Questions
Oracle 1z0-078 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
NEW QUESTION # 47
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. Fast Connection Failover (FCF) with Transparent Application Failover (TAF)
- C. Transparent Application Failover (TAF) using Fast Application Notification (FAN)
- D. Fast Connection Failover (FCF)
Answer: D
NEW QUESTION # 48
For which three entities can the "what-if" command evaluation be used to determine the impact of clusterware management operations in Oracle 19c Clusterware? (Choose three.)
- A. Database transactions
- B. Pluggable Databases (PDBs)
- C. Administrator-defined resources
- D. Cluster resources
- E. Local resources
Answer: C,D,E
NEW QUESTION # 49
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 downgraded to a SCUR image for shipping to another instance until commits occur for updated rows on the block.
- B. A Pi block image may exist for a specific database block in only one instance.
- C. An xcur block image may exist for a specific database block in only one instance.
- D. An xcur image is not shipped to another instance until commits occur for updated rows on the block.
- E. A CR image may get served from one instance to another to satisfy a read request.
Answer: C,E
NEW QUESTION # 50
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. The redundancy is lowered until the FGl failgroup is restored and the disk group resynchronized.
- D. New allocation units are mirrored in the FG2 failure group until FGl is restored and the disk group resvnchronized-
Answer: B,D
NEW QUESTION # 51
Which two benefits are obtained by using Affinity to reduce global resource contention? (Choose two.)
- A. Oracle RAC affinity for partitioned tables routes database requests to Oracle RAC instances in such a way that each instance always gets requests for a disjoint subset of rows in the database, this affinity leads to higher Oracle RAC performance and scalability because of improved cache locality and reduced internode synchronization and block pings.
- B. To enhance the performance of distributed transactions with applications server that provides XA affinity, you can direct all branches of a distributed transaction to a single instance in the cluster to improve cache locality and reduce internode synchronization and block pings.
- C. To enhance the performance of distributed transactions with applications server that provides XA affinity, you can automatically spawn new dedicated database RAC instances to isolate distributed transaction.
- D. Oracle RAC affinity for partitioned tables routes database requests to all available Oracle RAC instances evenly to create a global affinity in such a way that each instance always gets an even number of requests leading to higher Oracle RAC performance by using a higher levels of available global cache to reduce global resource contention.
- E. Oracle RAC affinity for partitioned tables routes all database requests for a partition tables to a single Oracle RAC instance leading to higher Oracle RAC performance and scalability because of improved cache locality and reduced internode synchronization and block pings of the partition tables.
Answer: B,E
NEW QUESTION # 52
Which three statements are true concerning Automatic Database Diagnostic Monitor (ADDM) for RAC? (Choose three.)
- A. It runs automatically in Instance ADDM mode after each AWR snapshot is created.
- B. It can diagnose latency problems in the Cluster Interconnect.
- C. It can diagnose skew in response time.
- D. It can analyze performance over any given time period.
- E. It can only analyze performance on the instance running the ADDM job.
- F. It can analyze performance using data captured on all instances.
Answer: C,D,F
NEW QUESTION # 53
Which statement is true about Oracle Database 19c SGA Management?
- A. Oracle RAC Resource Management requires the same SGA value for all the instances of a RAC database which is configured during database startup only.
- B. Oracle RAC Resource Runtime Management allows for automatic and runtime adjustment of the SGA.
- C. Oracle RAC Resource Management only allows assignment of the SGA during instance startup.
- D. Oracle RAC Resource Management only allows assignment of the SGA during database startup.
Answer: B
NEW QUESTION # 54
Which two commands will stop the Oracle High Availability Services (OHAS) and prevent it from starting automatically at system boot on the local node? (Choose two.)
- A. crsctl stop crs
- B. crsctl stop cluster
- C. crsctl config crs
- D. crsctl disable crs
Answer: A,D
NEW QUESTION # 55
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 created only if OMF is enabled.
- C. They are the only valid form that can be used for single file creation of a control file.
- D. They can be used to reference existing ASM files.
- E. They are system Generated at the time of ASM file creation.
Answer: D,E
NEW QUESTION # 56
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. an application VIP
- B. A Server Pool
- C. a script agent
- D. a resource dependency definition
- E. an application resource
Answer: C,E
NEW QUESTION # 57
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 is automatically dropped when an instance is removed from a RAC database by using SRVCTL.
- B. All the instances must have the same number of redo log groups and each group must have the same number of redo log members.
- C. A redo log group added using alter database add logfile without the instance clause is added to each instance.
- D. A thread of redo must contain at least two log groups before it can be enabled.
- E. A thread of redo must be created before starting a fourth instance if a thread is not already available.
Answer: D,E
NEW QUESTION # 58
Examine the output of the asmcmd and srvctl commands:
Then you execute this command:
$ srvctl relocate asm -currentnode host03 -targetnode host02
Which three statements are true regarding the execution of this command based on the output shown? (Choose three.)
- A. It fails because an ASM instance is not configured to run on HOST02.
- B. It succeeds and starts an ASM instance on HOST02 but the ASM instance on HOST03 is not shut down until all connected clients disconnect.
- C. It succeeds and starts an ASM instance on HOST02 and shuts down the ASM instance on HOST03.
- D. It fails because the ASM instance has not been shut down first on HOST03.
- E. It succeeds and 19c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST02.
- F. It succeeds and 19c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST01.
Answer: A,B,E
NEW QUESTION # 59
Which method should be used to convert a single-instance Oracle 19c Database to a RAC Database?
- A. Using dbca to migrate the database to shared storage and then 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 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
Answer: A
NEW QUESTION # 60
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 created and started on only one instance when using policy-managed database configuration.
- D. It is uniformly available on all instances for administrator-managed databases.
- E. It is not automatically registered in the OCR.
Answer: A
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 dice when connected to an ASM instance.
- B. gv$asm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in the cluster.
- C. Their names can be seen in v$fixed_table when connected to an instance of any type that is started.
- D. They exist in both ASM and RDBMS instances, but they can display different outputs depending on the instance type.
- E. They exist in both ASM and RDBMS instances, and display the same output.
Answer: B,D
NEW QUESTION # 62
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 where the Database software will be installed.
- C. Grid Infrastructure must be installed on all cluster nodes where the Database software will be installed.
- D. Grid Infrastructure must be installed on all cluster nodes.
- E. SSH user equivalence for the Oracle software owner must be configured on all cluster nodes.
- F. The Clusterware stack must be up on all cluster nodes where the Database software will be installed.
Answer: B,D
NEW QUESTION # 63
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 = ABORT, 1 = IMMEDIATE
- C. 2 = NORMAL, 3 = TRANSACTIONAL, 1 = ABORT
- D. 3 = NORMAL, 2 = TRANSACTIONAL, 1 = ABORT
- E. 2 = NORMAL, 3 = IMMEDIATE, 1 = ABORT
Answer: A,B
NEW QUESTION # 64
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. Existing data files in TBS1 must also use the same template.
- C. User-defined subdirectories ORCL and USERS must already exist.
- 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,C
NEW QUESTION # 65
Which task must be performed before running the OPatch utility to patch Oracle Grid Infrastructure 19c?
- A. Stage the patch on the cluster node where the OPacch utility will be executed.
- B. Update the path environment variable on each cluster node to point to the 50RACLE HOME/OPacch directory
- C. Update the path environment variable on the node where you will run the OPatch utility to point to the SORacle HOME/OPacch directory.
- D. Stage the patch on all cluster nodes.
Answer: D
NEW QUESTION # 66
Which three statements are true about the Global Resource Directory (GRD) in Oracle 19c RAC database and in Clustered ASM? (Choose three.)
- A. All GRD Enqueue Resource master metadata is held in the shared pool of the same database instance.
- B. Shadow GRD resources may exist in more than one database instance for a resource.
- C. RAC databases have GRD cache resources distributed among all the database instances and stored in the large pool of each instance.
- D. All GRD Enqueue Resource master metadata is held in the large pool of the same database instance.
- E. Only one GRD shadow resource may exist for an Enqueue Resource.
- F. RAC databases have GRD cache resources distributed among all the database instances and stored in the shared pool of each instance.
- G. Clustered ASM has GRD resources distributed among all ASM instances.
Answer: B,C,G
NEW QUESTION # 67
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 disabling of volume does not destroy data in the file system.
- B. The ACFS mount registry with Oracle restart is automatically deleted.
- C. The volume can be enabled and the file system can be mounted back again to access the existing data.
- D. The ACFS file system will be permanently removed from the volume.
- E. The ACFS file system will be permanently removed from the volume only if the file system is empty.
Answer: A,C
NEW QUESTION # 68
Which two statements are true about initialization parameters for Clustered ASM instances? (Choose two.)
- A. A change to ASM_DISKSTRING requires a restart of all ASM instances for the change to take effect.
- B. The ASM_DISKGOUPS parameter is optional.
- C. The default value of INSTANCE_TYPE is ASM.
- D. The maximum value of ASM_POWER_LIMIT is 1024.
- E. ASM_POWER_LIMIT controls the number of RDBMS instances that can access a disk group while it is being rebalanced.
Answer: B,C
NEW QUESTION # 69
......
1z0-078 Certification Exam Dumps Questions in here: https://drive.google.com/open?id=16iqzw91gdiGin48UmFwz1O43hIg0qJM3
Updated 1z0-078 Exam Practice Test Questions: https://www.examsreviews.com/1z0-078-pass4sure-exam-review.html