Get 1z0-078 Braindumps & 1z0-078 Real Exam Questions
Oracle 1z0-078 Actual Questions and Braindumps
Oracle 1z0-078 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
NEW QUESTION # 14
Which two statements are true concerning Oracle 19c Clusterware-managed application VIPs? (Choose two.)
- A. Application VIPs do not fail over to surviving cluster nodes when the node hosting the VIP fails.
- B. An application VIP is created on the default network by the appvipcfg utility.
- C. An application VIP is created on the interconnect network by the crsccl utility.
- D. An application VIP can be created with the crsccl utility.
- E. If an application sends messages to be displayed and sets the display variable, then an application VIP is required.
Answer: B,D
NEW QUESTION # 15
Examine this command:
Which two statements are true about this disk group, created using Grid Infrastructure 19c? (Choose two.)
- A. The ASM compatible attributes can be changed to 12. l for this disk group.
- B. It can contain ASM Dynamic Volume Manager (ADVM) volumes.
- C. Any database instance with the COMPATIBLE parameter set to 12.2 or later can access it.
- D. Files created in this disk group always have two copies for each allocation unit: one primary and one secondary.
- E. Each disk in each of the three fail groups is a mirror of the corresponding disk of the other two failure groups.
Answer: B,C
NEW QUESTION # 16
Oracle Clusterware manages an administrator-managed database service defined with the MANUAL management policy.
Which two statements are true? (Choose two.)
- A. Clusterware will monitor the service while it is active.
- B. The service must be manually restarted with SRVCTL every time the instance hosting the service fails.
- C. The service must be manually restarted with SRVCTL after restarting the Clusterware stack on the node hosting the service.
- D. When manually started, the service will always start on one or more available instances rather than on their preferred instances.
- E. The service must be manually started with SRVCTL after a planned restart of the instance hosting the service.
Answer: A,E
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. 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. Recovery of the user database session is done safely by enabling auto recover within the user database session.
- D. Transparent Application Continuity is enabled when failover type=auto.
- E. 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.
Answer: B,D
NEW QUESTION # 18
Which three statements are true about accessing ASM files? (Choose three.)
- A. Database instances can write metadata to ASM diskgroups.
- B. 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
- C. Database instances perform read I/O using an ASM instance as an I/O Server.
- D. Database instances perform read I/O directly to ASM Disks.
- E. ASM instances can write metadata to ASM diskgroups.
Answer: A,D,E
NEW QUESTION # 19
Which three statements are true about the Oracle Clusterware 19c Flex Cluster architecture? (Choose three.)
- A. Each leaf node must be connected to storage shared across all cluster nodes.
- B. Each hub node must be connected to storage shared across all hub nodes.
- C. Hub nodes require direct access to the voting disks.
- D. Leaf nodes require direct access to the voting disks.
- E. Each leaf node must be connected to storage shared across all leaf nodes.
- F. Hub nodes require direct access to the OCR file.
Answer: B,C,F
NEW QUESTION # 20
Which two statements are true concerning diagnostic components and requirements of Oracle 19c Clusterware? (Choose two.)
- A. The oclumon utility may be used to get and set parameters for the cluster health monitor (CHM) repository.
- B. The clusterware log files are stored inside the Grid Infrastructure Management Repository database used by the cluster health monitor
- C. The diagcolleccion.pl script must be run from the Grid home directory as the arid infrastructure owner.
- D. There is one ologgerd service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
- E. There is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
Answer: A,C
NEW QUESTION # 21
Which two statements are true about resources defined by an administrator and registered with Oracle 19c Clusterware for high availability? (Choose two.)
- A. A policy-managed resource can be started manually using srvct1.
- B. A policy-managed resource can be started manually using crsct1.
- C. An administrator-managed resource can be started manually using crsct1.
- D. An administrator-managed resource can be started manually using srvct1.
- E. The action script is automatically set when using a policy-managed resource.
- F. Resource dependencies are automatically set when using a policy-managed resource.
Answer: B,C
NEW QUESTION # 22
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 log res "resource_name=debugging_level2" command.
- 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. Set the environment variable _USR_ORA_DEBUG=1 and then stop and restart the resource that requires resource debugging data to be collected.
Answer: B,D
NEW QUESTION # 23
Which three events occur when a node fails in an Oracle Clusterware 19c Cluster? (Choose three.)
- A. Cluster resources running on the failed node must be recovered when the node is restarted.
- B. Cluster Resources running on the failed node are relocated to one or more surviving hub nodes.
- C. The node is evicted from the cluster
- D. Cluster Resources running on the failed node are suspended until the node is restarted.
- E. Sessions connected to the failed node could be relocated to one or more surviving nodes.
Answer: B,C,E
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 host04.
- C. Run the rootcrs.pl -deconfig -force command as root on host01, or on either host02 or host03.
- D. Run the crsctl delete node -n host04 command as root on host01, or on either host02 or host03.
- E. Run the rootcrs.pl -deconfig -force command as root on host04.
- F. Run the crsctl unpin css - host04 command as root on host01, or on either host02 or host03.
Answer: D,E
NEW QUESTION # 25
Examine this command and output:
Examine this command:
Which statement must be true for the successful execution of the second command?
- A. The parent snapshot must be read/write.
- B. The underlying advm volume must be configured with high redundancy.
- C. The disk group compatibility attribute for advm must be set to 12. l or higher.
- D. The parent snapshot must be read-only.
Answer: D
NEW QUESTION # 26
Which two statements are true about node listeners in a Grid Infrastructure Cluster using ASM? (Choose two.)
- A. There can be only one node listener per node.
- B. They listen on behalf of any ASM instance and all database instances on the same node.
- C. They listen only for database instances on the same node.
- D. They run from the Grid Infrastructure home by default.
- E. They listen only for the ASM instance on the same node.
Answer: B,D
NEW QUESTION # 27
You support a RAC database with these characteristics:
1. There are six instances.
2. Server Pool prod has a maximum of four servers.
3. CRM is a policy managed, uniform service using Server Pool prod.
4. ERP is a policy managed, singleton service using Server Pool prod.
5. Grid infrastructure is installed and running in its default configuration.
Which four benefits are provided by this configuration in Oracle 19c? (Choose four.)
- A. Load balancing of client connection requests for ERP across three Single Client Access Name (SCAN) listeners
- B. Load balancing of connection requests for CRM across all database instances running on servers in the prod pool
- C. Load balancing of connection requests across all six database instances
- D. High availability for the CRM service
- E. High availability for the ERP service
- F. Load balancing of connection requests for ERP across all database instances running on servers in the prod pool
- G. Load balancing of client connection requests for CRM across four Single Client Access Name (SCAN) listeners
Answer: B,D,E,G
NEW QUESTION # 28
Which three statements are true about an Oracle Database RAC software installation? (Choose three.)
- A. The software must be installed on all nodes in the cluster.
- B. Fix-up scripts generated during the installation must be run as root on UNIX platforms.
- C. RAC installations require Oracle Enterprise Edition.
- D. The software can be installed into an ACFS file system.
- E. The software must be installed into a local file system on each node.
- F. The software must be installed into a cluster file system.
- G. SSH user equivalence for the Oracle user can be set up before the software installation.
Answer: B,C,G
NEW QUESTION # 29
Which three statements are true concerning Automatic Database Diagnostic Monitor (ADDM) for RAC? (Choose three.)
- A. It can diagnose latency problems in the Cluster Interconnect.
- B. It can analyze performance using data captured on all instances.
- C. It can diagnose skew in response time.
- D. It runs automatically in Instance ADDM mode after each AWR snapshot is created.
- E. It can only analyze performance on the instance running the ADDM job.
- F. It can analyze performance over any given time period.
Answer: B,C,F
NEW QUESTION # 30
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 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.
- B. 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.
- C. 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.
- 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. 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.
Answer: C,E
NEW QUESTION # 31
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. 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.
- 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. 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.
Answer: A,C,E
NEW QUESTION # 32
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 can be automatically stopped to comply with the policy definition.
- 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 first created, it is initially inactive.
Answer: A,D,F
NEW QUESTION # 33
Which two statements are true about initialization parameters for Clustered ASM instances? (Choose two.)
- A. The maximum value of ASM_POWER_LIMIT is 1024.
- B. The default value of INSTANCE_TYPE is ASM.
- C. ASM_POWER_LIMIT controls the number of RDBMS instances that can access a disk group while it is being rebalanced.
- D. The ASM_DISKGOUPS parameter is optional.
- E. A change to ASM_DISKSTRING requires a restart of all ASM instances for the change to take effect.
Answer: B,D
NEW QUESTION # 34
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 are system Generated at the time of ASM file creation.
- D. They can be created only if OMF is enabled.
- E. They can be used to reference existing ASM files.
Answer: C,E
NEW QUESTION # 35
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 oifcfg setif to start the VIP on host01.
- B. Use srvctl modify nodeapps to change the VIP on host01.
- C. Use oifcfg setif to stop the VIP on host01.
- D. Use srvctl stop vip to stop the VIP on host01.
- E. Use srvctl start vip to start the VIP on host01.
Answer: B,C,D
NEW QUESTION # 36
Which two statements are true about Oracle Clustered ASM performance? (Choose two.)
- A. All ASM Disks belonging to a disk group should be of the same size for optimal performance.
- B. All ASM Disks belonging to a disk group should have the same hardware specifications and storage attributes for optimal performance.
- C. To improve performance a database must have two disk groups; one for data and one for the fast recovery area.
- D. Data files, redo logs, and RMAN backup pieces must be stored in different ASM disk groups for optimal performance.
- E. Hardware-based mirroring combined with ASM mirroring guarantees optimal performance.
Answer: A,B
NEW QUESTION # 37
Which two statements are true about server categorization in Oracle 19c Clusterware? (Choose two.)
- A. A server may be added to only one category using the crsctl utility.
- B. All server attributes that may be used to determine the server category are discovered automatically by Oracle Clusterware.
- C. All server attributes used for categorization are administrator modifiable.
- D. All nodes in a cluster belong to the same Oracle-supplied category.
- E. Server categories can only be used for nodes running an application server.
- F. Different nodes in a cluster may belong to separate administrator-defined categories.
Answer: A,F
NEW QUESTION # 38
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. 1, 2, 3, 4, 5 and 6.
- B. 1, 2, 3 and 4.
- C. 2, 3, 4 and 6.
- D. 1, 2, 3, 4 and 6.
- E. 1, 2, 3, 4, 5, 6 and 7.
- F. 2, 3, 4, 5 and 6.
Answer: B
NEW QUESTION # 39
......
1z0-078 Dumps To Pass Oracle Exam in 24 Hours - PracticeTorrent: https://www.practicetorrent.com/1z0-078-practice-exam-torrent.html
Buy Latest 1z0-078 Exam Q&A PDF - One Year Free Update: https://drive.google.com/open?id=1IxibT-DIzQ8UDy-qKuRKodi0mB9xXhIn