Pass Authentic Oracle 1z0-078 with Free Practice Tests and Exam Dumps
New 1z0-078 Exam Questions Real Oracle Dumps
Oracle 1z0-078 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
NEW QUESTION # 20
Which two operating system users and groups must be created on each node before installing Oracle Grid Infrastructure 19c? (Choose two.)
- A. A group to own Automatic Storage Management (ASM) Filter Driver-provisioned storage
- B. an O/S user to own the Clusterware installation and a different O/S user own the Automatic Storage Management (ASM) installation
- C. an O/S group called dba
- D. an 0/S user to own the Oracle Database installation
- E. an O/S user to own the Grid Infrastructure installation
- F. an O/S group to own the software inventory
Answer: E,F
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 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. In a policy-managed RAC database, an undo tablespace may automatically be created if OMF is enabled for the database.
- C. An instance that performs instance recovery can write to the undo tablespace of a failed instance.
- D. You can dynamically assign a newly created undo tablespace to an instance.
- E. It is necessary to assign a specific undo tablespace to a specific instance.
Answer: B,C,D
NEW QUESTION # 23
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. 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.
- B. 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.
- C. 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.
- 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 # 24
Identify three prerequisites for the successful installation of Oracle Grid Infrastructure 19c when using Full Featured Grid Naming Service (GNS). (Choose three.)
- A. You must create a Grid Management Repository database.
- B. Each cluster node must have at least two network interface cards.
- C. You must enable the Name Server Cache Daemon
- D. A DHCP service on the private network for the cluster is required to allocate virtual IP addresses for HAIP.
- E. DNS must be configured to delegate name resolution for the cluster subdomain to the cluster.
- F. A DHCP service on the public network for the cluster is required to allocate virtual IP addresses as required by the cluster.
Answer: C,E,F
NEW QUESTION # 25
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 interconnect network by the crsccl utility.
- C. Application VIPs do not fail over to surviving cluster nodes when the node hosting the VIP fails.
- D. An application VIP is created on the default network by the appvipcfg utility.
- E. If an application sends messages to be displayed and sets the display variable, then an application VIP is required.
Answer: A,D
NEW QUESTION # 26
Which three statements are true regarding ASM on a four-node cluster? (Choose three.)
- A. A database instance on a node uses an ASM instance as an I/O server when requesting I/O to diskgroups.
- 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. An ASM instance and database instances can coexist on the same node.
- E. A database instance on a node cannot be a client of an ASM instance running on other nodes.
- F. A database instance on a node can be a client of an ASM instance running on any node.
Answer: A,D,F
NEW QUESTION # 27
Which three statements are true about an Oracle Database RAC software installation? (Choose three.)
- A. The software must be installed on all nodes in the cluster.
- B. The software must be installed into a cluster file system.
- C. SSH user equivalence for the Oracle user can be set up before the software installation.
- D. The software can be installed into an ACFS file system.
- E. RAC installations require Oracle Enterprise Edition.
- F. Fix-up scripts generated during the installation must be run as root on UNIX platforms.
- G. The software must be installed into a local file system on each node.
Answer: C,E,F
NEW QUESTION # 28
Examine this command:
Which two statements are required for this command to succeed? (Choose two.)
- A. User-defined subdirectories ORCL and USERS must already exist.
- B. newtemplate must be defined for the +DATA disk group.
- C. The DB_CREATE_FILE_DEST parameter must be set to +DATA(newtemplate).
- D. The +DATA disk group should not be part of Flex ASM.
- E. Existing data files in TBS1 must also use the same template.
Answer: A,B
NEW QUESTION # 29
Which statement is true concerning the installation of an Oracle Grid Infrastructure 19c patchset and its status during the installation?
- A. Some Grid Infrastructure patchsets may not be intalled in a rolling fashion.
- B. They can be applied in-place.
- 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: A
NEW QUESTION # 30
Which three statements are true about the administration and use of policy sets in Oracle 19c Clusterware? (Choose three.)
- A. All server pools in a cluster are controlled by the policy set, when user-defined policy 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. Clusterware administrators cannot directly modify the policy set when Quality of Service (QoS) Management is used.
- D. A server pool can have different attributes defined for different policies in 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: A,B,D
NEW QUESTION # 31
Which three statements are true about ASM Cloud File System (ACFS) auditing? (Choose three.)
- A. acfsutil audit init must be run by a system administrator.
- B. acfsutil audit archive must be used to archive audit files that are larger than 10 MB.
- C. acfsutil audit read marks audit files to indicate that it is safe to purge them.
- D. Audit information gathered by each cluster node can be consolidated into the unified ACFS audit trail.
- E. acfsutil audit purge can be run by an audit manager.
Answer: A,D,E
NEW QUESTION # 32
Which two statements are true about High Availability NFS (HANFS)? (Choose two.)
- A. HANFS does not depend on NFS services provided by the underlying operating system.
- B. HANFS provides high availability in case of cluster node failure.
- C. NFS client requests are distributed by DNS in a round-robin fashion to the cluster nodes that export the NFS
- D. HANFS provides high availability in case of an NFS client failure.
- E. HANFS' performance depends on the characteristics of the underlying ASM disks.
Answer: B,E
NEW QUESTION # 33
Which two tasks must be performed before launching the Oracle universal installer to install Oracle Database Software for RAC? (Choose two.)
- A. The Clusterware stack must be up on all cluster nodes.
- B. ssh user equivalence for the Oracle software owner must be configured on all cluster nodes where the Database software will be installed.
- C. The Clusterware stack must be up on all cluster nodes where the Database software will be installed.
- D. Grid Infrastructure must be installed on all cluster nodes.
- E. SSH user equivalence for the Oracle software owner must be configured on all cluster nodes.
- F. Grid Infrastructure must be installed on all cluster nodes where the Database software will be installed.
Answer: B,D
NEW QUESTION # 34
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 only on the CDBl instance on host01.
- C. AR is available on any one available CDBl instance in prod pool at any one time.
- D. AR can fail over to any other available CDBl instance in prod pool.
- E. AR can fail over to any one of the available CD31 instances.
Answer: C,D
NEW QUESTION # 35
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 automatically registered in the OCR.
- C. It is not automatically registered in the OCR.
- D. It is created and started on only one instance when using policy-managed database configuration.
- E. It cannot be used to automate the opening of the PDB by the Clusterware.
Answer: B
NEW QUESTION # 36
Which three statements are true concerning Automatic Database Diagnostic Monitor (ADDM) for RAC? (Choose three.)
- A. It runs automatically in Instance ADDM mode after each AWR snapshot is created.
- B. It can analyze performance over any given time period.
- C. It can analyze performance using data captured on all instances.
- D. It can only analyze performance on the instance running the ADDM job.
- E. It can diagnose skew in response time.
- F. It can diagnose latency problems in the Cluster Interconnect.
Answer: B,C,E
NEW QUESTION # 37
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. Create the current yr directory in the root directory (+).
- B. Create the current yr directory in the +data disk group.
- C. Add the autoextend on clause to the command.
- D. lAdd the DATAFILE '/CURRENT YR/sales.dbf clause to the command.
- E. Add the DATAFILE '+DATA/CURRENT YR/sales.dbf clause to the command.
Answer: B,E
NEW QUESTION # 38
Which two statements are true concerning diagnostic components and requirements of Oracle 19c Clusterware? (Choose two.)
- A. The diagcolleccion.pl script must be run from the Grid home directory as the arid infrastructure owner.
- B. The oclumon utility may be used to get and set parameters for the cluster health monitor (CHM) repository.
- C. The clusterware log files are stored inside the Grid Infrastructure Management Repository database used by the cluster health monitor
- D. There is one ologgerd service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
- E. There is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
Answer: A,B
NEW QUESTION # 39
......
1z0-078 Exam Info and Free Practice Test Professional Quiz Study Materials: https://passleader.realexamfree.com/1z0-078-real-exam-dumps.html
