[Dec 28, 2023] 1z1-078 PDF Dumps is essential on your 1z1-078 Exam Questions Certain Success!
1z1-078 PDF Questions - Perfect Prospect To Go With 1z1-078 Practice Exam
NEW QUESTION # 13
Which three statements are true about fully qualified file names in ASM? (Choose three.)
- A. They can be created only if OMF is enabled.
- B. They are system Generated at the time of ASM file creation.
- C. An alias may be created for an existing file by referring to the fully qualified file name.
- D. They are the only valid form that can be used for single file creation of a control file.
- E. They can be used to reference existing ASM files.
Answer: B,E
NEW QUESTION # 14
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 every time the instance hosting the service fails.
- B. When manually started, the service will always start on one or more available instances rather than on their preferred instances.
- C. The service must be manually restarted with SRVCTL after restarting the Clusterware stack on the node hosting the service.
- D. The service must be manually started with SRVCTL after a planned restart of the instance hosting the service.
- E. Clusterware will monitor the service while it is active.
Answer: D,E
NEW QUESTION # 15
Which four statements are true concerning the upgrading of Oracle Grid Infrastructure 19c? (Choose four.)
- A. Upgrade validation may be done using the Oracle Universal Installer which in turn invokes the built-in cluster verification utility.
- B. The upgrade must be done out-of-place.
- C. The oracle home environment variable must be set to the Grid Infrastructure home directory in the installation owner's environment.
- D. The cluster verification utility cluvfy.sh can generate fixup scripts to run on all nodes of the cluster.
- E. The upgrade must be done in-place.
- F. The cluster verification utility cluvfy.sh can verify that the cluster is ready for an upgrade.
- G. The oracle SID environment variable must be set to the SID of the ASM instance in the installation owner's environment.
Answer: A,C,D,F
NEW QUESTION # 16
Which two statements are true about node listeners in a Grid Infrastructure Cluster using ASM? (Choose two.)
- A. They listen only for database instances on the same node.
- B. They listen on behalf of any ASM instance and all database instances on the same node.
- C. They run from the Grid Infrastructure home by default.
- D. They listen only for the ASM instance on the same node.
- E. There can be only one node listener per node.
Answer: B,C
NEW QUESTION # 17
Which two statements are true concerning Oracle 19c Clusterware-managed application VIPs? (Choose two.)
- A. An application VIP is created on the default network by the appvipcfg utility.
- B. If an application sends messages to be displayed and sets the display variable, then an application VIP is required.
- C. Application VIPs do not fail over to surviving cluster nodes when the node hosting the VIP fails.
- D. An application VIP can be created with the crsccl utility.
- E. An application VIP is created on the interconnect network by the crsccl utility.
Answer: A,D
NEW QUESTION # 18
Which two steps must always be performed to delete node host04 from an Oracle 19c Clusterware cluster that does not use Grid Naming Service (GNS)? (Choose two.)
- A. Run the crsctl delete node -n host04 command as root on host01, or on either host02 or host03.
- B. Run the crsct1 unpin css - host04 command as root on host04.
- C. Run the crsctl unpin css - host04 command as root on host01, or on either host02 or host03.
- D. Run the rootcrs.pl -deconfig -force command as root on host01, or on either host02 or host03.
- E. Run the crsctl delete node -n host04 command as root on host04.
- F. Run the rootcrs.pl -deconfig -force command as root on host04.
Answer: A,F
NEW QUESTION # 19
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 cluvfy comp command for the specific resource within a component.
- B. Use the crsct1 set trace res "resource_name=debugging_level" command.
- C. Use the crsct1 set log res "resource_name=debugging_level2" command.
- D. Set the environment variable _USR_ORA_DEBUG=1 and then stop and restart the resource that requires resource debugging data to be collected.
Answer: B,D
NEW QUESTION # 20
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 # 21
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 # 22
Which three statements are true regarding ASM on a four-node cluster? (Choose three.)
- A. An ASM instance and database instances can coexist on the same node.
- B. A database instance on a node can only be a client of an ASM instance running on the same node.
- C. ASM Cluster File System (ACFS) can be deployed on any nodes.
- D. A database instance on a node cannot be a client of an ASM instance running on other 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: A,E,F
NEW QUESTION # 23
Which three statements are true about ASM Cloud File System (ACFS) replication? (Choose three.)
- A. Replication is automatically terminated if the primary file system has less than 2 GB free space.
- B. The privilege sysrepl has been introduced for ACFS replication.
- C. ACFS auditing information is replicated from the primary file system to the standby file system.
- D. Standby redo log files are required on the standby site for synchronous redo transport.
- E. One site of an ACFS replication configuration can host both primary and standby file systems.
Answer: B,C,E
NEW QUESTION # 24
Which three statements are true about ASM Cloud File System (ACFS) encryption? (Choose three.)
- A. A copy of an encrypted file is not encrypted unless it is created in an encrypted directory.
- B. acfsutil encr off can be run by an encryption manager who may not have system administrator privileges.
- C. acfsutil encr inic is used to establish role separation between encryption managers and encryption auditors.
- D. An ACFS snapshot can be ACFS encrypted.
- E. acfsucil encr on can be used to specify the encryption key length for a directory or file.
Answer: C,D,E
NEW QUESTION # 25
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 # 26
Which method should be used to convert a single-instance Oracle 19c Database to a RAC Database?
- A. Using dbca to create a template from the single-instance database and then to create a RAC database on the cluster using that template
- B. 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
- C. 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
- D. Using dbca to migrate the database to shared storage and then to start one or more RAC database instances on the cluster
Answer: D
NEW QUESTION # 27
Which three statements are true about the services created when the DBCA is used to create a RAC database? (Choose three.)
- A. Policy-managed services specified for a database allow the creation of a new server pool using dbca.
- B. They can be administrator managed for a multitenant database.
- C. They can be policy managed for a multitenant database.
- D. Singleton services are not permitted for multitenant databases.
- E. A server pool must be created with srvct1 before creating a policy-managed RAC database that uses that server pool for a service.
Answer: A,B,C
NEW QUESTION # 28
Examine this command executed on the first node of a four-node cluster:
$ < DATABASE_ORACLE_HOME >/OPatch/opatch apply 33575673
What does this command do?
- A. It applies a patch to all oracle homes with the same release only on the first cluster node.
- B. It applies a patch to all database oracle homes with the same release only on the first cluster node.
- C. It applies a patch to all database oracle homes with the same release on all cluster nodes.
- D. It applies a patch to one oracle home only on the first cluster node.
- E. It applies a patch to one database ORACLE home on alll cluster nodes.
Answer: D
NEW QUESTION # 29
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. The clusterware log files are stored inside the Grid Infrastructure Management Repository database used by the cluster health monitor
- C. The diagcolleccion.pl script must be run from the Grid home directory as the arid infrastructure owner.
- D. The oclumon utility may be used to get and set parameters for the cluster health monitor (CHM) repository.
- E. There is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
Answer: C,D
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 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 # 31
Which three statements are true concerning activation of a user-defined policy in Oracle 19c Clusterware? (Choose three.)
- A. When a policy is first created, it is initially inactive.
- B. An administrator-defined policy may be activated using the srvctl utility.
- C. When a policy is activated, resources can be automatically stopped to comply with the policy definition.
- D. When a policy is first created, it is initially active.
- E. When a policy is activated, resources cannot be automatically started to comply with the policy definition.
- F. When a policy is activated, nodes may be reassigned to server pools based on the policy definition.
Answer: A,B,C
NEW QUESTION # 32
Which three statements are true about services and load balancing for Oracle 19c clients connecting to Oracle 19c RAC database instances? (Choose three.)
- A. Services support the balancing of client connections across RAC database instances.
- B. In server-side load balancing, node listener redirects the client to another node listener for connection to an instance.
- C. Load balancing can be done by the client, the listener, or both, for any one connection request.
- 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 # 33
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 autoextend on clause to the command.
- B. lAdd the DATAFILE '/CURRENT YR/sales.dbf clause to the command.
- C. Create the current yr directory in the +data disk group.
- D. Create the current yr directory in the root directory (+).
- E. Add the DATAFILE '+DATA/CURRENT YR/sales.dbf clause to the command.
Answer: C,E
NEW QUESTION # 34
......
Oracle 1z1-078 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
| Topic 9 |
|
1z1-078 Exam with Accurate Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration PDF Questions: https://www.dumpsquestion.com/1z1-078-exam-dumps-collection.html
True Oracle Exam Extraordinary Practice For the 1z1-078 Exam: https://drive.google.com/open?id=17Cp-BaeSRBnvoyGRC7Cc31gpcKZJ2UNL