PDF Download Free of 1z1-078 Valid Practice Test Questions
1z1-078 Test Engine files, 1z1-078 Dumps PDF
Oracle 1z1-078 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
NEW QUESTION # 29
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. Global Enqueues and Instance Locks replace mutexes completely in RAC database instances.
- D. Global Enqueues and Instance Locks replace latches completely in RAC database instances.
- E. In a RAC One Node database, there is no LMD) process if only one instance is running.
- F. In a RAC database, there is no LMDO process if only one instance is running.
Answer: A,F
NEW QUESTION # 30
Examine this command executed on the first node of a four-node cluster:
$ < DATABASE_ORACLE_HOME >/OPatch/opatch apply 33575673
What does this command do?
- A. It applies a patch to one database ORACLE home on alll cluster nodes.
- B. It applies a patch to all oracle homes with the same release only on the first cluster node.
- C. It applies a patch to one oracle home only on the first cluster node.
- D. It applies a patch to all database oracle homes with the same release only on the first cluster node.
- E. It applies a patch to all database oracle homes with the same release on all cluster nodes.
Answer: C
NEW QUESTION # 31
Which four statements are true concerning the upgrading of Oracle Grid Infrastructure 19c? (Choose four.)
- A. The cluster verification utility cluvfy.sh can verify that the cluster is ready for an upgrade.
- B. The oracle home environment variable must be set to the Grid Infrastructure home directory in the installation owner's environment.
- C. The cluster verification utility cluvfy.sh can generate fixup scripts to run on all nodes of the cluster.
- D. The upgrade must be done out-of-place.
- E. The upgrade must be done in-place.
- F. Upgrade validation may be done using the Oracle Universal Installer which in turn invokes the built-in cluster verification utility.
- G. The oracle SID environment variable must be set to the SID of the ASM instance in the installation owner's environment.
Answer: A,B,C,F
NEW QUESTION # 32
Which three statements are true about ASM Cloud File System (ACFS) encryption? (Choose three.)
- A. acfsutil encr inic is used to establish role separation between encryption managers and encryption auditors.
- B. An ACFS snapshot can be ACFS encrypted.
- C. A copy of an encrypted file is not encrypted unless it is created in an encrypted directory.
- D. acfsutil encr off can be run by an encryption manager who may not have system administrator privileges.
- E. acfsucil encr on can be used to specify the encryption key length for a directory or file.
Answer: A,B,E
NEW QUESTION # 33
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 uniformly available on all instances for administrator-managed databases.
- C. It is automatically registered in the OCR.
- D. It is not automatically registered in the OCR.
- E. It is created and started on only one instance when using policy-managed database configuration.
Answer: C
NEW QUESTION # 34
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 srvctl stop vip to stop the VIP on host01.
- B. Use srvctl modify nodeapps to change the VIP on host01.
- C. Use srvctl start vip to start the VIP on host01.
- D. Use oifcfg setif to start the VIP on host01.
- E. Use oifcfg setif to stop the VIP on host01.
Answer: A,B,E
NEW QUESTION # 35
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 redo log group added using alter database add logfile without the instance clause is added to each instance.
- B. A thread of redo is automatically dropped when an instance is removed from a RAC database by using SRVCTL.
- C. All the instances must have the same number of redo log groups and each group must have the same number of redo log members.
- D. A thread of redo must be created before starting a fourth instance if a thread is not already available.
- E. A thread of redo must contain at least two log groups before it can be enabled.
Answer: D,E
NEW QUESTION # 36
Which statement describes the usage of Dynamic Service Fallback in Oracle RAC 19c?
- A. Dynamic Service Fallback allows a service to fall back to a preferred instance when it becomes available after it was failed over to an available instance.
- B. Dynamic Service Fallback allows a service to relocate to an available instance when the service is stopped on a preferred instance.
- C. To enable Dynamic Service Fallback, you should specify the level of performance of a preferred instance for a service to be relocated to an available instance by setting the -fallback attribute of a service to "Low, Medium, or High".
- D. Dynamic Service Fallback allows a service to fall back to a preferred instance when the available instance performance falls below a specified threshold after it was failed over to an available instance.
Answer: A
Explanation:
Dynamic Service Fallback allows a service to fall back to a preferred instance when it becomes available after it was failed over to an available instance. This is true because Dynamic Service Fallback is a new feature in Oracle RAC 19c that enables a dynamic database service to automatically relocate to a preferred instance when it is restored, after the service was failed over to an available instance due to the failure of the last preferred instance. This feature improves the availability and performance of the service by minimizing the manual intervention and the number of failovers. To enable Dynamic Service Fallback, you should specify the -failback option for the service as YES when using SRVCTL or DBCA12. Reference:
1: Oracle Database 19c Release 19.3 New Features, Dynamic Services Fallback Option1
2: Automatic Failback of a Service in a Oracle-19c-RAC-Database2
NEW QUESTION # 37
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 OCRCONFIG utility can be used to repair a corrupt OCR file in an online fashion with the clusterware running on all nodes.
- C. The OCRDUMP utility can dump specific keys from the OLR in an online fashion with the clusterware running on all nodes.
- D. The CLUVFY utility can check the integrity of the OCR but not the OLR.
- E. The OCRDUMP utility can dump specific keys from the OCR in an online fashion with the clusterware running on all nodes.
Answer: A,C,E
NEW QUESTION # 38
Which three statements are true about Quality of Service Management (QoS)? (Choose three.)
- A. Databases managed by QoS can be administrator managed or policy managed.
- B. It supports multiple databases assigned to the same server pool.
- C. A server pool can be managed by QoS even if it does have database instances running on any server in the pool.
- D. It can manage database services only if they are defined as UNIFORM services.
- E. It requires Oracle Grid Infrastructure for a Cluster to be installed and Clusterware to be running.
Answer: A,B,E
NEW QUESTION # 39
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 run from the Grid Infrastructure home by default.
- C. They listen on behalf of any ASM instance and all database instances on the same node.
- D. They listen only for database instances on the same node.
- E. They listen only for the ASM instance on the same node.
Answer: B,C
NEW QUESTION # 40
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 crsctl unpin css - host04 command as root on host01, or on either host02 or host03.
- B. Run the rootcrs.pl -deconfig -force command as root on host01, or on either host02 or host03.
- C. Run the crsctl delete node -n host04 command as root on host04.
- D. Run the rootcrs.pl -deconfig -force command as root on host04.
- E. Run the crsctl delete node -n host04 command as root on host01, or on either host02 or host03.
- F. Run the crsct1 unpin css - host04 command as root on host04.
Answer: D,E
NEW QUESTION # 41
Examine this command:
Which two statements are true about this disk group, created using Grid Infrastructure 19c? (Choose two.)
- A. Files created in this disk group always have two copies for each allocation unit: one primary and one secondary.
- B. The ASM compatible attributes can be changed to 12. l for this disk group.
- C. Each disk in each of the three fail groups is a mirror of the corresponding disk of the other two failure groups.
- D. It can contain ASM Dynamic Volume Manager (ADVM) volumes.
- E. Any database instance with the COMPATIBLE parameter set to 12.2 or later can access it.
Answer: D,E
NEW QUESTION # 42
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. They can be policy managed for a multitenant database.
- 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 # 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 except host01.
- B. The Oracle Clusterware stack is stopped on all nodes.
- C. The Oracle Clusterware stack is started on all nodes.
- D. The Oracle Clusterware stack is prevented from being automatically started on all nodes.
- E. The Oracle Clusterware stack is started on all nodes except host01.
- F. The Oracle Clusterware stack is prevented from being automatically started on host01.
Answer: B,C,F
NEW QUESTION # 44
Which three statements are true about ASM Cloud File System (ACFS) replication? (Choose three.)
- A. One site of an ACFS replication configuration can host both primary and standby file systems.
- B. Standby redo log files are required on the standby site for synchronous redo transport.
- C. ACFS auditing information is replicated from the primary file system to the standby file system.
- D. Replication is automatically terminated if the primary file system has less than 2 GB free space.
- E. The privilege sysrepl has been introduced for ACFS replication.
Answer: A,C,E
NEW QUESTION # 45
Which three statements are true regarding ASM on a four-node cluster? (Choose three.)
- A. ASM Cluster File System (ACFS) can be deployed on any nodes.
- B. A database instance on a node can be a client of an ASM instance running on any node.
- C. A database instance on a node uses an ASM instance as an I/O server when requesting I/O to diskgroups.
- D. An ASM instance and database instances can coexist on the same node.
- E. A database instance on a node can only be a client of an ASM instance running on the same node.
- F. A database instance on a node cannot be a client of an ASM instance running on other nodes.
Answer: B,C,D
NEW QUESTION # 46
Which two statements are true about Oracle Clustered ASM performance? (Choose two.)
- A. All ASM Disks belonging to a disk group should have the same hardware specifications and storage attributes for optimal performance.
- B. To improve performance a database must have two disk groups; one for data and one for the fast recovery area.
- C. All ASM Disks belonging to a disk group should be of the same size for optimal performance.
- D. Hardware-based mirroring combined with ASM mirroring guarantees optimal performance.
- E. Data files, redo logs, and RMAN backup pieces must be stored in different ASM disk groups for optimal performance.
Answer: A,C
NEW QUESTION # 47
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 (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.
- B. 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.
- C. 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.
- D. 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.
- E. 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.
Answer: C,E
NEW QUESTION # 48
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 CRM across four Single Client Access Name (SCAN) listeners
- B. Load balancing of connection requests across all six database instances
- C. High availability for the ERP service
- D. Load balancing of connection requests for ERP across all database instances running on servers in the prod pool
- E. High availability for the CRM service
- F. Load balancing of connection requests for CRM across all database instances running on servers in the prod pool
- G. Load balancing of client connection requests for ERP across three Single Client Access Name (SCAN) listeners
Answer: A,C,E,F
NEW QUESTION # 49
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. 3 = NORMAL, 2 = IMMEDIATE, 1 = ABORT
- B. 3 = NORMAL, 2 = TRANSACTIONAL, 1 = ABORT
- C. 2 = NORMAL, 3 = IMMEDIATE, 1 = ABORT
- D. 3 = NORMAL, 2 = ABORT, 1 = IMMEDIATE
- E. 2 = NORMAL, 3 = TRANSACTIONAL, 1 = ABORT
Answer: A,D
NEW QUESTION # 50
Which two statements are true about High Availability NFS (HANFS)? (Choose two.)
- A. HANFS provides high availability in case of cluster node failure.
- B. NFS client requests are distributed by DNS in a round-robin fashion to the cluster nodes that export the NFS
- C. HANFS' performance depends on the characteristics of the underlying ASM disks.
- D. HANFS does not depend on NFS services provided by the underlying operating system.
- E. HANFS provides high availability in case of an NFS client failure.
Answer: A,C
NEW QUESTION # 51
......
Pass Your Oracle Database 1z1-078 Exam on Jan 03, 2024 with 80 Questions: https://passleader.briandumpsprep.com/1z1-078-prep-exam-braindumps.html
