[Jul-2024] Updated Oracle 1z1-078 Dumps - PDF & Online Engine [Q43-Q68]

[Jul-2024] Updated Oracle 1z1-078 Dumps – PDF & Online Engine

1z1-078.pdf - Questions Answers PDF Sample Questions Reliable

NEW QUESTION # 43
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 OCRDUMP utility can dump specific keys from the OLR in an online fashion with the clusterware running on all nodes.
• C. The OCRCONFIG utility can be used to repair a corrupt OCR file in an online fashion with the clusterware running on all nodes.
• D. The OCRDUMP utility can dump specific keys from the OCR 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,D

NEW QUESTION # 44
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. Resource dependencies are automatically set when using a policy-managed resource.
• C. An administrator-managed resource can be started manually using srvct1.
• D. An administrator-managed resource can be started manually using crsct1.
• E. The action script is automatically set when using a policy-managed resource.
• F. A policy-managed resource can be started manually using crsct1.

Answer: D,F

NEW QUESTION # 45
Which three resources are managed using global concurrency control in an Oracle 19c RAC multi-instance database? (Choose three.)

• A. Redo log buffers
• B. Database block buffers
• C. Cursors
• D. Mutexes
• E. Enqueues
• F. Latches

Answer: D,E,F

NEW QUESTION # 46
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 +data disk group.
• B. lAdd the DATAFILE '/CURRENT YR/sales.dbf clause to the command.
• C. Add the DATAFILE '+DATA/CURRENT YR/sales.dbf clause to the command.
• D. Create the current yr directory in the root directory (+).
• E. Add the autoextend on clause to the command.

Answer: A,C

NEW QUESTION # 47
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 but the ASM instance on HOST03 is not shut down until all connected clients disconnect.
• B. It fails because the ASM instance has not been shut down first on HOST03.
• C. It fails because an ASM instance is not configured to run on HOST02.
• D. It succeeds and starts an ASM instance on HOST02 and shuts down the ASM instance 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: A,C,F

NEW QUESTION # 48
Which two statements are true about server categorization in Oracle 19c Clusterware? (Choose two.)

• A. Different nodes in a cluster may belong to separate administrator-defined categories.
• B. All server attributes that may be used to determine the server category are discovered automatically by Oracle Clusterware.
• C. All server attributes used for categorization are administrator modifiable.
• D. All nodes in a cluster belong to the same Oracle-supplied category.
• E. Server categories can only be used for nodes running an application server.
• F. A server may be added to only one category using the crsctl utility.

Answer: A,F

NEW QUESTION # 49
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. an application VIP
• B. a script agent
• C. A Server Pool
• D. a resource dependency definition
• E. an application resource

Answer: B,E

NEW QUESTION # 50
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. The diagcolleccion.pl script must be run from the Grid home directory as the arid infrastructure owner.
• C. There is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
• D. The clusterware log files are stored inside the Grid Infrastructure Management Repository database used by the cluster health monitor
• E. The oclumon utility may be used to get and set parameters for the cluster health monitor (CHM) repository.

Answer: B,E

NEW QUESTION # 51
Examine this command:

Which two statements are true about this disk group, created using Grid Infrastructure 19c? (Choose two.)

• A. It can contain ASM Dynamic Volume Manager (ADVM) volumes.
• B. Any database instance with the COMPATIBLE parameter set to 12.2 or later can access it.
• C. Files created in this disk group always have two copies for each allocation unit: one primary and one secondary.
• D. Each disk in each of the three fail groups is a mirror of the corresponding disk of the other two failure groups.
• E. The ASM compatible attributes can be changed to 12. l for this disk group.

Answer: A,B

NEW QUESTION # 52
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 config crs
• B. crsctl stop cluster
• C. crsctl stop crs
• D. crsctl disable crs

Answer: C,D

NEW QUESTION # 53
Which two statements are true regarding ASM Dynamic Volume Manager (ADVM)? (Choose two.)

• A. ADVM extends ASM by providing a device driver interface to storage backed by an ASM disk group.
• B. Only one ADVM volume can be created in an ASM disk group.
• C. File systems contained in ADVM volumes may only contain database files.
• D. An ADVM volume is individually named and can contain only one file system.
• E. To create an ADVM volume, disk group attributes COMPATIBLE.ASM and COMPATIBLE.ADVM must be minimally set to 12.1.<.span>.

Answer: A,D

NEW QUESTION # 54
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 # 55
Which three statements are true about undo management in a RAC environment? (Choose three.)

• A. You can dynamically assign a newly created undo tablespace to an instance.
• B. It is necessary to assign a specific undo tablespace to a specific instance.
• C. In a policy-managed RAC database, an undo tablespace may automatically be created if OMF is enabled for the database.
• D. A mixture of automatic undo management and manual undo management is supported within a RAC database.
• E. An instance that performs instance recovery can write to the undo tablespace of a failed instance.

Answer: A,C,E

NEW QUESTION # 56
Which two statements are true concerning the installation of Oracle Grid Infrastructure 19c Cluster? (Choose two.)

• A. The Clusterware binaries may be installed without installing ASM binaries.
• B. Specifying the use of Grid Naming Service is optional.
• C. The Grid Infrastructure Management Repository is only required when using ASM.
• D. Normal Redundancy ASM Disk Groups used for Clusterware files will contain three voting files regardless of the number of
• E. High Redundancy ASM Disk Groups used for Clusterware files will contain two OCRs.

Answer: B,D

NEW QUESTION # 57
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. Transparent Application Failover (TAF)
• B. Fast Connection Failover (FCF)
• C. Fast Connection Failover (FCF) with Transparent Application Failover (TAF)
• D. Transparent Application Failover (TAF) using Fast Application Notification (FAN)

Answer: B

NEW QUESTION # 58
Which two statements are true about v$asm- views in a clustered environment? (Choose two.)

• A. Their names can be seen in dice when connected to an ASM instance.
• B. They exist in both ASM and RDBMS instances, and display the same output.
• C. gv$asm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in the cluster.
• D. They exist in both ASM and RDBMS instances, but they can display different outputs depending on the instance type.
• E. Their names can be seen in v$fixed_table when connected to an instance of any type that is started.

Answer: C,D

NEW QUESTION # 59
Which three statements are true about Quality of Service Management (QoS)? (Choose three.)

• A. It requires Oracle Grid Infrastructure for a Cluster to be installed and Clusterware to be running.
• B. It supports multiple databases assigned to the same server pool.
• C. It can manage database services only if they are defined as UNIFORM services.
• D. A server pool can be managed by QoS even if it does have database instances running on any server in the pool.
• E. Databases managed by QoS can be administrator managed or policy managed.

Answer: A,B,E

NEW QUESTION # 60
Which two tasks must be performed before launching the Oracle universal installer to install Oracle Database Software for RAC? (Choose two.)

• A. Grid Infrastructure must be installed on all cluster nodes.
• B. The Clusterware stack must be up on all cluster nodes where the Database software will be installed.
• C. Grid Infrastructure must be installed on all cluster nodes where the Database software will be installed.
• D. The Clusterware stack must be up on all cluster nodes.
• E. ssh user equivalence for the Oracle software owner must be configured 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.

Answer: A,E

NEW QUESTION # 61
Which two statements are true about node listeners in a Grid Infrastructure Cluster using ASM? (Choose two.)

• A. They listen only for database instances on the same node.
• B. They run from the Grid Infrastructure home by default.
• C. They listen only for the ASM instance on the same node.
• D. They listen on behalf of any ASM instance and all database instances on the same node.
• E. There can be only one node listener per node.

Answer: B,D

NEW QUESTION # 62
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. 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.
• B. When using Zero Downtime Patching, the root.sh script must be executed manually with -nodriver update option.
• C. Zero Downtime Patching can be fully automated by selecting the option to automatically run the root.sh script.
• D. 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.
• E. 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.

Answer: A,B,E

NEW QUESTION # 63
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 = TRANSACTIONAL, 1 = ABORT
• B. 2 = NORMAL, 3 = TRANSACTIONAL, 1 = ABORT
• C. 2 = NORMAL, 3 = IMMEDIATE, 1 = ABORT
• D. 3 = NORMAL, 2 = ABORT, 1 = IMMEDIATE
• E. 3 = NORMAL, 2 = IMMEDIATE, 1 = ABORT

Answer: D,E

NEW QUESTION # 64
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 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.
• C. Dynamic Service Fallback allows a service to relocate to an available instance when the service is stopped on a preferred instance.
• D. 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".

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 # 65
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. An ACFS snapshot can be ACFS encrypted.
• E. acfsutil encr inic is used to establish role separation between encryption managers and encryption auditors.

Answer: C,D,E

NEW QUESTION # 66
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 # 67
Which statement describes the purpose of colocation_tag for client routing with Oracle database 19c?

• A. When possible, clients with the same colocation_tag could be routed across a set of preferred instances based on a specific load balancing option.
• 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 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 even if a preferred instance is available.

Answer: C

NEW QUESTION # 68
......

Oracle 1z1-078 Dumps PDF Are going to be The Best Score: https://pass4sure.practicedump.com/1z1-078-exam-questions.html