Question No. 1

Which three statements are true about ASM Cloud File System (ACFS) encryption? (Choose three.)

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

BAn ACFS snapshot can be ACFS encrypted.

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

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

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

Show Answer

Correct Answer: B, D, E

Question No. 2

Which two tasks must be performed before launching the Oracle universal installer to install Oracle Database Software for RAC? (Choose two.)

Assh user equivalence for the Oracle software owner must be configured on all cluster nodes where the Database software will be installed.

BGrid Infrastructure must be installed on all cluster nodes.

CThe Clusterware stack must be up on all cluster nodes.

DThe Clusterware stack must be up on all cluster nodes where the Database software will be installed.

ESSH user equivalence for the Oracle software owner must be configured on all cluster nodes.

FGrid Infrastructure must be installed on all cluster nodes where the Database software will be installed.

Show Answer

Correct Answer: A, B

Question No. 3

Which three resources are managed using global concurrency control in an Oracle 19c RAC multi-instance database? (Choose three.)

ADatabase block buffers

BMutexes

CRedo log buffers

DLatches

EEnqueues

FCursors

Show Answer

Correct Answer: B, D, E

Question No. 4

Which statement describes the purpose of colocation_tag for client routing with Oracle database 19c?

AWhen possible, clients with the same colocation_tag are routed to the same instance that offers a given service.

BWhen possible, clients with the same colocation_tag are routed to the same available instance even if a preferred instance is available.

CWhen possible, clients with the same colocation_tag could be routed across a set of preferred instances based on a specific load balancing option.

DWhen possible, clients with the same colocation_tag are routed to the same available instance when a preferred instance is not available.

Show Answer

Correct Answer: A

Question No. 5

Which statement is true about Oracle Database 19c SGA Management?

AOracle RAC Resource Management only allows assignment of the SGA during instance startup.

BOracle RAC Resource Management requires the same SGA value for all the instances of a RAC database which is configured during database startup only.

COracle RAC Resource Runtime Management allows for automatic and runtime adjustment of the SGA.

DOracle RAC Resource Management only allows assignment of the SGA during database startup.

Show Answer

Correct Answer: C

Free Oracle 1Z0-078 Exam Actual Questions