Get 2024 Updated Free Oracle 1z0-078 Exam Questions and Answer
1z0-078 Dumps PDF and Test Engine Exam Questions
Oracle 1z0-078 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
NEW QUESTION # 40
Which three statements are true about diagnostic reporting for the OCR and OLR files? (Choose three.)
- A. The OCRDUMP utility can dump specific keys from the OLR in an online fashion with the clusterware running on all nodes.
- B. The OCRDUMP utility can dump specific keys from the OCR in an online fashion with the clusterware running on all nodes.
- C. The OCRCHECK utility can check the OLR in an online fashion with the clusterware running on all nodes.
- D. The OCRCONFIG utilty can be used to repair a corrupt OCR file in an online fashion with the clusterware running on all nodes.
- E. The CLUVFY utility can check the integrity of the OCR but not the OLR.
Answer: A,B,C
NEW QUESTION # 41
Which three statements are true about the Global Resource Directory (GRD) in Oracle 19c RAC database and in Clustered ASM? (Choose three.)
- A. All GRD Enqueue Resource master metadata is held in the large pool of the same database instance.
- B. All GRD Enqueue Resource master metadata is held in the shared pool of the same database instance.
- C. RAC databases have GRD cache resources distributed among all the database instances and stored in the shared pool of each instance.
- D. RAC databases have GRD cache resources distributed among all the database instances and stored in the large pool of each instance.
- E. Shadow GRD resources may exist in more than one database instance for a resource.
- F. Only one GRD shadow resource may exist for an Enqueue Resource.
- G. Clustered ASM has GRD resources distributed among all ASM instances.
Answer: D,E,G
NEW QUESTION # 42
Which three statements are true about ASM Cloud File System (ACFS) encryption? (Choose three.)
- A. A copy of an encrypted file is not encrypted unless it is created in an encrypted directory.
- B. acfsutil encr off can be run by an encryption manager who may not have system administrator privileges.
- C. acfsucil encr on can be used to specify the encryption key length for a directory or file.
- D. acfsutil encr inic is used to establish role separation between encryption managers and encryption auditors.
- E. An ACFS snapshot can be ACFS encrypted.
Answer: C,D,E
NEW QUESTION # 43
Which two statements are true regarding ASM Dynamic Volume Manager (ADVM)? (Choose two.)
- A. Only one ADVM volume can be created in an ASM disk group.
- B. To create an ADVM volume, disk group attributes COMPATIBLE.ASM and COMPATIBLE.ADVM must be minimally set to 12.1.<.span>.
- C. An ADVM volume is individually named and can contain only one file system.
- D. ADVM extends ASM by providing a device driver interface to storage backed by an ASM disk group.
- E. File systems contained in ADVM volumes may only contain database files.
Answer: C,D
NEW QUESTION # 44
Which statement is true concerning the installation of an Oracle Grid Infrastructure 19c patchset and its status during the installation?
- A. When performing rolling patches, crsctl query crs softwareversion always displays the earliest version of the software running anywhere in the cluster.
- B. They can be applied in-place.
- C. When performing rolling patches, the vips for the node being patched are relocated to another node.
- D. Some Grid Infrastructure patchsets may not be intalled in a rolling fashion.
Answer: D
NEW QUESTION # 45
Which three statements are true about the administration and use of policy sets in Oracle 19c Clusterware? (Choose three.)
- A. Clusterware administrators cannot directly modify the policy set when Quality of Service (QoS) Management is used.
- B. A server pool can have the same attributes defined for different policies in the policy set, when user-defined policy management is used.
- C. All server pools in a cluster are controlled by the policy set, when user-defined policy management is used.
- D. 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.
- E. A server pool can have different attributes defined for different policies in the policy set, when user-defined policy management is used.
Answer: B,C,E
NEW QUESTION # 46
Which three statements are true about Quality of Service Management (QoS)? (Choose three.)
- A. It can manage database services only if they are defined as UNIFORM services.
- B. Databases managed by QoS can be administrator managed or policy managed.
- C. It supports multiple databases assigned to the same server pool.
- D. It requires Oracle Grid Infrastructure for a Cluster to be installed and Clusterware to be running.
- E. A server pool can be managed by QoS even if it does have database instances running on any server in the pool.
Answer: B,C,D
NEW QUESTION # 47
Which three statements are true regarding ASM on a four-node cluster? (Choose three.)
- A. An ASM instance and database instances can coexist on the same node.
- B. A database instance on a node can only be a client of an ASM instance running on the same node.
- C. A database instance on a node cannot be a client of an ASM instance running on other nodes.
- D. A database instance on a node can be a client of an ASM instance running on any node.
- E. ASM Cluster File System (ACFS) can be deployed on any nodes.
- F. A database instance on a node uses an ASM instance as an I/O server when requesting I/O to diskgroups.
Answer: A,D,F
NEW QUESTION # 48
Which two statements are true concerning diagnostic components and requirements of Oracle 19c Clusterware? (Choose two.)
- A. There is one ologgerd service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
- B. There is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
- C. The oclumon utility may be used to get and set parameters for the cluster health monitor (CHM) repository.
- D. The diagcolleccion.pl script must be run from the Grid home directory as the arid infrastructure owner.
- E. The clusterware log files are stored inside the Grid Infrastructure Management Repository database used by the cluster health monitor
Answer: C,D
NEW QUESTION # 49
Which two operating system users and groups must be created on each node before installing Oracle Grid Infrastructure 19c? (Choose two.)
- A. an O/S user to own the Grid Infrastructure installation
- B. A group to own Automatic Storage Management (ASM) Filter Driver-provisioned storage
- C. an 0/S user to own the Oracle Database installation
- D. an O/S group called dba
- E. an O/S group to own the software inventory
- F. an O/S user to own the Clusterware installation and a different O/S user own the Automatic Storage Management (ASM) installation
Answer: A,E
NEW QUESTION # 50
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 11.2, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 11.2.
- 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 12.1
- D. Set COMPATIBLE.ASM to 12.1, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 12.1.
- E. Set COMPATIBLE.ASM to 12.1, COMPATIBLE.RDBMS to 11.2, and COMPATIBLE.ADVM to 12.1.
Answer: D
NEW QUESTION # 51
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 available instance even if a preferred instance is available.
- B. When possible, clients with the same colocation_tag are routed to the same instance that offers a given service.
- C. When possible, clients with the same colocation_tag are routed to the same available instance when a preferred instance is not available.
- D. When possible, clients with the same colocation_tag could be routed across a set of preferred instances based on a specific load balancing option.
Answer: B
NEW QUESTION # 52
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 stop the VIP on host01.
- B. Use srvctl stop vip to stop 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 srvctl modify nodeapps to change the VIP on host01.
Answer: A,B,E
NEW QUESTION # 53
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 leaf nodes.
- B. Hub nodes require direct access to the OCR file.
- C. Each leaf node must be connected to storage shared across all cluster nodes.
- D. Leaf nodes require direct access to the voting disks.
- E. Each hub node must be connected to storage shared across all hub nodes.
- F. Hub nodes require direct access to the voting disks.
Answer: B,E,F
NEW QUESTION # 54
Which two statements are true about Transparent Application Continuity in Oracle RAC 19c? (Choose two.)
- A. 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.
- B. Transparent Application Continuity is enabled when failover type=auto.
- C. Recovery of the user database session is done safely by enabling auto recover within the user database session.
- 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. Transparent Application Continuity is enabled when failover type=All
Answer: A,B
NEW QUESTION # 55
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 the ASM instance on the same node.
- E. They listen only for database instances on the same node.
Answer: B,C
NEW QUESTION # 56
Which two commands will stop the Oracle High Availability Services (OHAS) and prevent it from starting automatically at system boot on the local node? (Choose two.)
- A. crsctl disable crs
- B. crsctl config crs
- C. crsctl stop cluster
- D. crsctl stop crs
Answer: A,D
NEW QUESTION # 57
Identify three prerequisites for the successful installation of Oracle Grid Infrastructure 19c when using Full Featured Grid Naming Service (GNS). (Choose three.)
- A. You must create a Grid Management Repository database.
- B. A DHCP service on the private network for the cluster is required to allocate virtual IP addresses for HAIP.
- C. Each cluster node must have at least two network interface cards.
- D. You must enable the Name Server Cache Daemon
- E. DNS must be configured to delegate name resolution for the cluster subdomain to the cluster.
- F. A DHCP service on the public network for the cluster is required to allocate virtual IP addresses as required by the cluster.
Answer: D,E,F
NEW QUESTION # 58
Which two statements are true about the Global Enqueue Service, Instance Locks, and global enqueues in Oracle 19c RAC? (Choose two.)
- A. Global Enqueues and Instance Locks replace mutexes completely in RAC database instances.
- B. Global Enqueues and Instance Locks replace latches completely in RAC database instances.
- C. Global Enqueues may have converters and waiters in the same instance.
- D. Global Enqueues may have owners and waiters in the same instance.
- 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: D,F
NEW QUESTION # 59
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 succeeds and starts an ASM instance on HOST02 and shuts down the ASM instance on HOST03.
- B. It fails because an ASM instance is not configured to run on HOST02.
- C. It succeeds and starts an ASM instance on HOST02 but the ASM instance on HOST03 is not shut down until all connected clients disconnect.
- D. It fails because the ASM instance has not been shut down first on HOST03.
- E. It succeeds and 19c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST01.
- F. It succeeds and 19c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST02.
Answer: B,C,F
NEW QUESTION # 60
Which three statements are true regarding multitenant architecture for RAC databases? (Choose three.)
- A. It requires the cdb to use shared undo management.
- B. One undo tablespace for each pdb is required.
- C. PDBs can have local temporary
- 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: A,C,D
NEW QUESTION # 61
......
Verified 1z0-078 exam dumps Q&As with Correct 79 Questions and Answers: https://testinsides.vcedumps.com/1z0-078-examcollection.html
