Quality 1z1-078 PDF Dumps - 1z1-078 Exam Questions
Most UptoDate Oracle 1z1-078 Exam Dumps PDF 2024
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 |
|
NEW QUESTION # 12
Which statement is true about Oracle Database 19c SGA Management?
- A. Oracle RAC Resource Management requires the same SGA value for all the instances of a RAC database which is configured during database startup only.
- B. Oracle RAC Resource Runtime Management allows for automatic and runtime adjustment of the SGA.
- C. Oracle RAC Resource Management only allows assignment of the SGA during database startup.
- D. Oracle RAC Resource Management only allows assignment of the SGA during instance startup.
Answer: B
NEW QUESTION # 13
Which three statements are true concerning activation of a user-defined policy in Oracle 19c Clusterware? (Choose three.)
- A. When a policy is first created, it is initially active.
- B. When a policy is activated, nodes may be reassigned to server pools based on the policy definition.
- C. When a policy is activated, resources cannot be automatically started to comply with the policy definition.
- D. When a policy is first created, it is initially inactive.
- E. When a policy is activated, resources can be automatically stopped to comply with the policy definition.
- F. An administrator-defined policy may be activated using the srvctl utility.
Answer: D,E,F
NEW QUESTION # 14
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 can be fully automated by selecting the option to automatically run the root.sh script.
- B. 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.
- C. When using Zero Downtime Patching, the root.sh script must be executed manually with -nodriver update option.
- D. 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.
- 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: C,D,E
NEW QUESTION # 15
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 could be routed across a set of preferred instances based on a specific load balancing option.
- C. When possible, clients with the same colocation_tag are routed to the same instance that offers a given service.
- D. When possible, clients with the same colocation_tag are routed to the same available instance when a preferred instance is not available.
Answer: C
NEW QUESTION # 16
Disk group DGRP1 has these attributes:
1. Normal redundancy
2. Two failure groups FG1 and FG2 with two disks each
3. Compatibility settings set to 19.0
The FG1 failure group goes offline due to hardware failure.
Which two statements are true? (Choose two.)
- A. The redundancy is lowered until the FGl failgroup is restored and the disk group resynchronized.
- B. New allocation units are not mirrored but changes to allocation units are tracked in the FG2 failure group.
- C. New allocation units are mirrored in the FG2 failure group until FGl is restored and the disk group resvnchronized-
- D. Transactions on database objects stored in tablespaces in the dgrpi disk group fail.
Answer: B,C
NEW QUESTION # 17
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, 4, 5, 6 and 7.
- C. 1, 2, 3 and 4.
- D. 2, 3, 4 and 6.
- E. 1, 2, 3, 4 and 6.
- F. 2, 3, 4, 5 and 6.
Answer: C
NEW QUESTION # 18
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. An ACFS snapshot can be ACFS encrypted.
- D. acfsucil encr on can be used to specify the encryption key length for a directory or file.
- E. acfsutil encr inic is used to establish role separation between encryption managers and encryption auditors.
Answer: C,D,E
NEW QUESTION # 19
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 the same attributes defined for different policies in the policy set, when user-defined policy management is used.
- B. Clusterware administrators cannot directly modify the policy set when Quality of Service (QoS) Management is used.
- C. A server pool can have different attributes defined for different policies in the policy set, when user-defined policy management is used.
- D. All server pools in a cluster are controlled by the policy set, when user-defined policy 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,C,D
NEW QUESTION # 20
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 rootcrs.pl -deconfig -force command as root on host04.
- B. Run the crsctl unpin css - host04 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 crsctl delete node -n host04 command as root on host01, or on either host02 or host03.
- E. Run the crsct1 unpin css - host04 command as root on host04.
- F. Run the rootcrs.pl -deconfig -force command as root on host01, or on either host02 or host03.
Answer: A,D
NEW QUESTION # 21
Which two tasks must be performed before launching the Oracle universal installer to install Oracle Database Software for RAC? (Choose two.)
- A. The Clusterware stack must be up on all cluster nodes where the Database software will be installed.
- B. The Clusterware stack must be up on all cluster nodes.
- C. SSH user equivalence for the Oracle software owner must be configured on all cluster nodes.
- D. Grid Infrastructure must be installed on all cluster nodes.
- E. Grid Infrastructure must be installed on all cluster nodes where the Database software will be installed.
- F. ssh user equivalence for the Oracle software owner must be configured on all cluster nodes where the Database software will be installed.
Answer: D,F
NEW QUESTION # 22
Which three statements are true about services and load balancing for Oracle 19c clients connecting to Oracle 19c RAC database instances? (Choose three.)
- A. Load balancing can be done by the client, the listener, or both, for any one connection request.
- B. Load balancing can be done by the client or the listener, but not both, for any one connection request.
- C. Services support the balancing of client connections across RAC database instances.
- D. Client-side connect-time load balancing can balance connection requests across SCAN listeners.
- E. In server-side load balancing, node listener redirects the client to another node listener for connection to an instance.
Answer: A,C,E
NEW QUESTION # 23
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. All ASM Disks belonging to a disk group should be of the same size for optimal performance.
- C. Hardware-based mirroring combined with ASM mirroring guarantees optimal performance.
- D. Data files, redo logs, and RMAN backup pieces must be stored in different ASM disk groups for optimal performance.
- E. To improve performance a database must have two disk groups; one for data and one for the fast recovery area.
Answer: A,B
NEW QUESTION # 24
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 oracle home only on the first cluster node.
- B. It applies a patch to one database ORACLE home on alll cluster nodes.
- C. It applies a patch to all oracle homes with the same release 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: A
NEW QUESTION # 25
Which three statements are true about undo management in a RAC environment? (Choose three.)
- A. In a policy-managed RAC database, an undo tablespace may automatically be created if OMF is enabled for the database.
- B. An instance that performs instance recovery can write to the undo tablespace of a failed instance.
- C. You can dynamically assign a newly created undo tablespace to an instance.
- D. A mixture of automatic undo management and manual undo management is supported within a RAC database.
- E. It is necessary to assign a specific undo tablespace to a specific instance.
Answer: A,B,C
NEW QUESTION # 26
Which two statements are true about v$asm- views in a clustered environment? (Choose two.)
- A. They exist in both ASM and RDBMS instances, but they can display different outputs depending on the instance type.
- B. Their names can be seen in v$fixed_table when connected to an instance of any type that is started.
- C. Their names can be seen in dice when connected to an ASM instance.
- D. gv$asm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in the cluster.
- E. They exist in both ASM and RDBMS instances, and display the same output.
Answer: A,D
NEW QUESTION # 27
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 = ABORT, 1 = IMMEDIATE
- B. 3 = NORMAL, 2 = TRANSACTIONAL, 1 = ABORT
- C. 3 = NORMAL, 2 = IMMEDIATE, 1 = ABORT
- D. 2 = NORMAL, 3 = IMMEDIATE, 1 = ABORT
- E. 2 = NORMAL, 3 = TRANSACTIONAL, 1 = ABORT
Answer: A,C
NEW QUESTION # 28
Which two statements are true regarding ASM Dynamic Volume Manager (ADVM)? (Choose two.)
- A. To create an ADVM volume, disk group attributes COMPATIBLE.ASM and COMPATIBLE.ADVM must be minimally set to 12.1.<.span>.
- B. Only one ADVM volume can be created in an ASM disk group.
- C. ADVM extends ASM by providing a device driver interface to storage backed by an ASM disk group.
- D. File systems contained in ADVM volumes may only contain database files.
- E. An ADVM volume is individually named and can contain only one file system.
Answer: C,E
NEW QUESTION # 29
Examine this command:
Which two statements are required for this command to succeed? (Choose two.)
- A. The DB_CREATE_FILE_DEST parameter must be set to +DATA(newtemplate).
- B. newtemplate must be defined for the +DATA disk group.
- C. User-defined subdirectories ORCL and USERS must already exist.
- D. The +DATA disk group should not be part of Flex ASM.
- E. Existing data files in TBS1 must also use the same template.
Answer: B,C
NEW QUESTION # 30
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. Any database instance with the COMPATIBLE parameter set to 12.2 or later can access it.
- D. Each disk in each of the three fail groups is a mirror of the corresponding disk of the other two failure groups.
- E. It can contain ASM Dynamic Volume Manager (ADVM) volumes.
Answer: C,E
NEW QUESTION # 31
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. Administrator-defined resources
- C. Database transactions
- D. Cluster resources
- E. Local resources
Answer: B,D,E
NEW QUESTION # 32
Which method should be used to convert a single-instance Oracle 19c Database to a RAC Database?
- A. Using the rconfig utility to create a template from the single-instance database and then using dbca to create a RAC database on the cluster using that template
- B. Using dbca to migrate the database to shared storage and then to start one or more RAC database instances on the cluster
- C. Using the rconfig utility to migrate the database to shared storage and then using dbca to start one or more RAC database instances on the cluster
- D. Using dbca to create a template from the single-instance database and then to create a RAC database on the cluster using that template
Answer: B
NEW QUESTION # 33
Which three statements are true concerning Automatic Database Diagnostic Monitor (ADDM) for RAC? (Choose three.)
- A. It can only analyze performance on the instance running the ADDM job.
- B. It can diagnose skew in response time.
- C. It can diagnose latency problems in the Cluster Interconnect.
- D. It can analyze performance using data captured on all instances.
- E. It can analyze performance over any given time period.
- F. It runs automatically in Instance ADDM mode after each AWR snapshot is created.
Answer: B,D,E
NEW QUESTION # 34
Which two statements are true concerning Oracle 19c Clusterware-managed application VIPs? (Choose two.)
- A. An application VIP is created on the default network by the appvipcfg utility.
- B. An application VIP can be created with the crsccl utility.
- C. An application VIP is created on the interconnect network by the crsccl utility.
- D. If an application sends messages to be displayed and sets the display variable, then an application VIP is required.
- E. Application VIPs do not fail over to surviving cluster nodes when the node hosting the VIP fails.
Answer: A,B
NEW QUESTION # 35
......
100% Free Oracle Database 1z1-078 Dumps PDF Demo Cert Guide Cover: https://pass4sures.freepdfdump.top/1z1-078-valid-torrent.html
