The New 1z0-078 2024 Updated Verified Study Guides & Best Courses
Authentic 1z0-078 Exam Dumps PDF - 2024 Updated
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 |
|
NEW QUESTION # 44
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 group called dba
- 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 user to own the Grid Infrastructure installation
- D. A group to own Automatic Storage Management (ASM) Filter Driver-provisioned storage
- E. an O/S group to own the software inventory
- F. an 0/S user to own the Oracle Database installation
Answer: C,E
NEW QUESTION # 45
Which method should be used to convert a single-instance Oracle 19c Database to a RAC Database?
- A. Using dbca to migrate the database to shared storage and then to start one or more RAC database instances on the cluster
- 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 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 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: A
NEW QUESTION # 46
Which three statements are true about ASM Cloud File System (ACFS) encryption? (Choose three.)
- A. acfsutil encr inic is used to establish role separation between encryption managers and encryption auditors.
- B. A copy of an encrypted file is not encrypted unless it is created in an encrypted directory.
- C. acfsutil encr off can be run by an encryption manager who may not have system administrator privileges.
- D. acfsucil encr on can be used to specify the encryption key length for a directory or file.
- E. An ACFS snapshot can be ACFS encrypted.
Answer: A,D,E
NEW QUESTION # 47
Which two commands will stop the Oracle High Availability Services (OHAS) and prevent it from starting automatically at system boot on the local node? (Choose two.)
- A. crsctl stop cluster
- B. crsctl stop crs
- C. crsctl config crs
- D. crsctl disable crs
Answer: B,D
NEW QUESTION # 48
Which two statements are true regarding ASM Dynamic Volume Manager (ADVM)? (Choose two.)
- A. Only one ADVM volume can be created in an ASM disk group.
- B. An ADVM volume is individually named and can contain only one file system.
- C. To create an ADVM volume, disk group attributes COMPATIBLE.ASM and COMPATIBLE.ADVM must be minimally set to 12.1.<.span>.
- D. File systems contained in ADVM volumes may only contain database files.
- E. ADVM extends ASM by providing a device driver interface to storage backed by an ASM disk group.
Answer: B,E
NEW QUESTION # 49
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. All running CDB instances must be open in restricted mode.
- B. It can be executed only by a common user with the create pluggable database system privilege connected to the root container.
- C. The source pdb must use a global temporary
- D. Oracle Managed Files must be enabled or PD3 file name convert must be set.
- E. The source PD3 must be closed on the CDS instance from where the command is executed.
- F. The source PD3 must be in read only mode on all CD3 instances if the CDB is in No Archive mode.
Answer: B,D,E
NEW QUESTION # 50
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 database oracle homes with the same release on all cluster nodes.
- B. It applies a patch to all oracle homes with the same release only on the first cluster node.
- C. It applies a patch to one oracle home only on the first cluster node.
- D. It applies a patch to one database ORACLE home on alll cluster nodes.
- E. It applies a patch to all database oracle homes with the same release only on the first cluster node.
Answer: C
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. All GRD Enqueue Resource master metadata is held in the large pool of the same database instance.
- B. RAC databases have GRD cache resources distributed among all the database instances and stored in the shared pool of each instance.
- C. RAC databases have GRD cache resources distributed among all the database instances and stored in the large pool of each instance.
- D. Shadow GRD resources may exist in more than one database instance for a resource.
- E. Clustered ASM has GRD resources distributed among all ASM instances.
- F. All GRD Enqueue Resource master metadata is held in the shared pool of the same database instance.
- G. Only one GRD shadow resource may exist for an Enqueue Resource.
Answer: C,D,E
NEW QUESTION # 52
Which three statements are true about the Oracle Clusterware 19c Flex Cluster architecture? (Choose three.)
- A. Each leaf node must be connected to storage shared across all cluster nodes.
- B. Each leaf node must be connected to storage shared across all leaf nodes.
- C. Each hub node must be connected to storage shared across all hub nodes.
- D. Hub nodes require direct access to the OCR file.
- E. Leaf nodes require direct access to the voting disks.
- F. Hub nodes require direct access to the voting disks.
Answer: C,D,F
NEW QUESTION # 53
Which statement describes the purpose of colocation_tag for client routing with Oracle database 19c?
- A. When possible, clients with the same colocation_tag are routed to the same available instance when a preferred instance is not available.
- B. When possible, clients with the same colocation_tag could be routed across a set of preferred instances based on a specific load balancing option.
- C. When possible, clients with the same colocation_tag are routed to the same available instance even if a preferred instance is available.
- D. When possible, clients with the same colocation_tag are routed to the same instance that offers a given service.
Answer: D
NEW QUESTION # 54
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 unpin css - host04 command as root on host01, or on either host02 or host03.
- B. Run the rootcrs.pl -deconfig -force command as root on host04.
- C. Run the crsctl delete node -n host04 command as root on host01, or on either host02 or host03.
- D. Run the crsct1 unpin css - host04 command as root on host04.
- E. Run the rootcrs.pl -deconfig -force command as root on host01, or on either host02 or host03.
- F. Run the crsctl delete node -n host04 command as root on host04.
Answer: B,C
NEW QUESTION # 55
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; Oracle Cluster Time Synchronization Service (CTSSD) will then start automatically in observer mode when the clusterware is started.
- C. 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.
- D. 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.
- E. 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.
Answer: B,C
NEW QUESTION # 56
Identify three prerequisites for the successful installation of Oracle Grid Infrastructure 19c when using Full Featured Grid Naming Service (GNS). (Choose three.)
- A. A DHCP service on the private network for the cluster is required to allocate virtual IP addresses for HAIP.
- B. You must create a Grid Management Repository database.
- C. You must enable the Name Server Cache Daemon
- D. A DHCP service on the public network for the cluster is required to allocate virtual IP addresses as required by the cluster.
- E. Each cluster node must have at least two network interface cards.
- F. DNS must be configured to delegate name resolution for the cluster subdomain to the cluster.
Answer: C,D,F
NEW QUESTION # 57
Examine the output of the asmcmd and srvctl commands:
Then you execute this command:
$ srvctl relocate asm -currentnode host03 -targetnode host02
Which three statements are true regarding the execution of this command based on the output shown? (Choose three.)
- A. It fails because an ASM instance is not configured to run on HOST02.
- B. It succeeds and 19c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST02.
- C. It fails because the ASM instance has not been shut down first on HOST03.
- D. It succeeds and starts an ASM instance on HOST02 and shuts down the ASM instance on HOST03.
- E. It succeeds and 19c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST01.
- F. It succeeds and starts an ASM instance on HOST02 but the ASM instance on HOST03 is not shut down until all connected clients disconnect.
Answer: A,B,F
NEW QUESTION # 58
Which two statements are true regarding ASM when installing Oracle Grid Infrastructure 19c? (Choose two.)
- A. The Installer permits the creation of a disk group for use by the voting disks and OCR file.
- B. The Installer permits the creation of a disk group to be used for the Recovery Area for the ASM instance.
- C. ASM disk groups used for voting files and OCR files require a quorum failqroup.
- D. If no ASM disk groups are specified during installation, then ASM instances are not started after the installation completes on any cluster node.
- E. If ASM disk groups are configured for the Clusterware files, then ASM must be used for all databases on the cluster.
Answer: A,D
NEW QUESTION # 59
Which two statements are true concerning Oracle 19c Clusterware-managed application VIPs? (Choose two.)
- A. If an application sends messages to be displayed and sets the display variable, then an application VIP is required.
- B. An application VIP is created on the default network by the appvipcfg utility.
- C. An application VIP can be created with the crsccl utility.
- D. Application VIPs do not fail over to surviving cluster nodes when the node hosting the VIP fails.
- E. An application VIP is created on the interconnect network by the crsccl utility.
Answer: B,C
NEW QUESTION # 60
Which three statements are true regarding ASM on a four-node cluster? (Choose three.)
- A. ASM Cluster File System (ACFS) can be deployed on any nodes.
- B. A database instance on a node can only be a client of an ASM instance running on the same node.
- C. A database instance on a node cannot be a client of an ASM instance running on other nodes.
- D. An ASM instance and database instances can coexist on the same node.
- E. A database instance on a node can be a client of an ASM instance running on any node.
- F. A database instance on a node uses an ASM instance as an I/O server when requesting I/O to diskgroups.
Answer: D,E,F
NEW QUESTION # 61
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. ACFS auditing information is replicated from the primary file system to the standby file system.
- C. Standby redo log files are required on the standby site for synchronous redo transport.
- D. The privilege sysrepl has been introduced for ACFS replication.
- E. One site of an ACFS replication configuration can host both primary and standby file systems.
Answer: B,D,E
NEW QUESTION # 62
......
Get Prepared for Your 1z0-078 Exam With Actual 79 Questions: https://examtorrent.dumpsactual.com/1z0-078-actualtests-dumps.html
