Updated PDF (New 2024) Actual Oracle 1z0-078 Exam Questions
Verified 1z0-078 Exam Dumps PDF [2024] Access using VerifiedDumps
NEW QUESTION # 36
Which three statements are true regarding multitenant architecture for RAC databases? (Choose three.)
- A. PDBs can have local temporary
- B. PDBs must use shared Temporary
- C. One undo tablespace for each pdb is required.
- D. You can open one, several, or all PD3s on one, several, or all cdb instances.
- E. One undo tablespace for each instance is required.
- F. It requires the cdb to use shared undo management.
Answer: A,D,F
NEW QUESTION # 37
Which three statements are true about the Oracle Clusterware 19c Flex Cluster architecture? (Choose three.)
- A. Leaf nodes require direct access to the voting disks.
- B. Each hub node must be connected to storage shared across all hub nodes.
- C. Hub nodes require direct access to the OCR file.
- D. Hub nodes require direct access to the voting disks.
- E. Each leaf node must be connected to storage shared across all cluster nodes.
- F. Each leaf node must be connected to storage shared across all leaf nodes.
Answer: B,C,D
NEW QUESTION # 38
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 one of the available CD31 instances.
- D. AR is available only on the CDBl instance on host01.
- E. AR can fail over to any other available CDBl instance in prod pool.
Answer: B,E
NEW QUESTION # 39
Which two statements are true about Oracle Clustered ASM performance? (Choose two.)
- A. All ASM Disks belonging to a disk group should have the same hardware specifications and storage attributes for optimal performance.
- B. Hardware-based mirroring combined with ASM mirroring guarantees optimal performance.
- C. All ASM Disks belonging to a disk group should be of the same size for optimal performance.
- D. Data files, redo logs, and RMAN backup pieces must be stored in different ASM disk groups for optimal performance.
- E. To improve performance a database must have two disk groups; one for data and one for the fast recovery area.
Answer: A,C
NEW QUESTION # 40
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. All server pools in a cluster are controlled by 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. 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.
- E. A server pool can have the same attributes defined for different policies in the policy set, when user-defined policy management is used.
Answer: B,C,E
NEW QUESTION # 41
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. The source PD3 must be closed on the CDS instance from where the command is executed.
- 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 in read only mode on all CD3 instances if the CDB is in No Archive mode.
- F. All running CDB instances must be open in restricted mode.
Answer: A,B,D
NEW QUESTION # 42
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 only on the first cluster node.
- B. It applies a patch to all database oracle homes with the same release on all cluster nodes.
- C. It applies a patch to one database ORACLE home on alll cluster nodes.
- D. It applies a patch to all oracle homes with the same release only on the first cluster node.
- E. It applies a patch to one oracle home only on the first cluster node.
Answer: E
NEW QUESTION # 43
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 or the listener, but not both, for any one connection request.
- B. Load balancing can be done by the client, the listener, or both, for any one connection request.
- C. Services support the balancing of client connections across RAC database instances.
- D. In server-side load balancing, node listener redirects the client to another node listener for connection to an instance.
- E. Client-side connect-time load balancing can balance connection requests across SCAN listeners.
Answer: B,C,D
NEW QUESTION # 44
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. A Server Pool
- C. an application VIP
- D. a script agent
- E. an application resource
Answer: D,E
NEW QUESTION # 45
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. All server attributes used for categorization are administrator modifiable.
- E. Server categories can only be used for nodes running an application server.
- F. Different nodes in a cluster may belong to separate administrator-defined categories.
Answer: A,F
NEW QUESTION # 46
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. An ASM instance and database instances can coexist 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 can be a client of an ASM instance running on any node.
- F. A database instance on a node can only be a client of an ASM instance running on the same node.
Answer: A,B,E
NEW QUESTION # 47
Which three statements are true about fully qualified file names in ASM? (Choose three.)
- A. They are the only valid form that can be used for single file creation of a control file.
- B. They can be created only if OMF is enabled.
- C. They can be used to reference existing ASM files.
- D. An alias may be created for an existing file by referring to the fully qualified file name.
- E. They are system Generated at the time of ASM file creation.
Answer: C,E
NEW QUESTION # 48
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 where the Database software will be installed.
- B. SSH user equivalence for the Oracle software owner must be configured on all cluster nodes.
- C. Grid Infrastructure must be installed on all cluster nodes where the Database software will be installed.
- D. Grid Infrastructure must be installed on all cluster nodes.
- E. The Clusterware stack must be up on all cluster nodes.
- F. ssh user equivalence for the Oracle software owner must be configured on all cluster nodes where the Database software will be installed.
Answer: D,F
NEW QUESTION # 49
Which three statements are true concerning activation of a user-defined policy in Oracle 19c Clusterware? (Choose three.)
- A. When a policy is activated, resources cannot be automatically started to comply with the policy definition.
- B. When a policy is first created, it is initially active.
- C. When a policy is first created, it is initially inactive.
- D. When a policy is activated, resources can be automatically stopped to comply with the policy definition.
- E. An administrator-defined policy may be activated using the srvctl utility.
- F. When a policy is activated, nodes may be reassigned to server pools based on the policy definition.
Answer: C,D,E
NEW QUESTION # 50
Which three statements are true about ASM Cloud File System (ACFS) replication? (Choose three.)
- A. The privilege sysrepl has been introduced for ACFS replication.
- B. One site of an ACFS replication configuration can host both primary and standby file systems.
- 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. Replication is automatically terminated if the primary file system has less than 2 GB free space.
Answer: A,B,C
NEW QUESTION # 51
Which two statements are true about node listeners in a Grid Infrastructure Cluster using ASM? (Choose two.)
- A. They run from the Grid Infrastructure home by default.
- B. They listen only for database instances on the same node.
- C. They listen on behalf of any ASM instance and all database instances on the same node.
- D. There can be only one node listener per node.
- E. They listen only for the ASM instance on the same node.
Answer: A,C
NEW QUESTION # 52
......
Try Best 1z0-078 Exam Questions from Training Expert VerifiedDumps: https://www.verifieddumps.com/1z0-078-valid-exam-braindumps.html
Practice Examples and Dumps & Tips for 2024 Latest 1z0-078 Valid Tests Dumps: https://drive.google.com/open?id=1-97Y8V6WFR70-3cOZ2SFGP6Pq6FEd62J
