[2024] New 1z1-078 exam dumps Use Updated Oracle Exam
Verified 1z1-078 Dumps Q&As - 1z1-078 Test Engine with Correct Answers
Oracle 1z1-078 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
NEW QUESTION # 31
A cluster running 19c Grid Infrastructure supports both Oracle 11g to 19c RAC databases using ASM.
The COMPATIBLE.ASM, COMPATIBLE.RDBMS, and COMPATIBLE.ADVM parameters are currently set to 11.2 for all diskgroups..
You must support these capabilities in all diskgroups:
1. ACFS Replication
2. ACFS Encryption
To what minimum values must the compatible attributes be set?
- A. Set COMPATIBLE.ASM to 12.1, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 12.1.
- B. Set COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 11.2, and COMPATIBLE.ADVM to 11.2.
- C. Set COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 11.2.
- D. Set COMPATIBLE.ASM to 12.1, COMPATIBLE.RDBMS to 11.2, and COMPATIBLE.ADVM to 12.1.
- E. Set COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 12.1
Answer: A
NEW QUESTION # 32
Identify three prerequisites for the successful installation of Oracle Grid Infrastructure 19c when using Full Featured Grid Naming Service (GNS). (Choose three.)
- A. DNS must be configured to delegate name resolution for the cluster subdomain to the cluster.
- B. Each cluster node must have at least two network interface cards.
- C. A DHCP service on the private network for the cluster is required to allocate virtual IP addresses for HAIP.
- D. A DHCP service on the public network for the cluster is required to allocate virtual IP addresses as required by the cluster.
- E. You must create a Grid Management Repository database.
- F. You must enable the Name Server Cache Daemon
Answer: A,D,F
NEW QUESTION # 33
Which three statements are true about services and load balancing for Oracle 19c clients connecting to Oracle 19c RAC database instances? (Choose three.)
- A. In server-side load balancing, node listener redirects the client to another node listener for connection to an instance.
- B. Services support the balancing of client connections across RAC database instances.
- C. Client-side connect-time load balancing can balance connection requests across SCAN listeners.
- D. Load balancing can be done by the client, the listener, or both, for any one connection request.
- E. Load balancing can be done by the client or the listener, but not both, for any one connection request.
Answer: A,B,D
NEW QUESTION # 34
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 resource
- D. A Server Pool
- E. an application VIP
Answer: B,C
NEW QUESTION # 35
Which three statements are true about accessing ASM files? (Choose three.)
- A. Database instances perform read I/O directly to ASM Disks.
- B. Database instances perform read I/O using an ASM instance as an I/O Server.
- C. 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
- D. Database instances can write metadata to ASM diskgroups.
- E. ASM instances can write metadata to ASM diskgroups.
Answer: A,D,E
NEW QUESTION # 36
Which two statements are true about v$asm- views in a clustered environment? (Choose two.)
- A. Their names can be seen in v$fixed_table when connected to an instance of any type that is started.
- B. They exist in both ASM and RDBMS instances, but they can display different outputs depending on the instance type.
- C. gv$asm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in the cluster.
- D. Their names can be seen in dice when connected to an ASM instance.
- E. They exist in both ASM and RDBMS instances, and display the same output.
Answer: B,C
NEW QUESTION # 37
Which three statements are true about the services created when the DBCA is used to create a RAC database? (Choose three.)
- A. They can be policy managed for a multitenant database.
- B. Policy-managed services specified for a database allow the creation of a new server pool using dbca.
- C. Singleton services are not permitted for multitenant databases.
- D. A server pool must be created with srvct1 before creating a policy-managed RAC database that uses that server pool for a service.
- E. They can be administrator managed for a multitenant database.
Answer: A,B,E
NEW QUESTION # 38
Which three resources are managed using global concurrency control in an Oracle 19c RAC multi-instance database? (Choose three.)
- A. Latches
- B. Enqueues
- C. Mutexes
- D. Redo log buffers
- E. Database block buffers
- F. Cursors
Answer: A,B,C
NEW QUESTION # 39
Which two actions guarantee that time is synchronized properly on all nodes in a cluster after installing Oracle Grid Infrastructure 19c? (Choose two.)
- A. If network time protocol (NJP) is not configured properly on all cluster nodes, then Oracle Cluster Time Synchronization Service (CTSSD) will start automatically in active mode when the clusterware is started.
- B. Configure network time protocol (NTP) on all cluster nodes; Oracle Cluster Time Synchronization Service (CTSSD) will then start automatically in observer mode when the clusterware is started.
- C. Deactivate network time protocol (NTP) on all cluster nodes; Oracle Cluster Time Synchronization Service (CTSSD) will then start automatically in active mode when the clusterware is started.
- D. Configure network time protocol (NTP) on all cluster nodes, and then start the Oracle Cluster Time Synchronization Service (CTSSD) in active mode on all cluster nodes.
- E. If network time protocol (NTP) time servers are unreachable on any cluster node, then Oracle Cluster Time Synchronization Service (CTSSD) will start automatically in active mode when the clusterware is started.
Answer: A,B
NEW QUESTION # 40
Which three statements are true about ASM Cloud File System (ACFS) replication? (Choose three.)
- A. ACFS auditing information is replicated from the primary file system to the standby file system.
- B. The privilege sysrepl has been introduced for ACFS replication.
- C. One site of an ACFS replication configuration can host both primary and standby file systems.
- D. Replication is automatically terminated if the primary file system has less than 2 GB free space.
- E. Standby redo log files are required on the standby site for synchronous redo transport.
Answer: A,B,C
NEW QUESTION # 41
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 must contain at least two log groups before it can be enabled.
- B. A thread of redo is automatically dropped when an instance is removed from a RAC database by using SRVCTL.
- C. A thread of redo must be created before starting a fourth instance if a thread is not already available.
- D. A redo log group added using alter database add logfile without the instance clause is added to each instance.
- E. All the instances must have the same number of redo log groups and each group must have the same number of redo log members.
Answer: A,C
NEW QUESTION # 42
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. An administrator-managed resource can be started manually using crsct1.
- C. Resource dependencies are automatically set when using a policy-managed resource.
- D. The action script is automatically set when using a policy-managed resource.
- E. An administrator-managed resource can be started manually using srvct1.
- F. A policy-managed resource can be started manually using crsct1.
Answer: B,F
NEW QUESTION # 43
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. Each disk in each of the three fail groups is a mirror of the corresponding disk of the other two failure groups.
- 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. It can contain ASM Dynamic Volume Manager (ADVM) volumes.
Answer: C,E
NEW QUESTION # 44
Which three statements are true regarding multitenant architecture for RAC databases? (Choose three.)
- A. One undo tablespace for each pdb is required.
- B. PDBs can have local temporary
- C. It requires the cdb to use shared undo management.
- D. You can open one, several, or all PD3s on one, several, or all cdb instances.
- E. PDBs must use shared Temporary
- F. One undo tablespace for each instance is required.
Answer: B,C,D
NEW QUESTION # 45
Which three statements are true about undo management in a RAC environment? (Choose three.)
- A. A mixture of automatic undo management and manual undo management is supported within a RAC database.
- B. In a policy-managed RAC database, an undo tablespace may automatically be created if OMF is enabled for the database.
- C. You can dynamically assign a newly created undo tablespace to an instance.
- D. It is necessary to assign a specific undo tablespace to a specific instance.
- E. An instance that performs instance recovery can write to the undo tablespace of a failed instance.
Answer: B,C,E
NEW QUESTION # 46
Which two benefits are obtained by using Affinity to reduce global resource contention? (Choose two.)
- A. 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.
- B. 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.
- 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. 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. 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.
Answer: A,C
NEW QUESTION # 47
......
Pass Your 1z1-078 Dumps as PDF Updated on 2024 With 80 Questions: https://www.lead1pass.com/Oracle/1z1-078-practice-exam-dumps.html
Oracle 1z1-078 Real Exam Questions and Answers FREE: https://drive.google.com/open?id=1y7gb5RARW1UsB8WD69K9GavTp8Drk8gR