[Mar 16, 2024] Fully Updated 1z1-078 Dumps - 100% Same Q&A In Your Real Exam
Latest 1z1-078 Exam Dumps - Valid and Updated Dumps
NEW QUESTION # 36
Oracle Clusterware manages an administrator-managed database service defined with the MANUAL management policy.
Which two statements are true? (Choose two.)
- A. Clusterware will monitor the service while it is active.
- B. The service must be manually restarted with SRVCTL after restarting the Clusterware stack on the node hosting the service.
- C. When manually started, the service will always start on one or more available instances rather than on their preferred instances.
- D. The service must be manually started with SRVCTL after a planned restart of the instance hosting the service.
- E. The service must be manually restarted with SRVCTL every time the instance hosting the service fails.
Answer: A,D
NEW QUESTION # 37
Examine this query and output:
Performance analysis revealed severe SQ enqueue contention on the SEQ1 sequence.
The SEQ1 sequence is incremented from all instances equally and is frequently used.
Which two statements should you execute to reduce SQ enqueue contention? (Choose two.)
- A. alter sequence seql keep;
- B. alter sequence seql noorder;
- C. exec sys.dbms shared pool.keep('SEQ1','Q'>
- D. alter sequence seal cache 10000;
- E. alter sequence seql order;
Answer: B,D
NEW QUESTION # 38
Which three resources are managed using global concurrency control in an Oracle 19c RAC multi-instance database? (Choose three.)
- A. Database block buffers
- B. Redo log buffers
- C. Cursors
- D. Latches
- E. Mutexes
- F. Enqueues
Answer: D,E,F
NEW QUESTION # 39
Which two statements are true about load balancing using a database service in a RAC environment? (Choose two.)
- A. Server-side connect time load balancing is done at the time of the initial connection attempt to the database service.
- B. Client-side connect time load balancing works only if it uses a tnsnames entry specifying load BALANCE=yes.
- C. 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.
- D. Client-side connect time load balancing is done at the time of the initial connection attempt to the database service.
- E. Server-side load balancing connections are always distributed across instances based on the fastest response time for the service.
Answer: A,D
NEW QUESTION # 40
Which three statements are true regarding multitenant architecture for RAC databases? (Choose three.)
- A. PDBs can have local temporary
- B. PDBs must use shared Temporary
- C. One undo tablespace for each pdb is required.
- D. You can open one, several, or all PD3s on one, several, or all cdb instances.
- E. One undo tablespace for each instance is required.
- F. It requires the cdb to use shared undo management.
Answer: A,D,F
NEW QUESTION # 41
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 oifcfg setif to start the VIP on host01.
- B. Use srvctl start vip 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 # 42
Which two methods exist for enabling the collection of additional resource debugging information for specific resources controlled by Oracle 19c Clusterware? (Choose two.)
- A. Set the environment variable _USR_ORA_DEBUG=1 and then stop and restart the resource that requires resource debugging data to be collected.
- B. Use the cluvfy comp command for the specific resource within a component.
- C. Use the crsct1 set log res "resource_name=debugging_level2" command.
- D. Use the crsct1 set trace res "resource_name=debugging_level" command.
Answer: A,D
NEW QUESTION # 43
You performed these steps to disable an ADVM volume containing an ACFS file system:
1. Dismount the file system.
2. Disable the volume with the ASMCMD voldisable command.
Which two statements are true regarding the actions performed? (Choose two.)
- A. The disabling of volume does not destroy data in the file system.
- B. The ACFS file system will be permanently removed from the volume.
- C. The volume can be enabled and the file system can be mounted back again to access the existing data.
- D. The ACFS mount registry with Oracle restart is automatically deleted.
- E. The ACFS file system will be permanently removed from the volume only if the file system is empty.
Answer: A,C
NEW QUESTION # 44
Which two statements are true concerning the installation of Oracle Grid Infrastructure 19c Cluster? (Choose two.)
- A. High Redundancy ASM Disk Groups used for Clusterware files will contain two OCRs.
- 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. The Grid Infrastructure Management Repository is only required when using ASM.
- E. Specifying the use of Grid Naming Service is optional.
Answer: B,E
NEW QUESTION # 45
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. All server pools in a cluster are controlled by the policy set, when user-defined policy 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. 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. A server pool can have the same attributes defined for different policies in the policy set, when user-defined policy management is used.
Answer: B,C,E
NEW QUESTION # 46
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 and 6.
- B. 1, 2, 3 and 4.
- C. 2, 3, 4, 5 and 6.
- D. 2, 3, 4 and 6.
- E. 1, 2, 3, 4, 5 and 6.
- F. 1, 2, 3, 4, 5, 6 and 7.
Answer: B
NEW QUESTION # 47
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 user to own the Grid Infrastructure installation
- B. an O/S group called dba
- C. A group to own Automatic Storage Management (ASM) Filter Driver-provisioned storage
- D. an O/S group to own the software inventory
- E. an 0/S user to own the Oracle Database 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: A,D
NEW QUESTION # 48
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 database, there is no LMDO process if only one instance is running.
- C. Global Enqueues may have converters and waiters in the same instance.
- D. Global Enqueues and Instance Locks replace latches completely in RAC database instances.
- E. Global Enqueues may have owners and waiters in the same instance.
- F. In a RAC One Node database, there is no LMD) process if only one instance is running.
Answer: B,E
NEW QUESTION # 49
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. The node is evicted from the cluster
- 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. Sessions connected to the failed node could be relocated to one or more surviving nodes.
Answer: B,D,E
NEW QUESTION # 50
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. 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.
- C. 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.
- 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 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.
- E. 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.
Answer: E
NEW QUESTION # 51
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 downgraded to a SCUR image for shipping to another instance until commits occur for updated rows on the block.
- B. A CR image may get served from one instance to another to satisfy a read request.
- C. An xcur block image may exist for a specific database block in only one instance.
- D. An xcur image is not shipped to another instance until commits occur for updated rows on the block.
- E. A Pi block image may exist for a specific database block in only one instance.
Answer: B,C
NEW QUESTION # 52
Which three statements are true about the services created when the DBCA is used to create a RAC database? (Choose three.)
- A. They can be administrator managed for a multitenant database.
- 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. Policy-managed services specified for a database allow the creation of a new server pool using dbca.
- E. They can be policy managed for a multitenant database.
Answer: A,D,E
NEW QUESTION # 53
Examine the output of this command:
The ACFS disk group is a normal redundancy disk group with 5 GB of free space.
To increase the size of the ACFS file system, you execute this command as the root user:
$ /sbin/acfsutil size +200M /u01/app/grid/acfsmount
Which two statements are true regarding the outcome of this command? (Choose two.)
- A. It resizes voli.
- B. It succeeds but leaves the file system unmounted.
- C. It fails to resize the filesystem because it must be unmounted before resizing.
- D. It fails to resize voli because it must be executed as a user belonging to the sysasm group.
- E. It resizes the filesystem mounted on /u01/app/grid/acfsmount.
Answer: A,E
NEW QUESTION # 54
......
Free Sales Ending Soon - 100% Valid 1z1-078 Exam: https://www.actualtestsquiz.com/1z1-078-test-torrent.html
Verified 1z1-078 Exam Questions Certain Success: https://drive.google.com/open?id=1SgaRkH1aV8Z2Mcg7JNeNz5FwppfwzDJ7
