Free 1z0-078 Braindumps Download Updated on Dec 30, 2023 with 80 Questions
Oracle 1z0-078 Exam Practice Test Questions
Oracle 1z0-078 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
| Topic 9 |
|
| Topic 10 |
|
| Topic 11 |
|
NEW QUESTION # 13
Which three resources are managed using global concurrency control in an Oracle 19c RAC multi-instance database? (Choose three.)
- A. Redo log buffers
- B. Latches
- C. Cursors
- D. Enqueues
- E. Database block buffers
- F. Mutexes
Answer: B,D,F
NEW QUESTION # 14
Which two benefits are obtained by using Affinity to reduce global resource contention? (Choose two.)
- A. Oracle RAC affinity for partitioned tables routes database requests to Oracle RAC instances in such a way that each instance always gets requests for a disjoint subset of rows in the database, this affinity leads to higher Oracle RAC performance and scalability because of improved cache locality and reduced internode synchronization and block pings.
- B. Oracle RAC affinity for partitioned tables routes all database requests for a partition tables to a single Oracle RAC instance leading to higher Oracle RAC performance and scalability because of improved cache locality and reduced internode synchronization and block pings of the partition tables.
- C. To enhance the performance of distributed transactions with applications server that provides XA affinity, you can direct all branches of a distributed transaction to a single instance in the cluster to improve cache locality and reduce internode synchronization and block pings.
- D. Oracle RAC affinity for partitioned tables routes database requests to all available Oracle RAC instances evenly to create a global affinity in such a way that each instance always gets an even number of requests leading to higher Oracle RAC performance by using a higher levels of available global cache to reduce global resource contention.
- E. To enhance the performance of distributed transactions with applications server that provides XA affinity, you can automatically spawn new dedicated database RAC instances to isolate distributed transaction.
Answer: B,C
NEW QUESTION # 15
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 instance startup.
- C. Oracle RAC Resource Management only allows assignment of the SGA during database startup.
- D. Oracle RAC Resource Runtime Management allows for automatic and runtime adjustment of the SGA.
Answer: D
NEW QUESTION # 16
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. a script agent
- D. an application VIP
- E. A Server Pool
Answer: B,C
NEW QUESTION # 17
Which three statements are true about undo management in a RAC environment? (Choose three.)
- A. A mixture of automatic undo management and manual undo management is supported within a RAC database.
- 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. An instance that performs instance recovery can write to the undo tablespace of a failed instance.
- E. You can dynamically assign a newly created undo tablespace to an instance.
Answer: C,D,E
NEW QUESTION # 18
Examine this command:
Which two statements are true about this disk group, created using Grid Infrastructure 19c? (Choose two.)
- A. The ASM compatible attributes can be changed to 12. l for this disk group.
- B. It can contain ASM Dynamic Volume Manager (ADVM) volumes.
- C. Any database instance with the COMPATIBLE parameter set to 12.2 or later can access it.
- D. Files created in this disk group always have two copies for each allocation unit: one primary and one secondary.
- E. Each disk in each of the three fail groups is a mirror of the corresponding disk of the other two failure groups.
Answer: B,C
NEW QUESTION # 19
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 ACFS file system will be permanently removed from the volume.
- B. The ACFS file system will be permanently removed from the volume only if the file system is empty.
- 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 disabling of volume does not destroy data in the file system.
Answer: C,E
NEW QUESTION # 20
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 relocate to an available instance when the service is stopped on a preferred instance.
- C. 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.
- 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 # 21
Examine this command:
SQL> CREATE PLUGGABLE DATABASE pdb3 FROM pdb1;
Which three conditions must be true for successful execution of this command on a RAC database? (Choose three.)
- A. It can be executed only by a common user with the create pluggable database system privilege connected to the root container.
- B. All running CDB instances must be open in restricted mode.
- C. Oracle Managed Files must be enabled or PD3 file name convert must be set.
- D. The source PD3 must be closed on the CDS instance from where the command is executed.
- E. The source pdb must use a global temporary
- F. The source PD3 must be in read only mode on all CD3 instances if the CDB is in No Archive mode.
Answer: A,C,D
NEW QUESTION # 22
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 runs as a singleton service in the server pool prod pool and the AR service is available in each of the CDBl instances.
- B. AR is available on any one available CDBl instance in prod pool at any one time.
- C. AR can fail over to any other available CDBl instance in prod pool.
- D. AR can fail over to any one of the available CD31 instances.
- E. AR is available only on the CDBl instance on host01.
Answer: B,C
NEW QUESTION # 23
Which three statements are true regarding multitenant architecture for RAC databases? (Choose three.)
- A. PDBs must use shared Temporary
- B. One undo tablespace for each instance is required.
- C. PDBs can have local temporary
- D. It requires the cdb to use shared undo management.
- E. You can open one, several, or all PD3s on one, several, or all cdb instances.
- F. One undo tablespace for each pdb is required.
Answer: C,D,E
NEW QUESTION # 24
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 the same attributes defined for different policies in 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. All server pools in a cluster are controlled by the policy set, when user-defined policy management is used.
- E. 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.
Answer: B,C,D
NEW QUESTION # 25
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. The Grid Infrastructure Management Repository is only required when using ASM.
- C. Specifying the use of Grid Naming Service is optional.
- D. The Clusterware binaries may be installed without installing ASM binaries.
- E. Normal Redundancy ASM Disk Groups used for Clusterware files will contain three voting files regardless of the number of
Answer: C,E
NEW QUESTION # 26
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 modify nodeapps to change the VIP on host01.
- C. Use srvctl start vip to start the VIP on host01.
- D. Use srvctl stop vip to stop the VIP on host01.
- E. Use oifcfg setif to stop the VIP on host01.
Answer: B,D,E
NEW QUESTION # 27
Which three statements are true about ASM Cloud File System (ACFS) auditing? (Choose three.)
- A. acfsutil audit archive must be used to archive audit files that are larger than 10 MB.
- B. acfsutil audit purge can be run by an audit manager.
- C. acfsutil audit read marks audit files to indicate that it is safe to purge them.
- D. acfsutil audit init must be run by a system administrator.
- E. Audit information gathered by each cluster node can be consolidated into the unified ACFS audit trail.
Answer: B,D,E
NEW QUESTION # 28
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 fails to resize the filesystem because it must be unmounted before resizing.
- C. It fails to resize voli because it must be executed as a user belonging to the sysasm group.
- D. It resizes the filesystem mounted on /u01/app/grid/acfsmount.
- E. It succeeds but leaves the file system unmounted.
Answer: A,D
NEW QUESTION # 29
Examine this command:
Which two statements are required for this command to succeed? (Choose two.)
- A. The DB_CREATE_FILE_DEST parameter must be set to +DATA(newtemplate).
- B. The +DATA disk group should not be part of Flex ASM.
- C. newtemplate must be defined for the +DATA disk group.
- D. Existing data files in TBS1 must also use the same template.
- E. User-defined subdirectories ORCL and USERS must already exist.
Answer: C,E
NEW QUESTION # 30
......
Updated Verified 1z0-078 dumps Q&As - Pass Guarantee or Full Refund: https://www.guidetorrent.com/1z0-078-pdf-free-download.html
Updated Certification Exam 1z0-078 Dumps - Practice Test Questions: https://drive.google.com/open?id=1p7hw80iHIC2-pfNadmb5vdnmNwRcyppN