Free Oracle 1z0-078 Practice Exam with Questions & Answers | Set: 2

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.

When a policy is activated, resources can be automatically stopped to comply with the policy definition.

An administrator-defined policy may be activated using the srvctl utility.

When a policy is first created, it is initially inactive.

When a policy is first created, it is initially active.

When a policy is activated, resources cannot be automatically started to comply with the policy definition.

When a policy is activated, nodes may be reassigned to server pools based on the policy definition.

A copy of an encrypted file is not encrypted unless it is created in an encrypted directory.

An ACFS snapshot can be ACFS encrypted.

acfsutil encr off can be run by an encryption manager who may not have system administrator privileges.

acfsucil encr on can be used to specify the encryption key length for a directory or file.

acfsutil encr inic is used to establish role separation between encryption managers and encryption auditors.

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.

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.

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.

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.

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.

Data files, redo logs, and RMAN backup pieces must be stored in different ASM disk groups for optimal performance.

All ASM Disks belonging to a disk group should be of the same size for optimal performance.

Hardware-based mirroring combined with ASM mirroring guarantees optimal performance.

All ASM Disks belonging to a disk group should have the same hardware specifications and storage attributes for optimal performance.

To improve performance a database must have two disk groups; one for data and one for the fast recovery area.

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.

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.

Any database instance with the COMPATIBLE parameter set to 12.2 or later can access it.

It can contain ASM Dynamic Volume Manager (ADVM) volumes.

Each disk in each of the three fail groups is a mirror of the corresponding disk of the other two failure groups.

The ASM compatible attributes can be changed to 12. l for this disk group.

Files created in this disk group always have two copies for each allocation unit: one primary and one secondary.

The clusterware log files are stored inside the Grid Infrastructure Management Repository database used by the cluster health monitor

The diagcolleccion.pl script must be run from the Grid home directory as the arid infrastructure owner.

There is one ologgerd service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.

The oclumon utility may be used to get and set parameters for the cluster health monitor (CHM) repository.

There is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.

exec sys.dbms shared pool.keep('SEQ1','Q'>

alter sequence seal cache 10000;

alter sequence seql noorder;

alter sequence seql keep;

alter sequence seql order;