1z1-078 - Latest Training Dumps

Pass Your Oracle Database 1z1-078 Exam Easily with Accurate PDF Questions [Feb 26, 2024]

1z1-078 Certification Exam Dumps Questions in here

Oracle 1z1-078 Exam Syllabus Topics:

Topic	Details
Topic 1	Optional Install for the Grid Infrastructure Management Repository Install a patchset with the Oracle Universal Installer (OUI) utility
Topic 2	Describe the architecture and components of Flex ASM Monitor ASM instances using the V$ASM dynamic performance views
Topic 3	Explain use of Affinity to reduce Global Resource Contention Define undo tablespaces in a RAC environment
Topic 4	Explain global enqueue and instance lock management Explain the benefits of Fast Application Notification (FAN)
Topic 5	Explain how global resources are managed Determine RAC-specific wait-events, global enqueues and system statistics
Topic 6	Explain the types of patches and upgrades available Explain the hivh availability components of Oracle Clusterware
Topic 7	Configure client-side connect-time load balancing and failover Convert an Oracle RAC One Node database to a RAC database
Topic 8	Perform ongoing maintenance tasks on ASM disk groups Explain how ASM files, directories and aliases are created and managed
Topic 9	Configure the RAC database to use ARCHIVELOG mode and the fast recovery area Convert a single instance Oracle database to RAC
Topic 10	Configure server-side connect-time load balancing Use DBCA to convert a single-instance database to a RAC One Node database

NEW QUESTION 13
Which two statements are true about the Global Enqueue Service, Instance Locks, and global enqueues in Oracle 19c RAC? (Choose two.)

Global Enqueues and Instance Locks replace mutexes completely in RAC database instances.

Global Enqueues may have converters and waiters in the same instance.

Global Enqueues may have owners and waiters in the same instance.

Global Enqueues and Instance Locks replace latches completely in RAC database instances.

In a RAC database, there is no LMDO process if only one instance is running.

In a RAC One Node database, there is no LMD) process if only one instance is running.

NEW QUESTION 14
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.)

It fails to resize voli because it must be executed as a user belonging to the sysasm group.

It fails to resize the filesystem because it must be unmounted before resizing.

It succeeds but leaves the file system unmounted.

It resizes voli.

It resizes the filesystem mounted on /u01/app/grid/acfsmount.

NEW QUESTION 15
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.)

Create the current yr directory in the root directory (+).

Create the current yr directory in the +data disk group.

Add the DATAFILE ‘+DATA/CURRENT YR/sales.dbf clause to the command.

Add the autoextend on clause to the command.

lAdd the DATAFILE ‘/CURRENT YR/sales.dbf clause to the command.

NEW QUESTION 16
Which three statements are true about ASM Cloud File System (ACFS) replication? (Choose three.)

Replication is automatically terminated if the primary file system has less than 2 GB free space.

ACFS auditing information is replicated from the primary file system to the standby file system.

Standby redo log files are required on the standby site for synchronous redo transport.

The privilege sysrepl has been introduced for ACFS replication.

One site of an ACFS replication configuration can host both primary and standby file systems.

NEW QUESTION 17
Which two statements are true regarding the default service that is automatically created upon PDB creation in a RAC database environment? (Choose two.)

It is uniformly available on all instances for administrator-managed databases.

It cannot be used to automate the opening of the PDB by the Clusterware.

It is automatically registered in the OCR.

It is created and started on only one instance when using policy-managed database configuration.

It is not automatically registered in the OCR.

NEW QUESTION 18
Which three statements are true about fully qualified file names in ASM? (Choose three.)

They can be created only if OMF is enabled.

They are system Generated at the time of ASM file creation.

They can be used to reference existing ASM files.

They are the only valid form that can be used for single file creation of a control file.

An alias may be created for an existing file by referring to the fully qualified file name.

NEW QUESTION 19
Identify three prerequisites for the successful installation of Oracle Grid Infrastructure 19c when using Full Featured Grid Naming Service (GNS). (Choose three.)

Each cluster node must have at least two network interface cards.

You must enable the Name Server Cache Daemon

A DHCP service on the private network for the cluster is required to allocate virtual IP addresses for HAIP.

A DHCP service on the public network for the cluster is required to allocate virtual IP addresses as required by the cluster.

DNS must be configured to delegate name resolution for the cluster subdomain to the cluster.

You must create a Grid Management Repository database.

NEW QUESTION 20
Which two statements are true concerning Oracle 19c Clusterware-managed application VIPs? (Choose two.)

An application VIP is created on the default network by the appvipcfg utility.

Application VIPs do not fail over to surviving cluster nodes when the node hosting the VIP fails.

If an application sends messages to be displayed and sets the display variable, then an application VIP is required.

An application VIP can be created with the crsccl utility.

An application VIP is created on the interconnect network by the crsccl utility.

NEW QUESTION 21
Zero Downtime Patching uses Fleet Patching and Provisioning to patch Oracle Grid Infrastructure without bringing down Oracle RAC database instances.
Which three statements are true about Zero-Downtime Oracle Grid Infrastructure Patching? (Choose three.)

Zero Downtime Patching requires out-of-place patching of Oracle Grid Infrastructure 19c with Oracle RAC or Oracle RAC One Node databases of 19c or later releases and only the binaries in the Oracle Grid Infrastructure user space are patched.

When using Zero Downtime Patching, the root.sh script must be executed manually with -nodriver update option.

When using Zero Downtime Patching, Oracle Grid Infrastructure OS system software, kernel modules and system commands including ACFS, AFD, OLFS, and OKA are not updated.

Zero Downtime Patching requires in-place patching of Oracle Grid Infrastructure 19c with Oracle RAC or Oracle RAC One Node databases of 19c or later releases and only the binaries in the Oracle Grid Infrastructure user space are patched.

Zero Downtime Patching can be fully automated by selecting the option to automatically run the root.sh script.

NEW QUESTION 22
Examine this sequence of commands:

The cluster consists of nodes HOST01, HOST02, HOST03 and HOST04, and the clusterware is running on all four nodes.
Which three statements are true about the result of the root user running these commands on HOST01? (Choose three.)

The Oracle Clusterware stack is stopped on all nodes.

The Oracle Clusterware stack is prevented from being automatically started on host01.

The Oracle Clusterware stack is prevented from being automatically started on all nodes.

The Oracle Clusterware stack is stopped on all nodes except host01.

The Oracle Clusterware stack is started on all nodes except host01.

The Oracle Clusterware stack is started on all nodes.

NEW QUESTION 23
For which three entities can the “what-if” command evaluation be used to determine the impact of clusterware management operations in Oracle 19c Clusterware? (Choose three.)

Cluster resources

Database transactions

Local resources

Administrator-defined resources

Pluggable Databases (PDBs)

NEW QUESTION 24
Which three statements are true about Quality of Service Management (QoS)? (Choose three.)

It can manage database services only if they are defined as UNIFORM services.

It requires Oracle Grid Infrastructure for a Cluster to be installed and Clusterware to be running.

A server pool can be managed by QoS even if it does have database instances running on any server in the pool.

Databases managed by QoS can be administrator managed or policy managed.

It supports multiple databases assigned to the same server pool.

NEW QUESTION 25
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.)

The source PD3 must be closed on the CDS instance from where the command is executed.

The source PD3 must be in read only mode on all CD3 instances if the CDB is in No Archive mode.

The source pdb must use a global temporary

It can be executed only by a common user with the create pluggable database system privilege connected to the root container.

Oracle Managed Files must be enabled or PD3 file name convert must be set.

All running CDB instances must be open in restricted mode.

NEW QUESTION 26
Which three statements are true regarding ASM on a four-node cluster? (Choose three.)

ASM Cluster File System (ACFS) can be deployed on any nodes.

A database instance on a node can be a client of an ASM instance running on any node.

A database instance on a node cannot be a client of an ASM instance running on other nodes.

A database instance on a node can only be a client of an ASM instance running on the same node.

A database instance on a node uses an ASM instance as an I/O server when requesting I/O to diskgroups.

An ASM instance and database instances can coexist on the same node.

NEW QUESTION 27
Which two benefits are obtained by using Affinity to reduce global resource contention? (Choose two.)

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.

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.

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.

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.

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.

NEW QUESTION 28
Which three statements are true about the services created when the DBCA is used to create a RAC database? (Choose three.)

A server pool must be created with srvct1 before creating a policy-managed RAC database that uses that server pool for a service.

They can be policy managed for a multitenant database.

Policy-managed services specified for a database allow the creation of a new server pool using dbca.

They can be administrator managed for a multitenant database.

Singleton services are not permitted for multitenant databases.

NEW QUESTION 29
Which two statements are true about server categorization in Oracle 19c Clusterware? (Choose two.)

Different nodes in a cluster may belong to separate administrator-defined categories.

All nodes in a cluster belong to the same Oracle-supplied category.

A server may be added to only one category using the crsctl utility.

All server attributes that may be used to determine the server category are discovered automatically by Oracle Clusterware.

All server attributes used for categorization are administrator modifiable.

Server categories can only be used for nodes running an application server.

NEW QUESTION 30
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.)

AR can fail over to any one of the available CD31 instances.

AR runs as a singleton service in the server pool prod pool and the AR service is available in each of the CDBl instances.

AR can fail over to any other available CDBl instance in prod pool.

AR is available only on the CDBl instance on host01.

AR is available on any one available CDBl instance in prod pool at any one time.

Updated 1z1-078 Exam Practice Test Questions: https://www.trainingdump.com/Oracle/1z1-078-practice-exam-dumps.html

Category 1z1-078

[Q13-Q30] Pass Your Oracle Database 1z1-078 Exam Easily with Accurate PDF Questions [Feb 26, 2024]

Oracle 1z1-078 Exam Syllabus Topics: