Oracle Database 12c: RAC and Grid Infrastructure Administrator - 1z1-068 Free Exam Questions

A. setting the PARALLEL_DEGREE_POLICY to LIMITED

B. using a database service to limit the number of instances that participate in parallel execution

C. setting the PARALLEL_FORGE_LOCAL to TRUE

D. creating a UNIFORM service for a policy-managed RAC database

E. setting the PARALLEL_SERVERS_TARGET value equal to that of PARALLEL_MAX_SERVERS

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

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

C. An ACFS snapshot can be ACFS encrypted.

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

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

A. The concurrency values are not shown because sales has only one of its four instances running.

B. The sales database resource will be restored to its previous running condition when restarting the clusterware stack after normal shutdown of the sales database.

C. The sales database resource will be started and the database instances will be started automatically when restarting the clusterware stack after normal shutdown of the sales database.

D. The sales database resource will be restarted automatically after an instance failure.

E. The concurrency values are not shown because sales in not a RAC One Node database.

A. An SPFILE is created for each instance containing instance-specific parameter settings only.

B. An SPFILE is created and contains parameter settings only for PROD1.

C. An SPFILE is created and contains parameter settings for all instances.

D. An SPFILE is created for each instance and contains parameter settings for all instances.

A. It displays the relationship between targets of different target types in a cluster.

B. It displays which listeners listen on behalf of which instances.

C. It displays the type of network used by RAC database instance.

D. It displays the status of Pluggable Databases (PDBs) in a multitenant container database (CDB).

E. It displays the relationship between clustered ASM and cluster databases if the database is stored in ASM.

F. It displays the status of all cluster components.

A. ASM files created using an alias name also have a fully qualified name and can be accessed by either name.

B. Alias names can be stored only in user-defined directories.

C. ASM files created using an alias name are OMF files even if OMF is not enabled.

D. ASM files created using an alias name are not OMF files even if OMF is enabled.

E. Alias file names cannot be used together with templates when creating tablespaces.

A. Performance of ACFS is improved by using these diskgroups.

B. Their COMPATIBLE.ASM attributes must be set to 11.2 or higher.

C. Their COMPATIBLE.ASM attributes must be set to 12.1 or higher.

D. Their sector size attributes can be changed using the ALTER DISKGROUP command.

E. Their COMPATIBLE.RDBMS attributes must beset to 11.2 or higher.

A. If network time protocol (NTP) time servers are unreachable on any cluster node, then Oracle CTSSD Time Synchronization Service (CTSSD) will start automatically in active mode when the clusterware is started.

B. 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.

C. Configure network time protocol (NT P) on all cluster nodes; Oracle Cluster Time Synchronization Service (CTSSD) will then start automatically in observer mode when the clusterware is started.

D. 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.

E. If network time protocol (NT P) is not configured properly on all cluster nodes, then Oracle Cluster Time Synchronization Service (CTSSD) will start automatically in active mode when the clusterwareis started.

A. 1, 3, 7

B. 2, 5, 8

C. 1, 4, 6

D. 2, 4, 7, 8

E. 2, 4, 7

F. 1, 4, 7, 8

A. If ASM disk groups are configured for the Clusterware files, then ASM must be used for all databases on the cluster.

B. ASM disk groups used for voting files and OCR files require a quorum failgroup.

C. The Installer permits the creation of a disk group to be used for the Recovery Area for the ASM instance.

D. The Installer permits the creation of a disk group for use by the voting disks and OCR file.

E. If no ASM disk groups are specified during installation, then ASM instances are not started after the installation completes on any cluster node.

A. ocrcheck -local

B. cluvfy comp ocr -n all -verbose

C. ocrcheck -config -local

D. ocrcheck -config

E. ocrcheck

A. It can be executed only by a common user with the CREATE PLUGGABLE DATABASE system privilege connected to the root container.

B. The source PDB must be closed on the CDB instance from where the command is executed.

C. Oracle Managed Files must be enabled or PDB_FILE_NAME_CONVERT must be set.

D. The source PDB must use a global temporary tablespace.

E. All running CDB instances must be open in restricted mode.

F. The source PDB must be in READ ONLY mode on all CDB instances.