[2026] Oracle Database 12c: RAC and Grid Infrastructure Administrator

문제1

Which two actions can restrict the number of instances used for parallel execution of a SQL statement?
(Choose two.)

A. setting the PARALLEL_FORGE_LOCAL to TRUE

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

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

D. setting the PARALLEL_SERVERS_TARGET value equal to that of PARALLEL_MAX_SERVERS

E. setting the PARALLEL_DEGREE_POLICY to LIMITED

정답: B,E

문제2

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

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

B. An ACFS snapshot can be ACFS encrypted.

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

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

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

정답: A,B,D

설명: (Fast2test 회원만 볼 수 있음)

문제3

Which three statements are true about Server Categorization in Oracle 12c Clusterware?

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

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

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

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

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

F. All server attributes used for categorization are administrator modifiable.

정답: C,E,F

설명: (Fast2test 회원만 볼 수 있음)

문제4

Which two statements are tuning recommendations for RAC database? (Choose two.)

A. Set PARALLEL_DEGREE_POLICY=AUTO to enable In Memory Parallel Query.

B. Use Locally Managed Tablespaces with autoallocate.

C. Use Locally Managed Tablespaces with large uniform extent sizes.

D. Use sequences with CACHE and ORDER, if possible.

E. Set PARALLEL_DEGREE_POLICY=AUTO to enable automatic Parallel Statement Queueing.

F. Use sequences with CACHE and NOORDER, if possible.

정답: B,F

문제5

PROD1, PROD2 and PROD3 are three active instances of the PROD database.
Examine these commands executed on PROD1:
SQL > ALTER SYSTEM SET PARALLEL_MIN_SERVERS=200 SCOPE=MEMORY sid='*';
SQL > ALTER SYSTEM SET PARALLEL_MIN_SERVERS=100 SCOPE=MEMORY sid='PROD1'; Which statement is true?

A. PARALLEL_MIN_SERVERS will be 200 for all instances of PROD.

B. PARALLEL_MIN_SERVERS will be 100 for all instances of PROD.

C. PARALLEL_MIN_SERVERS will be 200 for PROD2 and PROD3 and 100 for PROD1.

D. The second statement returns an error because this parameter must be identical for all instances.

정답: C

설명: (Fast2test 회원만 볼 수 있음)

문제6

Examine this command and output:

Examine this list of commands:
1. srvct1 convert db -db ron -dbtype rac -node o16n1
2. srvct1 convert db -db ron -dbtype raconenode -node 016n1
3. srvct1 add instance -db ron -instance ron_1 -node 016n1
4. srvct1 add instance -db ron -in5tance ron_2 -node 016n2
5. srvct1 start instance -db ron -instance ron_1
6. srvct1 start instance -db ron -instance ron_2
Currently, there is an instance of database ron running on o16n1.
You want to convert ron to a RAC database and make all instances available.
Identify the commands required, in the correct order, to accomplish this.

A. 1, 4 and 6

B. 2, 3, 4, 5 and 6

C. 2, 4, 5 and 6

D. 2, 4 and 6

E. 1, 3, 4, 5 and 6

F. 1, 4, 5 and 6

정답: E

문제7

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

A. It supports RAC One Node databases if they are assigned to server pools with a maximum size of one server.

B. One QoS policy can span multiple clusters if they contain server pools, assigned to be managed by QoS.

C. It requires a resource manager plan to be active on databases managed by QoS.

D. The command-line utility qosct1 can be used to change the password of the internal user QOSADMIN.

E. A server pool directive override can be used to modify the database parameter CPU_COUNT for all databases within one server pool.

정답: A,C,D

문제8

Which two statements are true concerning buffer states as shown in GV$BH.STATUS in Oracle 12c RAC?

A. An XCUR block image may exist for a specific database block in only one instance.

B. An XCUR image is not downgraded to a SCUR image for shipping to another instance until commits occur for updated rows on the block.

C. A CR image may get served from one instance to another to satisfy a read request.

D. A PI block image may exist for a specific database block in only one instance.

E. An XCUR image is not shipped to another instance until commits occur for updated rows on the block.

정답: A,C

설명: (Fast2test 회원만 볼 수 있음)

문제9

Which three statements are true regarding multitenant architecture for RAC databases?

A. One UNDO tablespace for each PDB is required.

B. You can open one, several, or all PDBs on one, several, or all CDB instances.

C. All the containers share the same SYSTEM and SYSAUX tablespaces.

D. One UNDO tablespace for each instance is required.

E. PDBs can have local temporary tablespaces.

정답: B,D,E

설명: (Fast2test 회원만 볼 수 있음)

문제10

Examine this query and output:
SQL> select order_flag, cache_size, session_flag, keep_value,
2 from user_sequences where sequence_name = 'SEQ1';
O CACHE_SIZE S K
-- ------------------- -- --
Y 10 N N
Performance analysis revealed severe SQ enqueue contention on the SEQ1 sequence.
The SEQ1 sequence is incremented from all instances equally and is frequently used.
Which two statements should you execute to reduce SQ enqueue contention?

A. alter sequence seq1 keep;

B. exec sys.dbms_shared_pool.keep ('SEQ1', 'Q')

C. alter sequence seq1 order;

D. alter sequence seq1 cache 10000;

E. alter sequence seq1 noorder;

정답: D,E

설명: (Fast2test 회원만 볼 수 있음)

문제11

You administer a RAC database that currently runs on a four-node cluster but which has three instances.
Which two statements are always true about redo logs for this RAC database? (Choose two.)

A. All the instances must have the same number of redo log groups and each group must have the same number of redo log members.

B. A thread of redo must contain at least two log groups before it can be enabled.

C. A thread of redo must be created before starting a fourth instance if a thread is not already available.

D. A redo log group added using ALTER DATABASE ADD LOGFILE without the INSTANCE clause is added to each instance.

E. A thread of redo is automatically dropped when an instance is removed from a RAC database by using SRVCTL.

정답: B,C

문제12

Which two Operating System users and groups must be created on each node before installing Oracle Grid Infrastructure 12c?

A. an O/S user to own the Grid infrastructure installation

B. an O/S group called dba

C. a group to own Automatic-Storage Management (ASM) Filter Driver-provisioned storage

D. an O/S user to own the Oracle Database installation

E. an O/S user to own the Clusterware installation and a different O/S user to own the Automatic Storage Management (ASM) installation

F. an O/S group to own the software inventory

G. a group to own the ASMLIB-provisioned storage

정답: B,F

설명: (Fast2test 회원만 볼 수 있음)

문제13

Which three components are integral parts of High Availability NFS (HANFS)?

A. DHCP

B. NFS

C. ExportFS

D. Application VIP

E. HAVIP

F. HAIP

정답: B,C,E

설명: (Fast2test 회원만 볼 수 있음)

문제14

Which three statements are true concerning policy-based cluster management in Oracle 12c Clusterware?

A. Server pools must be managed with the srvctl utility for servers hosting a database.

B. The server pool contains servers that host administrator-defined high availability resources.

C. All servers in a new cluster installation belong to the free server pool.

D. All servers in a new cluster installation belong to the generic server pool.

E. Server Pools must be managed with the crsctl utility for servers hosting an application or other administrator-defined high-availability resource.

정답: A,B,C

설명: (Fast2test 회원만 볼 수 있음)

Oracle Database 12c: RAC and Grid Infrastructure Administrator - 1z0-068무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트