Get Ready with 1z1-078 Exam Dumps (2024)
Realistic 1z1-078 Dumps are Available for Instant Access
NEW QUESTION # 38
Which two statements are true about the Global Enqueue Service, Instance Locks, and global enqueues in Oracle 19c RAC? (Choose two.)
- A. Global Enqueues may have owners and waiters in the same instance.
- B. Global Enqueues may have converters and waiters in the same instance.
- C. In a RAC database, there is no LMDO process if only one instance is running.
- D. Global Enqueues and Instance Locks replace mutexes completely in RAC database instances.
- E. In a RAC One Node database, there is no LMD) process if only one instance is running.
- F. Global Enqueues and Instance Locks replace latches completely in RAC database instances.
Answer: A,C
NEW QUESTION # 39
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. If an application sends messages to be displayed and sets the display variable, then an application VIP is required.
- 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. An application VIP is created on the default network by the appvipcfg utility.
Answer: D,E
NEW QUESTION # 40
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. All the instances must have the same number of redo log groups and each group must have the same number of redo log members.
- B. A redo log group added using alter database add logfile without the instance clause is added to each instance.
- C. A thread of redo must be created before starting a fourth instance if a thread is not already available.
- D. A thread of redo must contain at least two log groups before it can be enabled.
- E. A thread of redo is automatically dropped when an instance is removed from a RAC database by using SRVCTL.
Answer: C,D
NEW QUESTION # 41
Which three events occur when a node fails in an Oracle Clusterware 19c Cluster? (Choose three.)
- A. Cluster Resources running on the failed node are relocated to one or more surviving hub nodes.
- B. Cluster Resources running on the failed node are suspended until the node is restarted.
- C. Cluster resources running on the failed node must be recovered when the node is restarted.
- D. The node is evicted from the cluster
- E. Sessions connected to the failed node could be relocated to one or more surviving nodes.
Answer: A,D,E
NEW QUESTION # 42
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. Pluggable Databases (PDBs)
- B. Local resources
- C. Database transactions
- D. Administrator-defined resources
- E. Cluster resources
Answer: B,D,E
NEW QUESTION # 43
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 diagcolleccion.pl script must be run from the Grid home directory as the arid infrastructure owner.
- C. The clusterware log files are stored inside the Grid Infrastructure Management Repository database used by the cluster health monitor
- D. There is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
- 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 # 44
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) with Transparent Application Failover (TAF)
- B. Fast Connection Failover (FCF)
- C. Transparent Application Failover (TAF)
- D. Transparent Application Failover (TAF) using Fast Application Notification (FAN)
Answer: B
NEW QUESTION # 45
Which three statements are true about the administration and use of policy sets in Oracle 19c Clusterware? (Choose three.)
- A. A server pool can have different attributes defined for different policies in the policy set, 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. Clusterware administrators cannot directly modify the policy set when Quality of Service (QoS) Management is used.
- E. 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.
Answer: A,B,C
NEW QUESTION # 46
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 on behalf of any ASM instance and all database instances on the same node.
- C. There can be only one node listener per node.
- D. They listen only for the ASM instance on the same node.
- E. They listen only for database instances on the same node.
Answer: A,B
NEW QUESTION # 47
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. Create the current yr directory in the root directory (+).
- B. Add the DATAFILE '+DATA/CURRENT YR/sales.dbf clause to the command.
- C. Add the autoextend on 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: B,D
NEW QUESTION # 48
Which three statements are true about the Oracle Clusterware 19c Flex Cluster architecture? (Choose three.)
- A. Leaf nodes require direct access to the voting disks.
- 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. Each leaf node must be connected to storage shared across all leaf nodes.
- E. Each leaf node must be connected to storage shared across all cluster nodes.
- F. Hub nodes require direct access to the OCR file.
Answer: B,C,F
NEW QUESTION # 49
Which two statements are true regarding ASM when installing Oracle Grid Infrastructure 19c? (Choose two.)
- A. The Installer permits the creation of a disk group for use by the voting disks and OCR file.
- B. ASM disk groups used for voting files and OCR files require a quorum failqroup.
- C. If ASM disk groups are configured for the Clusterware files, then ASM must be used for all databases on the cluster.
- D. If no ASM disk groups are specified during installation, then ASM instances are not started after the installation completes on any cluster node.
- E. The Installer permits the creation of a disk group to be used for the Recovery Area for the ASM instance.
Answer: A,D
NEW QUESTION # 50
Which three statements are true concerning Automatic Database Diagnostic Monitor (ADDM) for RAC? (Choose three.)
- A. It can analyze performance using data captured on all instances.
- B. It can analyze performance over any given time period.
- C. It can only analyze performance on the instance running the ADDM job.
- D. It can diagnose skew in response time.
- E. It runs automatically in Instance ADDM mode after each AWR snapshot is created.
- F. It can diagnose latency problems in the Cluster Interconnect.
Answer: A,B,D
NEW QUESTION # 51
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. 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.
- 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 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.
- D. 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.
- E. 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.
Answer: B
NEW QUESTION # 52
Which two statements are true about resources defined by an administrator and registered with Oracle 19c Clusterware for high availability? (Choose two.)
- A. An administrator-managed resource can be started manually using srvct1.
- B. The action script is automatically set when using a policy-managed resource.
- C. A policy-managed resource can be started manually using srvct1.
- D. Resource dependencies are automatically set when using a policy-managed resource.
- E. A policy-managed resource can be started manually using crsct1.
- F. An administrator-managed resource can be started manually using crsct1.
Answer: E,F
NEW QUESTION # 53
Which statement describes the purpose of colocation_tag for client routing with Oracle database 19c?
- A. When possible, clients with the same colocation_tag are routed to the same instance that offers a given service.
- B. When possible, clients with the same colocation_tag are routed to the same available instance when a preferred instance is not available.
- C. When possible, clients with the same colocation_tag could be routed across a set of preferred instances based on a specific load balancing option.
- D. When possible, clients with the same colocation_tag are routed to the same available instance even if a preferred instance is available.
Answer: A
NEW QUESTION # 54
Which three statements are true about the services created when the DBCA is used to create a RAC database? (Choose three.)
- A. Policy-managed services specified for a database allow the creation of a new server pool using dbca.
- B. A server pool must be created with srvct1 before creating a policy-managed RAC database that uses that server pool for a service.
- C. Singleton services are not permitted for multitenant databases.
- D. They can be administrator managed for a multitenant database.
- E. They can be policy managed for a multitenant database.
Answer: A,D,E
NEW QUESTION # 55
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 public network for the cluster is required to allocate virtual IP addresses as required by the cluster.
- B. You must enable the Name Server Cache Daemon
- C. You must create a Grid Management Repository database.
- D. Each cluster node must have at least two network interface cards.
- 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,B,E
NEW QUESTION # 56
Which three statements are true regarding multitenant architecture for RAC databases? (Choose three.)
- A. You can open one, several, or all PD3s on one, several, or all cdb instances.
- B. One undo tablespace for each instance is required.
- C. PDBs must use shared Temporary
- D. One undo tablespace for each pdb is required.
- E. PDBs can have local temporary
- F. It requires the cdb to use shared undo management.
Answer: A,E,F
NEW QUESTION # 57
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. SSH user equivalence for the Oracle user can be set up before the software installation.
- C. RAC installations require Oracle Enterprise Edition.
- D. The software must be installed into a local file system on each node.
- E. The software can be installed into an ACFS file system.
- F. The software must be installed into a cluster file system.
- G. Fix-up scripts generated during the installation must be run as root on UNIX platforms.
Answer: B,C,G
NEW QUESTION # 58
......
Oracle 1z1-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 |
|
| Topic 11 |
|
Download Exam 1z1-078 Practice Test Questions with 100% Verified Answers: https://www.examsreviews.com/1z1-078-pass4sure-exam-review.html
Share Latest 1z1-078Test Practice Test Questions, Exam Dumps: https://drive.google.com/open?id=1cwhJYXqOnwOdnz4Ie64xfL1s9HVeK37P