Verified 1z0-078 Exam Dumps PDF [2024] Access using NewPassLeader
Try Best 1z0-078 Exam Questions from Training Expert NewPassLeader
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 # 45
Which two statements are true about initialization parameters for Clustered ASM instances? (Choose two.)
- A. ASM_POWER_LIMIT controls the number of RDBMS instances that can access a disk group while it is being rebalanced.
- B. A change to ASM_DISKSTRING requires a restart of all ASM instances for the change to take effect.
- C. The ASM_DISKGOUPS parameter is optional.
- D. The maximum value of ASM_POWER_LIMIT is 1024.
- E. The default value of INSTANCE_TYPE is ASM.
Answer: C,E
NEW QUESTION # 46
Which three statements are true about ASM Cloud File System (ACFS) replication? (Choose three.)
- A. One site of an ACFS replication configuration can host both primary and standby file systems.
- B. ACFS auditing information is replicated from the primary file system to the standby file system.
- C. The privilege sysrepl has been introduced for ACFS replication.
- D. Replication is automatically terminated if the primary file system has less than 2 GB free space.
- E. Standby redo log files are required on the standby site for synchronous redo transport.
Answer: A,B,C
NEW QUESTION # 47
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 not automatically registered in the OCR.
- B. It is uniformly available on all instances for administrator-managed databases.
- C. It is 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,C
NEW QUESTION # 48
Which two statements are true about Transparent Application Continuity in Oracle RAC 19c? (Choose two.)
- A. Recovery of the user database session is done safely by enabling auto recover within the user database session.
- B. Transparent Application Continuity is enabled when failover type=auto.
- C. Recovery of the user database session is done safely and with no need for a DBA to have any knowledge of the application or make application code changes.
- D. Transparent Application Continuity is enabled when failover type=All
- E. Transparent Application Continuity is automatically enabled for a session when a database session reaches a safe place (such as a connection test or a known recoverable point) and the transactions are drained at the database.
Answer: B,C
NEW QUESTION # 49
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 # 50
Which two statements are true about the Global Enqueue Service, Instance Locks, and global enqueues in Oracle 19c RAC? (Choose two.)
- A. Global Enqueues may have converters and waiters in the same instance.
- B. Global Enqueues and Instance Locks replace latches completely in RAC database instances.
- C. Global Enqueues may have owners and waiters in the same instance.
- D. In a RAC One Node database, there is no LMD) process if only one instance is running.
- E. In a RAC database, there is no LMDO process if only one instance is running.
- F. Global Enqueues and Instance Locks replace mutexes completely in RAC database instances.
Answer: C,E
NEW QUESTION # 51
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. It requires the cdb to use shared undo management.
- C. One undo tablespace for each instance is required.
- D. PDBs can have local temporary
- E. PDBs must use shared Temporary
- F. One undo tablespace for each pdb is required.
Answer: A,B,D
NEW QUESTION # 52
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 voli.
- B. It fails to resize the filesystem because it must be unmounted before resizing.
- C. It fails to resize voli because it must be executed as a user belonging to the sysasm group.
- D. It succeeds but leaves the file system unmounted.
- E. It resizes the filesystem mounted on /u01/app/grid/acfsmount.
Answer: A,E
NEW QUESTION # 53
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. The redundancy is lowered until the FGl failgroup is restored and the disk group resynchronized.
- B. Transactions on database objects stored in tablespaces in the dgrpi disk group fail.
- C. New allocation units are mirrored in the FG2 failure group until FGl is restored and the disk group resvnchronized-
- D. New allocation units are not mirrored but changes to allocation units are tracked in the FG2 failure group.
Answer: C,D
NEW QUESTION # 54
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 0/S user to own the Oracle Database installation
- C. A group to own Automatic Storage Management (ASM) Filter Driver-provisioned storage
- D. an O/S user to own the Clusterware installation and a different O/S user own the Automatic Storage Management (ASM) installation
- E. an O/S group to own the software inventory
- F. an O/S user to own the Grid Infrastructure installation
Answer: E,F
NEW QUESTION # 55
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. All GRD Enqueue Resource master metadata is held in the shared pool of the same database instance.
- C. Shadow GRD resources may exist in more than one database instance for a resource.
- D. RAC databases have GRD cache resources distributed among all the database instances and stored in the shared pool of each instance.
- E. RAC databases have GRD cache resources distributed among all the database instances and stored in the large pool of each instance.
- F. Clustered ASM has GRD resources distributed among all ASM instances.
- G. Only one GRD shadow resource may exist for an Enqueue Resource.
Answer: C,E,F
NEW QUESTION # 56
Which two statements are true about load balancing using a database service in a RAC environment? (Choose two.)
- A. Client-side connect time load balancing works only if it uses a tnsnames entry specifying load BALANCE=yes.
- B. Server-side connect time load balancing is done at the time of the initial connection attempt to the database service.
- C. Client-side connect time load balancing is done at the time of the initial connection attempt to the database service.
- D. Server-side load balancing connections are always distributed across instances based on the fastest response time for the service.
- E. In client-side load balancing, the SCAN listener uses the Load Balancing Advisory to direct a connection request to the least loaded instance hosting the service.
Answer: B,C
NEW QUESTION # 57
Which three statements are true about accessing ASM files? (Choose three.)
- A. Database instances perform read I/O using an ASM instance as an I/O Server.
- B. If a database instance writes to an ASM-based datafile whose redundancy attribute is set to mirror, then the ASM instance writes the mirror copy
- C. Database instances can write metadata to ASM diskgroups.
- D. ASM instances can write metadata to ASM diskgroups.
- E. Database instances perform read I/O directly to ASM Disks.
Answer: C,D,E
NEW QUESTION # 58
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. Clusterware will monitor the service while it is active.
- C. When manually started, the service will always start on one or more available instances rather than on their preferred instances.
- D. The service must be manually restarted with SRVCTL after restarting the Clusterware stack on the node hosting the service.
- E. The service must be manually started with SRVCTL after a planned restart of the instance hosting the service.
Answer: B,E
NEW QUESTION # 59
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. The source pdb must use a global temporary
- C. All running CDB instances must be open in restricted mode.
- D. The source PD3 must be in read only mode on all CD3 instances if the CDB is in No Archive mode.
- E. Oracle Managed Files must be enabled or PD3 file name convert must be set.
- F. It can be executed only by a common user with the create pluggable database system privilege connected to the root container.
Answer: A,E,F
NEW QUESTION # 60
......
Latest 100% Passing Guarantee - Brilliant 1z0-078 Exam Questions PDF: https://pass4lead.newpassleader.com/Oracle/1z0-078-exam-preparation-materials.html