[Feb 26, 2024] Free Oracle Database 1z1-078 Exam Question
1z1-078 dumps & Oracle Database sure practice dumps
Oracle 1z1-078 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
NEW QUESTION # 41
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 cluster nodes.
- B. Hub nodes require direct access to the voting disks.
- C. Leaf nodes require direct access to the voting disks.
- D. Each hub node must be connected to storage shared across all hub nodes.
- E. Each leaf node must be connected to storage shared across all leaf nodes.
- F. Hub nodes require direct access to the OCR file.
Answer: B,D,F
NEW QUESTION # 42
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. You can dynamically assign a newly created undo tablespace to an instance.
- C. An instance that performs instance recovery can write to the undo tablespace of a failed 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 # 43
You administer a six-instance, policy-managed, multitenant RAC database CDB1 with three PDBs: PDB_1,PDB_2, and PDB_3.
Server pool prod_pool has a cardinality of three and all six hosts of the cluster are up.
Examine these commands executed on HOST01:
Which two statements are true regarding the AR service? (Choose two.)
- A. AR can fail over to any other available CDBl instance in prod pool.
- B. AR is available only on the CDBl instance on host01.
- C. AR runs as a singleton service in the server pool prod pool and the AR service is available in each of the CDBl instances.
- D. AR can fail over to any one of the available CD31 instances.
- E. AR is available on any one available CDBl instance in prod pool at any one time.
Answer: A,E
NEW QUESTION # 44
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 started on all nodes.
- B. The Oracle Clusterware stack is prevented from being automatically started on host01.
- C. The Oracle Clusterware stack is started on all nodes except host01.
- D. The Oracle Clusterware stack is stopped on all nodes.
- E. The Oracle Clusterware stack is stopped on all nodes except host01.
- F. The Oracle Clusterware stack is prevented from being automatically started on all nodes.
Answer: A,B,D
NEW QUESTION # 45
Which two statements are true about initialization parameters for Clustered ASM instances? (Choose two.)
- A. The ASM_DISKGOUPS parameter is optional.
- B. ASM_POWER_LIMIT controls the number of RDBMS instances that can access a disk group while it is being rebalanced.
- C. The maximum value of ASM_POWER_LIMIT is 1024.
- D. A change to ASM_DISKSTRING requires a restart of all ASM instances for the change to take effect.
- E. The default value of INSTANCE_TYPE is ASM.
Answer: A,E
NEW QUESTION # 46
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 disable crs
- D. crsctl stop crs
Answer: C,D
NEW QUESTION # 47
Which three events occur when a node fails in an Oracle Clusterware 19c Cluster? (Choose three.)
- A. Sessions connected to the failed node could be relocated to one or more surviving nodes.
- B. Cluster Resources running on the failed node are suspended until the node is restarted.
- C. Cluster resources running on the failed node must be recovered when the node is restarted.
- D. Cluster Resources running on the failed node are relocated to one or more surviving hub nodes.
- E. The node is evicted from the cluster
Answer: A,D,E
NEW QUESTION # 48
Which two statements are true concerning the installation of Oracle Grid Infrastructure 19c Cluster? (Choose two.)
- A. Normal Redundancy ASM Disk Groups used for Clusterware files will contain three voting files regardless of the number of
- B. High Redundancy ASM Disk Groups used for Clusterware files will contain two OCRs.
- C. The Grid Infrastructure Management Repository is only required when using ASM.
- D. The Clusterware binaries may be installed without installing ASM binaries.
- E. Specifying the use of Grid Naming Service is optional.
Answer: A,E
NEW QUESTION # 49
Which two statements are true about server categorization in Oracle 19c Clusterware? (Choose two.)
- A. All server attributes used for categorization are administrator modifiable.
- B. Different nodes in a cluster may belong to separate administrator-defined categories.
- C. All nodes in a cluster belong to the same Oracle-supplied category.
- D. Server categories can only be used for nodes running an application server.
- E. All server attributes that may be used to determine the server category are discovered automatically by Oracle Clusterware.
- F. A server may be added to only one category using the crsctl utility.
Answer: B,F
NEW QUESTION # 50
Which three statements are true about ASM Cloud File System (ACFS) encryption? (Choose three.)
- A. acfsucil encr on can be used to specify the encryption key length for a directory or file.
- B. A copy of an encrypted file is not encrypted unless it is created in an encrypted directory.
- C. acfsutil encr off can be run by an encryption manager who may not have system administrator privileges.
- 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: A,D,E
NEW QUESTION # 51
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. Database transactions
- B. Pluggable Databases (PDBs)
- C. Local resources
- D. Administrator-defined resources
- E. Cluster resources
Answer: C,D,E
NEW QUESTION # 52
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 ERP across three Single Client Access Name (SCAN) listeners
- B. Load balancing of connection requests for CRM across all database instances running on servers in the prod pool
- 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. Load balancing of client connection requests for CRM across four Single Client Access Name (SCAN) listeners
- F. Load balancing of connection requests across all six database instances
- G. High availability for the CRM service
Answer: B,C,E,G
NEW QUESTION # 53
Which two statements are true about load balancing using a database service in a RAC environment? (Choose two.)
- A. Client-side connect time load balancing works only if it uses a tnsnames entry specifying load BALANCE=yes.
- B. Server-side load balancing connections are always distributed across instances based on the fastest response time for the service.
- C. Server-side connect time load balancing is done at the time of the initial connection attempt to the database service.
- D. In client-side load balancing, the SCAN listener uses the Load Balancing Advisory to direct a connection request to the least loaded instance hosting the service.
- E. Client-side connect time load balancing is done at the time of the initial connection attempt to the database service.
Answer: C,E
NEW QUESTION # 54
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 all database oracle homes with the same release only on the first cluster node.
- B. It applies a patch to all database oracle homes with the same release on all cluster nodes.
- C. It applies a patch to one oracle home only on the first cluster node.
- D. It applies a patch to one database ORACLE home on alll cluster nodes.
- E. It applies a patch to all oracle homes with the same release only on the first cluster node.
Answer: C
NEW QUESTION # 55
Which three statements are true regarding ASM on a four-node cluster? (Choose three.)
- A. A database instance on a node cannot be a client of an ASM instance running on other nodes.
- B. ASM Cluster File System (ACFS) can be deployed on any nodes.
- C. A database instance on a node can be a client of an ASM instance running on any node.
- D. A database instance on a node uses an ASM instance as an I/O server when requesting I/O to diskgroups.
- E. A database instance on a node can only be a client of an ASM instance running on the same node.
- F. An ASM instance and database instances can coexist on the same node.
Answer: C,D,F
NEW QUESTION # 56
Examine this command:
Which two statements are required for this command to succeed? (Choose two.)
- A. Existing data files in TBS1 must also use the same template.
- B. User-defined subdirectories ORCL and USERS must already exist.
- C. The +DATA disk group should not be part of Flex ASM.
- D. newtemplate must be defined for the +DATA disk group.
- E. The DB_CREATE_FILE_DEST parameter must be set to +DATA(newtemplate).
Answer: B,D
NEW QUESTION # 57
Which three statements are true concerning Automatic Database Diagnostic Monitor (ADDM) for RAC? (Choose three.)
- A. It can analyze performance using data captured on all instances.
- B. It can only analyze performance on the instance running the ADDM job.
- C. It runs automatically in Instance ADDM mode after each AWR snapshot is created.
- D. It can diagnose skew in response time.
- E. It can analyze performance over any given time period.
- F. It can diagnose latency problems in the Cluster Interconnect.
Answer: A,D,E
NEW QUESTION # 58
Which two statements are true concerning buffer states as shown in GV$BH.STATUS in Oracle 19c RAC? (Choose two.)
- A. An xcur image is not shipped to another instance until commits occur for updated rows on the block.
- B. A Pi block image may exist for a specific database block in only one instance.
- C. An xcur image is not downgraded to a SCUR image for shipping to another instance until commits occur for updated rows on the block.
- D. An xcur block image may exist for a specific database block in only one instance.
- E. A CR image may get served from one instance to another to satisfy a read request.
Answer: D,E
NEW QUESTION # 59
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. 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.
- C. 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.
- 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. When using Zero Downtime Patching, the root.sh script must be executed manually with -nodriver update option.
Answer: B,C,E
NEW QUESTION # 60
Secure Cluster Communication protects the cluster interconnect from common security threats when used together with Single Network Support. Secure Cluster Communication includes message digest mechanisms, protection against fuzzing, and uses Transport Layer Security (TLS) to provide privacy and data integrity between the cluster members.
Which statement is true about securing cluster interconnect communication?
- A. Security for the cluster interconnect is invoked by auto-generated server certificates that will be assigned to each cluster node as part of a new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c.
- B. Security for the cluster interconnect is invoked automatically as part of a new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c using an auto-generated encryption key that is stored locally on each node of the cluster in an Oracle Wallet and Database administrators or cluster administrators must provide a valid path for the Wallet file.
- C. Database administrators or cluster administrators must provide a valid server certificate and an Oracle Wallet for each node during new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c to secure the interconnect communication.
- D. Security for the cluster interconnect is invoked automatically as part of a new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c and Database administrators or cluster administrators do not need to make any configuration changes for this feature.
- E. Database administrators or cluster administrators must provide an encryption key during new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c to secure the interconnect communication.
Answer: D
NEW QUESTION # 61
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; 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. 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.
- E. 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.
Answer: B,D
NEW QUESTION # 62
Oracle Clusterware manages an administrator-managed database service defined with the MANUAL management policy.
Which two statements are true? (Choose two.)
- A. The service must be manually restarted with SRVCTL after restarting the Clusterware stack on the node hosting the service.
- B. Clusterware will monitor the service while it is active.
- C. The service must be manually restarted with SRVCTL every time the instance hosting the service fails.
- D. When manually started, the service will always start on one or more available instances rather than on their preferred instances.
- E. The service must be manually started with SRVCTL after a planned restart of the instance hosting the service.
Answer: B,E
NEW QUESTION # 63
......
Oracle 1z1-078 Actual Questions and Braindumps: https://www.ipassleader.com/Oracle/1z1-078-practice-exam-dumps.html
Pass 1z1-078 Exam with Updated 1z1-078 Exam Dumps PDF 2024: https://drive.google.com/open?id=1YH4si9GRGN_FpaLR2jq7Ddw8T6JxfDz_