Pass Your Oracle Database 1z1-078 Exam on May 09, 2024 with 79 Questions
1z1-078 Free Exam Study Guide! (Updated 79 Questions)
Oracle 1z1-078 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
NEW QUESTION # 28
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 on any one available CDBl instance in prod pool at any one time.
- C. AR can fail over to any one of the available CD31 instances.
- D. AR is available only on the CDBl instance on host01.
- E. AR runs as a singleton service in the server pool prod pool and the AR service is available in each of the CDBl instances.
Answer: A,B
NEW QUESTION # 29
Examine this command:
Which two statements are true about this disk group, created using Grid Infrastructure 19c? (Choose two.)
- A. Any database instance with the COMPATIBLE parameter set to 12.2 or later can access it.
- B. It can contain ASM Dynamic Volume Manager (ADVM) volumes.
- C. Each disk in each of the three fail groups is a mirror of the corresponding disk of the other two failure groups.
- D. Files created in this disk group always have two copies for each allocation unit: one primary and one secondary.
- E. The ASM compatible attributes can be changed to 12. l for this disk group.
Answer: A,B
NEW QUESTION # 30
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 the filesystem mounted on /u01/app/grid/acfsmount.
- B. It fails to resize the filesystem because it must be unmounted before resizing.
- C. It succeeds but leaves the file system unmounted.
- D. It fails to resize voli because it must be executed as a user belonging to the sysasm group.
- E. It resizes voli.
Answer: A,E
NEW QUESTION # 31
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 # 32
Which three statements are true about the Oracle Clusterware 19c Flex Cluster architecture? (Choose three.)
- A. Each hub node must be connected to storage shared across all hub nodes.
- B. Hub nodes require direct access to the OCR file.
- C. Each leaf node must be connected to storage shared across all cluster nodes.
- D. Leaf nodes require direct access to the voting disks.
- E. Hub nodes require direct access to the voting disks.
- F. Each leaf node must be connected to storage shared across all leaf nodes.
Answer: A,B,E
NEW QUESTION # 33
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, the listener, or both, for any one connection request.
- B. Services support the balancing of client connections across RAC database instances.
- C. In server-side load balancing, node listener redirects the client to another node listener for connection to an instance.
- D. Load balancing can be done by the client or the listener, but not both, for any one connection request.
- E. Client-side connect-time load balancing can balance connection requests across SCAN listeners.
Answer: A,B,C
NEW QUESTION # 34
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. When performing rolling patches, crsctl query crs softwareversion always displays the earliest version of the software running anywhere in the cluster.
- C. When performing rolling patches, the vips for the node being patched are relocated to another node.
- D. Some Grid Infrastructure patchsets may not be intalled in a rolling fashion.
Answer: D
NEW QUESTION # 35
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 # 36
Examine this command and output:
Examine this command:
Which statement must be true for the successful execution of the second command?
- A. The underlying advm volume must be configured with high redundancy.
- B. The disk group compatibility attribute for advm must be set to 12. l or higher.
- C. The parent snapshot must be read-only.
- D. The parent snapshot must be read/write.
Answer: C
NEW QUESTION # 37
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 # 38
A cluster running 19c Grid Infrastructure supports both Oracle 11g to 19c RAC databases using ASM.
The COMPATIBLE.ASM, COMPATIBLE.RDBMS, and COMPATIBLE.ADVM parameters are currently set to 11.2 for all diskgroups..
You must support these capabilities in all diskgroups:
1. ACFS Replication
2. ACFS Encryption
To what minimum values must the compatible attributes be set?
- A. Set COMPATIBLE.ASM to 12.1, COMPATIBLE.RDBMS to 11.2, and COMPATIBLE.ADVM to 12.1.
- B. Set COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 11.2, and COMPATIBLE.ADVM to 11.2.
- C. Set COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 11.2.
- D. Set COMPATIBLE.ASM to 12.1, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 12.1.
- E. Set COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 12.1
Answer: D
NEW QUESTION # 39
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 # 40
Which method should be used to convert a single-instance Oracle 19c Database to a RAC Database?
- A. Using the rconfig utility to create a template from the single-instance database and then using dbca to create a RAC database on the cluster using that template
- B. Using dbca to create a template from the single-instance database and then to create a RAC database on the cluster using that template
- C. Using dbca to migrate the database to shared storage and then to start one or more RAC database instances on the cluster
- D. Using the rconfig utility to migrate the database to shared storage and then using dbca to start one or more RAC database instances on the cluster
Answer: C
NEW QUESTION # 41
Which two statements are true about server categorization in Oracle 19c Clusterware? (Choose two.)
- A. A server may be added to only one category using the crsctl utility.
- B. All nodes in a cluster belong to the same Oracle-supplied category.
- C. All server attributes that may be used to determine the server category are discovered automatically by Oracle Clusterware.
- D. Different nodes in a cluster may belong to separate administrator-defined categories.
- E. All server attributes used for categorization are administrator modifiable.
- F. Server categories can only be used for nodes running an application server.
Answer: A,D
NEW QUESTION # 42
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 # 43
Which two statements are true about v$asm- views in a clustered environment? (Choose two.)
- A. Their names can be seen in v$fixed_table when connected to an instance of any type that is started.
- B. They exist in both ASM and RDBMS instances, and display the same output.
- C. gv$asm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in the cluster.
- D. They exist in both ASM and RDBMS instances, but they can display different outputs depending on the instance type.
- E. Their names can be seen in dice when connected to an ASM instance.
Answer: C,D
NEW QUESTION # 44
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 # 45
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. It is necessary to assign a specific undo tablespace to a specific instance.
- C. You can dynamically assign a newly created undo tablespace to an instance.
- D. A mixture of automatic undo management and manual undo management is supported within a RAC database.
- E. An instance that performs instance recovery can write to the undo tablespace of a failed instance.
Answer: A,C,E
NEW QUESTION # 46
Which two statements are true concerning diagnostic components and requirements of Oracle 19c Clusterware? (Choose two.)
- A. There is one ologgerd service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
- B. There is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
- C. The diagcolleccion.pl script must be run from the Grid home directory as the arid infrastructure owner.
- D. The clusterware log files are stored inside the Grid Infrastructure Management Repository database used by the cluster health monitor
- E. The oclumon utility may be used to get and set parameters for the cluster health monitor (CHM) repository.
Answer: C,E
NEW QUESTION # 47
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. Add the DATAFILE '+DATA/CURRENT YR/sales.dbf clause to the command.
- B. Create the current yr directory in the +data disk group.
- C. lAdd the DATAFILE '/CURRENT YR/sales.dbf clause to the command.
- D. Add the autoextend on clause to the command.
- E. Create the current yr directory in the root directory (+).
Answer: A,B
NEW QUESTION # 48
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. The DB_CREATE_FILE_DEST parameter must be set to +DATA(newtemplate).
- C. newtemplate must be defined for the +DATA disk group.
- D. The +DATA disk group should not be part of Flex ASM.
- E. User-defined subdirectories ORCL and USERS must already exist.
Answer: C,E
NEW QUESTION # 49
Which three statements are true about an Oracle Database RAC software installation? (Choose three.)
- A. SSH user equivalence for the Oracle user can be set up before the software installation.
- B. The software must be installed on all nodes in the cluster.
- C. Fix-up scripts generated during the installation must be run as root on UNIX platforms.
- D. RAC installations require Oracle Enterprise Edition.
- E. The software must be installed into a cluster file system.
- F. The software must be installed into a local file system on each node.
- G. The software can be installed into an ACFS file system.
Answer: A,C,D
NEW QUESTION # 50
Which three statements are true about Quality of Service Management (QoS)? (Choose three.)
- A. It requires Oracle Grid Infrastructure for a Cluster to be installed and Clusterware to be running.
- B. A server pool can be managed by QoS even if it does have database instances running on any server in the pool.
- C. It supports multiple databases assigned to the same server pool.
- D. It can manage database services only if they are defined as UNIFORM services.
- E. Databases managed by QoS can be administrator managed or policy managed.
Answer: A,C,E
NEW QUESTION # 51
Which three statements are true about the Global Resource Directory (GRD) in Oracle 19c RAC database and in Clustered ASM? (Choose three.)
- A. RAC databases have GRD cache resources distributed among all the database instances and stored in the large pool of each instance.
- B. Clustered ASM has GRD resources distributed among all ASM instances.
- C. All GRD Enqueue Resource master metadata is held in the shared pool of the same database instance.
- D. All GRD Enqueue Resource master metadata is held in the large pool of the same database instance.
- E. Only one GRD shadow resource may exist for an Enqueue Resource.
- F. Shadow GRD resources may exist in more than one database instance for a resource.
- G. RAC databases have GRD cache resources distributed among all the database instances and stored in the shared pool of each instance.
Answer: A,B,F
NEW QUESTION # 52
......
1z1-078 Dumps for Oracle Database Certified Exam Questions and Answer: https://passguide.dumpexams.com/1z1-078-vce-torrent.html