[Apr 07, 2024] 1z0-078 PDF Recently Updated Questions Dumps to Improve Exam Score
1z0-078 Dumps Full Questions with Free PDF Questions to Pass
NEW QUESTION # 43
Examine this sequence of commands:
The cluster consists of nodes HOST01, HOST02, HOST03 and HOST04, and the clusterware is running on all four nodes.
Which three statements are true about the result of the root user running these commands on HOST01? (Choose three.)
- A. The Oracle Clusterware stack is stopped on all nodes.
- B. The Oracle Clusterware stack is started on all nodes.
- C. The Oracle Clusterware stack is stopped on all nodes except host01.
- D. The Oracle Clusterware stack is started on all nodes except host01.
- E. The Oracle Clusterware stack is prevented from being automatically started on host01.
- F. The Oracle Clusterware stack is prevented from being automatically started on all nodes.
Answer: A,B,E
NEW QUESTION # 44
Which two statements are true about v$asm- views in a clustered environment? (Choose two.)
- A. gv$asm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in the cluster.
- B. Their names can be seen in dice when connected to an ASM instance.
- C. They exist in both ASM and RDBMS instances, and display the same output.
- D. They exist in both ASM and RDBMS instances, but they can display different outputs depending on the instance type.
- E. Their names can be seen in v$fixed_table when connected to an instance of any type that is started.
Answer: A,D
NEW QUESTION # 45
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 cannot be used to automate the opening of the PDB by the Clusterware.
- B. It is automatically registered in the OCR.
- C. It is created and started on only one instance when using policy-managed database configuration.
- D. It is not automatically registered in the OCR.
- E. It is uniformly available on all instances for administrator-managed databases.
Answer: B,E
NEW QUESTION # 46
Examine this command and output:
Examine this command:
Which statement must be true for the successful execution of the second command?
- A. The disk group compatibility attribute for advm must be set to 12. l or higher.
- B. The parent snapshot must be read-only.
- C. The underlying advm volume must be configured with high redundancy.
- D. The parent snapshot must be read/write.
Answer: B
NEW QUESTION # 47
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 succeeds but leaves the file system unmounted.
- C. It resizes voli.
- D. It fails to resize the filesystem because it must be unmounted before resizing.
- E. It fails to resize voli because it must be executed as a user belonging to the sysasm group.
Answer: A,C
NEW QUESTION # 48
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. Create the current yr directory in the root directory (+).
- C. Add the DATAFILE '+DATA/CURRENT YR/sales.dbf clause to the command.
- D. Create the current yr directory in the +data disk group.
- E. lAdd the DATAFILE '/CURRENT YR/sales.dbf clause to the command.
Answer: C,D
NEW QUESTION # 49
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 CLUVFY utility can check the integrity of the OCR but not the OLR.
- C. The OCRDUMP utility can dump specific keys from the OLR in an online fashion with the clusterware running on all nodes.
- D. The OCRDUMP utility can dump specific keys from the OCR in an online fashion with the clusterware running on all nodes.
- 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,C,D
NEW QUESTION # 50
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. Fast Connection Failover (FCF)
- B. Transparent Application Failover (TAF) using Fast Application Notification (FAN)
- C. Fast Connection Failover (FCF) with Transparent Application Failover (TAF)
- D. Transparent Application Failover (TAF)
Answer: A
NEW QUESTION # 51
Which three statements are true about fully qualified file names in ASM? (Choose three.)
- A. They are the only valid form that can be used for single file creation of a control file.
- B. An alias may be created for an existing file by referring to the fully qualified file name.
- C. They can be created only if OMF is enabled.
- D. They are system Generated at the time of ASM file creation.
- E. They can be used to reference existing ASM files.
Answer: B,D,E
NEW QUESTION # 52
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 disable crs
- C. crsctl stop cluster
- D. crsctl config crs
Answer: A,B
NEW QUESTION # 53
Oracle Clusterware manages an administrator-managed database service defined with the MANUAL management policy.
Which two statements are true? (Choose two.)
- A. When manually started, the service will always start on one or more available instances rather than on their preferred instances.
- B. Clusterware will monitor the service while it is active.
- C. The service must be manually restarted with SRVCTL every time the instance hosting the service fails.
- D. The service must be manually restarted with SRVCTL after restarting the Clusterware stack on the node hosting the service.
- E. The service must be manually started with SRVCTL after a planned restart of the instance hosting the service.
Answer: B,E
NEW QUESTION # 54
Which two statements are true concerning Oracle 19c Clusterware-managed application VIPs? (Choose two.)
- A. An application VIP is created on the default network by the appvipcfg utility.
- B. Application VIPs do not fail over to surviving cluster nodes when the node hosting the VIP fails.
- C. If an application sends messages to be displayed and sets the display variable, then an application VIP is required.
- D. An application VIP can be created with the crsccl utility.
- E. An application VIP is created on the interconnect network by the crsccl utility.
Answer: A,D
NEW QUESTION # 55
Which three statements are true about the Oracle Clusterware 19c Flex Cluster architecture? (Choose three.)
- A. Each hub node must be connected to storage shared across all hub nodes.
- B. Each leaf node must be connected to storage shared across all cluster nodes.
- C. Hub nodes require direct access to the voting disks.
- D. Hub nodes require direct access to the OCR file.
- E. Leaf nodes require direct access to the voting disks.
- F. Each leaf node must be connected to storage shared across all leaf nodes.
Answer: A,C,D
NEW QUESTION # 56
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. 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.
- C. 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.
- D. 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.
- 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: C,E
NEW QUESTION # 57
Which two statements are true about load balancing using a database service in a RAC environment? (Choose two.)
- A. 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.
- B. Server-side load balancing connections are always distributed across instances based on the fastest response time for the service.
- C. Client-side connect time load balancing is done at the time of the initial connection attempt to the database service.
- D. Client-side connect time load balancing works only if it uses a tnsnames entry specifying load BALANCE=yes.
- E. Server-side connect time load balancing is done at the time of the initial connection attempt to the database service.
Answer: C,E
NEW QUESTION # 58
Which two statements are true about node listeners in a Grid Infrastructure Cluster using ASM? (Choose two.)
- A. They listen on behalf of any ASM instance and all database instances on the same node.
- B. There can be only one node listener per node.
- C. They listen only for the ASM instance on the same node.
- D. They listen only for database instances on the same node.
- E. They run from the Grid Infrastructure home by default.
Answer: A,E
NEW QUESTION # 59
Which two methods exist for enabling the collection of additional resource debugging information for specific resources controlled by Oracle 19c Clusterware? (Choose two.)
- A. Use the crsct1 set trace res "resource_name=debugging_level" command.
- B. Set the environment variable _USR_ORA_DEBUG=1 and then stop and restart the resource that requires resource debugging data to be collected.
- C. Use the cluvfy comp command for the specific resource within a component.
- D. Use the crsct1 set log res "resource_name=debugging_level2" command.
Answer: A,B
NEW QUESTION # 60
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. There is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
- C. The clusterware log files are stored inside the Grid Infrastructure Management Repository database used by the cluster health monitor
- D. The diagcolleccion.pl script must be run from the Grid home directory as the arid infrastructure owner.
- E. The oclumon utility may be used to get and set parameters for the cluster health monitor (CHM) repository.
Answer: D,E
NEW QUESTION # 61
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 cannot be used to automate the opening of the PDB by the Clusterware.
- B. It is automatically registered in the OCR.
- 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: B
NEW QUESTION # 62
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 Management only allows assignment of the SGA during instance startup.
- C. Oracle RAC Resource Runtime Management allows for automatic and runtime adjustment of the SGA.
- D. Oracle RAC Resource Management only allows assignment of the SGA during database startup.
Answer: C
NEW QUESTION # 63
Which three statements are true concerning activation of a user-defined policy in Oracle 19c Clusterware? (Choose three.)
- A. When a policy is first created, it is initially inactive.
- B. When a policy is activated, nodes may be reassigned to server pools based on the policy definition.
- 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: A,D,F
NEW QUESTION # 64
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 resource dependency definition
- B. a script agent
- C. an application VIP
- D. an application resource
- E. A Server Pool
Answer: B,D
NEW QUESTION # 65
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. New allocation units are not mirrored but changes to allocation units are tracked in the FG2 failure group.
- C. New allocation units are mirrored in the FG2 failure group until FGl is restored and the disk group resvnchronized-
- D. Transactions on database objects stored in tablespaces in the dgrpi disk group fail.
Answer: B,C
NEW QUESTION # 66
Which three statements are true about accessing ASM files? (Choose three.)
- A. ASM instances can write metadata to ASM diskgroups.
- B. Database instances can write metadata to ASM diskgroups.
- C. Database instances perform read I/O directly to ASM Disks.
- D. Database instances perform read I/O using an ASM instance as an I/O Server.
- E. 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
Answer: A,B,C
NEW QUESTION # 67
......
100% Updated Oracle 1z0-078 Enterprise PDF Dumps: https://dumpstorrent.prep4surereview.com/1z0-078-latest-braindumps.html
