2024 Current 1z1-078 dumps Preparation through Our Practice Test
100% Reliable Microsoft 1z1-078 Exam Dumps Test Pdf Exam Material
Oracle 1z1-078 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
NEW QUESTION # 28
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. 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. 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 can be fully automated by selecting the option to automatically run the root.sh script.
- E. When using Zero Downtime Patching, the root.sh script must be executed manually with -nodriver update option.
Answer: A,C,E
NEW QUESTION # 29
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. The service must be manually started with SRVCTL after a planned restart of the instance hosting the service.
- 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. Clusterware will monitor the service while it is active.
Answer: B,E
NEW QUESTION # 30
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 different attributes defined for different policies in the policy set, when user-defined policy management is used.
- C. A server pool can have the same attributes defined for different policies in 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. All server pools in a cluster are controlled by the policy set, when user-defined policy management is used.
Answer: B,C,E
NEW QUESTION # 31
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 is uniformly available on all instances for administrator-managed databases.
- B. It is created and started on only one instance when using policy-managed database configuration.
- C. It is not automatically registered in the OCR.
- D. It cannot be used to automate the opening of the PDB by the Clusterware.
- E. It is automatically registered in the OCR.
Answer: E
NEW QUESTION # 32
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 thread of redo is automatically dropped when an instance is removed from a RAC database by using SRVCTL.
- B. All the instances must have the same number of redo log groups and each group must have the same number of redo log members.
- C. A redo log group added using alter database add logfile without the instance clause is added to each instance.
- D. A thread of redo must contain at least two log groups before it can be enabled.
- E. A thread of redo must be created before starting a fourth instance if a thread is not already available.
Answer: D,E
NEW QUESTION # 33
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 start vip to start the VIP on host01.
- B. Use oifcfg setif to start the VIP on host01.
- C. Use srvctl stop vip to stop the VIP on host01.
- D. Use oifcfg setif to stop the VIP on host01.
- E. Use srvctl modify nodeapps to change the VIP on host01.
Answer: C,D,E
NEW QUESTION # 34
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 connection requests across all six database instances
- 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. High availability for the CRM service
- E. Load balancing of connection requests for ERP across all database instances running on servers in the prod pool
- F. Load balancing of client connection requests for CRM across four Single Client Access Name (SCAN) listeners
- G. Load balancing of client connection requests for ERP across three Single Client Access Name (SCAN) listeners
Answer: B,C,D,F
NEW QUESTION # 35
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. 2, 3, 4 and 6.
- B. 1, 2, 3, 4, 5 and 6.
- C. 1, 2, 3 and 4.
- D. 1, 2, 3, 4 and 6.
- E. 1, 2, 3, 4, 5, 6 and 7.
- F. 2, 3, 4, 5 and 6.
Answer: C
NEW QUESTION # 36
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. Administrator-defined resources
- B. Local resources
- C. Database transactions
- D. Cluster resources
- E. Pluggable Databases (PDBs)
Answer: A,B,D
NEW QUESTION # 37
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 Management only allows assignment of the SGA during database startup.
- C. Oracle RAC Resource Management only allows assignment of the SGA during instance startup.
- D. Oracle RAC Resource Runtime Management allows for automatic and runtime adjustment of the SGA.
Answer: D
NEW QUESTION # 38
Which task must be performed before running the OPatch utility to patch Oracle Grid Infrastructure 19c?
- A. Stage the patch on the cluster node where the OPacch utility will be executed.
- B. Update the path environment variable on the node where you will run the OPatch utility to point to the SORacle HOME/OPacch directory.
- C. Update the path environment variable on each cluster node to point to the 50RACLE HOME/OPacch directory
- D. Stage the patch on all cluster nodes.
Answer: D
NEW QUESTION # 39
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. New allocation units are mirrored in the FG2 failure group until FGl is restored and the disk group resvnchronized-
- B. The redundancy is lowered until the FGl failgroup is restored and the disk group resynchronized.
- C. New allocation units are not mirrored but changes to allocation units are tracked in the FG2 failure group.
- D. Transactions on database objects stored in tablespaces in the dgrpi disk group fail.
Answer: A,C
NEW QUESTION # 40
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 where the Database software will be installed.
- B. ssh user equivalence for the Oracle software owner must be configured on all cluster nodes where the Database software will be installed.
- C. The Clusterware stack must be up on all cluster nodes where the Database software will be installed.
- D. SSH user equivalence for the Oracle software owner must be configured on all cluster nodes.
- E. The Clusterware stack must be up on all cluster nodes.
- F. Grid Infrastructure must be installed on all cluster nodes.
Answer: B,F
NEW QUESTION # 41
Which three statements are true about fully qualified file names in ASM? (Choose three.)
- A. They can be used to reference existing ASM files.
- B. They are the only valid form that can be used for single file creation of a control file.
- C. They can be created only if OMF is enabled.
- D. An alias may be created for an existing file by referring to the fully qualified file name.
- E. They are system Generated at the time of ASM file creation.
Answer: A,E
NEW QUESTION # 42
Which two operating system users and groups must be created on each node before installing Oracle Grid Infrastructure 19c? (Choose two.)
- A. A group to own Automatic Storage Management (ASM) Filter Driver-provisioned storage
- B. an 0/S user to own the Oracle Database installation
- C. an O/S group to own the software inventory
- D. an O/S group called dba
- E. an O/S user to own the Grid Infrastructure installation
- F. an O/S user to own the Clusterware installation and a different O/S user own the Automatic Storage Management (ASM) installation
Answer: C,E
NEW QUESTION # 43
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. In a RAC One Node database, there is no LMD) process if only one instance is running.
- 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 database, there is no LMDO process if only one instance is running.
- F. Global Enqueues and Instance Locks replace latches completely in RAC database instances.
Answer: D,E
NEW QUESTION # 44
Which three statements are true regarding multitenant architecture for RAC databases? (Choose three.)
- A. You can open one, several, or all PD3s on one, several, or all cdb instances.
- B. One undo tablespace for each pdb is required.
- C. It requires the cdb to use shared undo management.
- D. PDBs must use shared Temporary
- E. One undo tablespace for each instance is required.
- F. PDBs can have local temporary
Answer: A,C,F
NEW QUESTION # 45
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 succeeds and starts an ASM instance on HOST02 and shuts down the ASM instance on HOST03.
- C. It succeeds and 19c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST01.
- D. It fails because an ASM instance is not configured to run on HOST02.
- E. It succeeds and 19c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST02.
- F. It fails because the ASM instance has not been shut down first on HOST03.
Answer: A,D,E
NEW QUESTION # 46
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. 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; Oracle Cluster Time Synchronization Service (CTSSD) will then start automatically in observer mode when the clusterware is started.
Answer: D,E
NEW QUESTION # 47
Which two statements are true about node listeners in a Grid Infrastructure Cluster using ASM? (Choose two.)
- A. They listen only for the ASM instance on the same node.
- B. There can be only one node listener per node.
- C. They run from the Grid Infrastructure home by default.
- D. They listen only for database instances on the same node.
- E. They listen on behalf of any ASM instance and all database instances on the same node.
Answer: C,E
NEW QUESTION # 48
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. An ASM instance and database instances can coexist on the same node.
- C. A database instance on a node can only be a client of an ASM instance running on the same node.
- D. ASM Cluster File System (ACFS) can be deployed on any nodes.
- E. A database instance on a node uses an ASM instance as an I/O server when requesting I/O to diskgroups.
- F. A database instance on a node can be a client of an ASM instance running on any node.
Answer: B,E,F
NEW QUESTION # 49
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 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.
- B. 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.
- 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. 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.
Answer: D
NEW QUESTION # 50
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. The default value of INSTANCE_TYPE is ASM.
- E. A change to ASM_DISKSTRING requires a restart of all ASM instances for the change to take effect.
Answer: A,D
NEW QUESTION # 51
Which three statements are true about diagnostic reporting for the OCR and OLR files? (Choose three.)
- A. The OCRCHECK utility can check the OLR 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 CLUVFY utility can check the integrity of the OCR but not the OLR.
- 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 OCRDUMP utility can dump specific keys from the OCR in an online fashion with the clusterware running on all nodes.
Answer: A,B,E
NEW QUESTION # 52
Which two statements are true concerning the installation of Oracle Grid Infrastructure 19c Cluster? (Choose two.)
- A. The Grid Infrastructure Management Repository is only required when using ASM.
- B. Normal Redundancy ASM Disk Groups used for Clusterware files will contain three voting files regardless of the number of
- C. The Clusterware binaries may be installed without installing ASM binaries.
- D. Specifying the use of Grid Naming Service is optional.
- E. High Redundancy ASM Disk Groups used for Clusterware files will contain two OCRs.
Answer: B,D
NEW QUESTION # 53
......
Free 1z1-078 Dumps are Available for Instant Access: https://www.trainingquiz.com/1z1-078-practice-quiz.html
Based on Official Syllabus Topics of Actual Oracle 1z1-078 Exam: https://drive.google.com/open?id=1WZJE31ardRtYfuRas2zAe5iBqGrAfbe-
