May-2024 New Version 1z0-078 Certificate & Helpful Exam Dumps is Online
1z0-078 Free Certification Exam Material with 79 Q&As
NEW QUESTION # 24
Which two steps must always be performed to delete node host04 from an Oracle 19c Clusterware cluster that does not use Grid Naming Service (GNS)? (Choose two.)
- A. Run the crsct1 unpin css - host04 command as root on host04.
- B. Run the crsctl delete node -n host04 command as root on host01, or on either host02 or host03.
- C. Run the rootcrs.pl -deconfig -force command as root on host04.
- D. Run the rootcrs.pl -deconfig -force command as root on host01, or on either host02 or host03.
- E. Run the crsctl delete node -n host04 command as root on host04.
- F. Run the crsctl unpin css - host04 command as root on host01, or on either host02 or host03.
Answer: B,C
NEW QUESTION # 25
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 are the only valid form that can be used for single file creation of a control file.
- E. They can be created only if OMF is enabled.
Answer: A,B,C
NEW QUESTION # 26
Which two statements are true concerning diagnostic components and requirements of Oracle 19c Clusterware? (Choose two.)
- A. The diagcolleccion.pl script must be run from the Grid home directory as the arid infrastructure owner.
- B. The oclumon utility may be used to get and set parameters for the cluster health monitor (CHM) repository.
- 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. There is one ologgerd service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
Answer: A,B
NEW QUESTION # 27
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 skew in response time.
- C. It can analyze performance using data captured on all instances.
- D. It can diagnose latency problems in the Cluster Interconnect.
- E. It can analyze performance over any given time period.
- F. It can only analyze performance on the instance running the ADDM job.
Answer: B,C,E
NEW QUESTION # 28
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 uniformly available on all instances for administrator-managed databases.
- B. It is not automatically registered in the OCR.
- C. It is created and started on only one instance when using policy-managed database configuration.
- D. It cannot be used to automate the opening of the PDB by the Clusterware.
- E. It is automatically registered in the OCR.
Answer: A,E
NEW QUESTION # 29
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 the ASM instance has not been shut down first on HOST03.
- 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 19c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST01.
- D. It fails because an ASM instance is not configured to run on HOST02.
- 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 starts an ASM instance on HOST02 and shuts down the ASM instance on HOST03.
Answer: B,D,E
NEW QUESTION # 30
Identify three prerequisites for the successful installation of Oracle Grid Infrastructure 19c when using Full Featured Grid Naming Service (GNS). (Choose three.)
- A. A DHCP service on the private network for the cluster is required to allocate virtual IP addresses for HAIP.
- B. DNS must be configured to delegate name resolution for the cluster subdomain to the cluster.
- C. You must create a Grid Management Repository database.
- D. You must enable the Name Server Cache Daemon
- E. A DHCP service on the public network for the cluster is required to allocate virtual IP addresses as required by the cluster.
- F. Each cluster node must have at least two network interface cards.
Answer: B,D,E
NEW QUESTION # 31
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. 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.
- C. Transparent Application Continuity is enabled when failover type=auto.
- D. 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.
- E. Recovery of the user database session is done safely by enabling auto recover within the user database session.
Answer: B,C
NEW QUESTION # 32
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 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
- 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 create a template from the single-instance database and then to create a RAC database on the cluster using that template
Answer: A
NEW QUESTION # 33
Which three statements are true about ASM Cloud File System (ACFS) auditing? (Choose three.)
- A. Audit information gathered by each cluster node can be consolidated into the unified ACFS audit trail.
- B. acfsutil audit archive must be used to archive audit files that are larger than 10 MB.
- C. acfsutil audit purge can be run by an audit manager.
- D. acfsutil audit init must be run by a system administrator.
- E. acfsutil audit read marks audit files to indicate that it is safe to purge them.
Answer: A,C,D
NEW QUESTION # 34
Which two benefits are obtained by using Affinity to reduce global resource contention? (Choose two.)
- A. 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.
- 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 automatically spawn new dedicated database RAC instances to isolate distributed transaction.
- D. 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.
- 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: A,E
NEW QUESTION # 35
Which two methods exist for enabling the collection of additional resource debugging information for specific resources controlled by Oracle 19c Clusterware? (Choose two.)
- A. Set the environment variable _USR_ORA_DEBUG=1 and then stop and restart the resource that requires resource debugging data to be collected.
- B. Use the crsct1 set trace res "resource_name=debugging_level" command.
- 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 # 36
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 = TRANSACTIONAL, 1 = ABORT
- B. 3 = NORMAL, 2 = TRANSACTIONAL, 1 = ABORT
- C. 3 = NORMAL, 2 = ABORT, 1 = IMMEDIATE
- D. 2 = NORMAL, 3 = IMMEDIATE, 1 = ABORT
- E. 3 = NORMAL, 2 = IMMEDIATE, 1 = ABORT
Answer: C,E
NEW QUESTION # 37
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. A server may be added to only one category using the crsctl utility.
- C. All server attributes used for categorization are administrator modifiable.
- D. All nodes in a cluster belong to the same Oracle-supplied category.
- E. Different nodes in a cluster may belong to separate administrator-defined categories.
- F. All server attributes that may be used to determine the server category are discovered automatically by Oracle Clusterware.
Answer: B,E
NEW QUESTION # 38
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. 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.
- B. Zero Downtime Patching can be fully automated by selecting the option to automatically run the root.sh script.
- C. When using Zero Downtime Patching, the root.sh script must be executed manually with -nodriver update option.
- D. 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.
- E. 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.
Answer: A,C,E
NEW QUESTION # 39
Examine this command:
Which two statements are required for this command to succeed? (Choose two.)
- A. Existing data files in TBS1 must also use the same template.
- B. User-defined subdirectories ORCL and USERS must already exist.
- C. newtemplate must be defined for the +DATA disk group.
- D. The DB_CREATE_FILE_DEST parameter must be set to +DATA(newtemplate).
- E. The +DATA disk group should not be part of Flex ASM.
Answer: B,C
NEW QUESTION # 40
Which two statements are true about node listeners in a Grid Infrastructure Cluster using ASM? (Choose two.)
- A. They run from the Grid Infrastructure home by default.
- B. They listen only for the ASM instance on the same node.
- C. There can be only one node listener per node.
- D. They listen on behalf of any ASM instance and all database instances on the same node.
- E. They listen only for database instances on the same node.
Answer: A,D
NEW QUESTION # 41
......
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 |
|
Get The Important Preparation Guide With 1z0-078 Dumps: https://www.testkingpass.com/1z0-078-testking-dumps.html
UPDATED 1z0-078 Exam Questions Certification Test Engine to PDF: https://drive.google.com/open?id=16n9y_N-YaYpsV7YCClutfKA9SJ45W3z2