Updated Oracle 1z1-078 Dumps – Check Free 1z1-078 Exam Dumps (2024)
Updated 1z1-078 exam with Oracle Real Exam Questions
NEW QUESTION # 36
Which three resources are managed using global concurrency control in an Oracle 19c RAC multi-instance database? (Choose three.)
- A. Enqueues
- B. Mutexes
- C. Database block buffers
- D. Cursors
- E. Latches
- F. Redo log buffers
Answer: A,B,E
NEW QUESTION # 37
Which two statements are true about load balancing using a database service in a RAC environment? (Choose two.)
- A. Server-side load balancing connections are always distributed across instances based on the fastest response time for the service.
- B. Client-side connect time load balancing works only if it uses a tnsnames entry specifying load BALANCE=yes.
- C. Server-side connect time load balancing is done at the time of the initial connection attempt to the database service.
- D. Client-side connect time load balancing is done at the time of the initial connection attempt to the database service.
- E. 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.
Answer: C,D
NEW QUESTION # 38
Which three statements are true about ASM Cloud File System (ACFS) auditing? (Choose three.)
- A. Audit information gathered by each cluster node can be consolidated into the unified ACFS audit trail.
- B. acfsutil audit read marks audit files to indicate that it is safe to purge them.
- C. acfsutil audit purge can be run by an audit manager.
- D. acfsutil audit archive must be used to archive audit files that are larger than 10 MB.
- E. acfsutil audit init must be run by a system administrator.
Answer: A,C,E
NEW QUESTION # 39
Which two statements are true about High Availability NFS (HANFS)? (Choose two.)
- A. HANFS' performance depends on the characteristics of the underlying ASM disks.
- B. HANFS provides high availability in case of an NFS client failure.
- C. HANFS provides high availability in case of cluster node failure.
- D. HANFS does not depend on NFS services provided by the underlying operating system.
- E. NFS client requests are distributed by DNS in a round-robin fashion to the cluster nodes that export the NFS
Answer: A,C
NEW QUESTION # 40
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. lAdd the DATAFILE '/CURRENT YR/sales.dbf clause to the command.
- B. Add the DATAFILE '+DATA/CURRENT YR/sales.dbf clause to the command.
- C. Add the autoextend on clause to the command.
- D. Create the current yr directory in the root directory (+).
- E. Create the current yr directory in the +data disk group.
Answer: B,E
NEW QUESTION # 41
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. a resource dependency definition
- B. an application resource
- C. an application VIP
- D. A Server Pool
- E. a script agent
Answer: B,E
NEW QUESTION # 42
Which two statements are true concerning diagnostic components and requirements of Oracle 19c Clusterware? (Choose two.)
- A. The oclumon utility may be used to get and set parameters for the cluster health monitor (CHM) repository.
- B. There is one ologgerd service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
- C. There is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
- 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: A,D
NEW QUESTION # 43
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 or the listener, but not both, for any one connection request.
- B. Client-side connect-time load balancing can balance connection requests across SCAN listeners.
- C. Load balancing can be done by the client, the listener, or both, for any one connection request.
- D. In server-side load balancing, node listener redirects the client to another node listener for connection to an instance.
- E. Services support the balancing of client connections across RAC database instances.
Answer: C,D,E
NEW QUESTION # 44
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 for ERP across all database instances running on servers in the prod pool
- B. High availability for the CRM service
- C. Load balancing of client connection requests for ERP across three Single Client Access Name (SCAN) listeners
- D. Load balancing of client connection requests for CRM across four Single Client Access Name (SCAN) listeners
- E. High availability for the ERP service
- F. Load balancing of connection requests for CRM across all database instances running on servers in the prod pool
- G. Load balancing of connection requests across all six database instances
Answer: B,D,E,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 fails because an ASM instance is not configured to run on HOST02.
- B. It succeeds and starts an ASM instance on HOST02 but the ASM instance on HOST03 is not shut down until all connected clients disconnect.
- C. It succeeds and starts an ASM instance on HOST02 and shuts down the ASM instance on HOST03.
- D. It succeeds and 19c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST02.
- E. It fails because the ASM instance has not been shut down first on HOST03.
- F. It succeeds and 19c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST01.
Answer: A,B,D
NEW QUESTION # 46
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 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.
- C. Transparent Application Continuity is enabled when failover type=All
- D. Transparent Application Continuity is enabled when failover type=auto.
- E. Recovery of the user database session is done safely by enabling auto recover within the user database session.
Answer: A,D
NEW QUESTION # 47
Which two methods exist for enabling the collection of additional resource debugging information for specific resources controlled by Oracle 19c Clusterware? (Choose two.)
- A. Use the crsct1 set log res "resource_name=debugging_level2" command.
- B. Use the cluvfy comp command for the specific resource within a component.
- C. Set the environment variable _USR_ORA_DEBUG=1 and then stop and restart the resource that requires resource debugging data to be collected.
- D. Use the crsct1 set trace res "resource_name=debugging_level" command.
Answer: C,D
NEW QUESTION # 48
Which three events occur when a node fails in an Oracle Clusterware 19c Cluster? (Choose three.)
- A. Cluster Resources running on the failed node are suspended until the node is restarted.
- B. Sessions connected to the failed node could be relocated to one or more surviving nodes.
- C. Cluster Resources running on the failed node are relocated to one or more surviving hub nodes.
- D. The node is evicted from the cluster
- E. Cluster resources running on the failed node must be recovered when the node is restarted.
Answer: B,C,D
NEW QUESTION # 49
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 stop crs
- C. crsctl config crs
- D. crsctl stop cluster
Answer: A,B
NEW QUESTION # 50
Which three statements are true about fully qualified file names in ASM? (Choose three.)
- A. They are the only valid form that can be used for single file creation of a control file.
- B. They can be created only if OMF is enabled.
- C. They can be used to reference existing ASM files.
- D. They are system Generated at the time of ASM file creation.
- E. An alias may be created for an existing file by referring to the fully qualified file name.
Answer: C,D,E
NEW QUESTION # 51
Which two statements are true concerning Oracle 19c Clusterware-managed application VIPs? (Choose two.)
- A. An application VIP can be created with the crsccl utility.
- B. An application VIP is created on the default network by the appvipcfg utility.
- C. If an application sends messages to be displayed and sets the display variable, then an application VIP is required.
- D. Application VIPs do not fail over to surviving cluster nodes when the node hosting the VIP fails.
- E. An application VIP is created on the interconnect network by the crsccl utility.
Answer: A,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 srvctl stop vip to stop the VIP on host01.
- B. Use srvctl modify nodeapps to change the VIP on host01.
- C. Use oifcfg setif to stop the VIP on host01.
- D. Use oifcfg setif to start the VIP on host01.
- E. Use srvctl start vip to start the VIP on host01.
Answer: A,B,C
NEW QUESTION # 53
Which two statements are true about resources defined by an administrator and registered with Oracle 19c Clusterware for high availability? (Choose two.)
- A. The action script is automatically set when using a policy-managed resource.
- B. An administrator-managed resource can be started manually using crsct1.
- C. A policy-managed resource can be started manually using crsct1.
- D. A policy-managed resource can be started manually using srvct1.
- E. Resource dependencies are automatically set when using a policy-managed resource.
- F. An administrator-managed resource can be started manually using srvct1.
Answer: B,C
NEW QUESTION # 54
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 (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.
- 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. 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.
- D. 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.
- E. 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.
Answer: A,B
NEW QUESTION # 55
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. All the instances must have the same number of redo log groups and each group must have the same number of redo log members.
- B. A redo log group added using alter database add logfile without the instance clause is added to each instance.
- C. A thread of redo is automatically dropped when an instance is removed from a RAC database by using SRVCTL.
- 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 # 56
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. 2 = NORMAL, 3 = TRANSACTIONAL, 1 = ABORT
- C. 3 = NORMAL, 2 = IMMEDIATE, 1 = ABORT
- D. 3 = NORMAL, 2 = TRANSACTIONAL, 1 = ABORT
- E. 2 = NORMAL, 3 = IMMEDIATE, 1 = ABORT
Answer: A,C
NEW QUESTION # 57
Which statement is true concerning the installation of an Oracle Grid Infrastructure 19c patchset and its status during the installation?
- A. They can be applied in-place.
- B. Some Grid Infrastructure patchsets may not be intalled in a rolling fashion.
- C. When performing rolling patches, crsctl query crs softwareversion always displays the earliest version of the software running anywhere in the cluster.
- D. When performing rolling patches, the vips for the node being patched are relocated to another node.
Answer: B
NEW QUESTION # 58
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 group to own the software inventory
- 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 user to own the Clusterware installation and a different O/S user own the Automatic Storage Management (ASM) installation
- E. an O/S group called dba
- F. an O/S user to own the Grid Infrastructure installation
Answer: A,F
NEW QUESTION # 59
......
Oracle 1z1-078 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
Actual 1z1-078 Exam Recently Updated Questions with Free Demo: https://www.certkingdompdf.com/1z1-078-latest-certkingdom-dumps.html