최신Oracle Database 12c: RAC and Grid Infrastructure Administrator - 1z0-068무료샘플문제
문제1
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?
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?
정답: B
설명: (ExamPassdump 회원만 볼 수 있음)
문제2
Which three statements are true about services when used with transparent application failover (TAF) for an administrator-managed RAC database?
Which three statements are true about services when used with transparent application failover (TAF) for an administrator-managed RAC database?
정답: A,C,E
설명: (ExamPassdump 회원만 볼 수 있음)
문제3
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.)
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.)
정답: A,C,E
문제4
Which three statements are true concerning node evictions and reboots performed by Oracle Clusterware 12c?
Which three statements are true concerning node evictions and reboots performed by Oracle Clusterware 12c?
정답: A,C,F
설명: (ExamPassdump 회원만 볼 수 있음)
문제5
The DGRP1 diskgroup has these attributes:
* Normal redundancy
* Two failgroups with four asmdisks in each failgroup
* compatible.asm set to 12.1
The ASM_POWER_LIMIT parameter is currently set to 1 in the ASM instances.
There are three databases whose instances are up and which access data in the DGRP1 diskgroup.
No other clients use this diskgroup.
You want to add two asmdisks to each failgroup, complete the rebalance as quickly as possible, by avoiding checks for access to allocation units, and then restore database availability.
Examine the list of actions (see exhibit):
Exhibit:

Identify the correct sequence of required steps:
The DGRP1 diskgroup has these attributes:
* Normal redundancy
* Two failgroups with four asmdisks in each failgroup
* compatible.asm set to 12.1
The ASM_POWER_LIMIT parameter is currently set to 1 in the ASM instances.
There are three databases whose instances are up and which access data in the DGRP1 diskgroup.
No other clients use this diskgroup.
You want to add two asmdisks to each failgroup, complete the rebalance as quickly as possible, by avoiding checks for access to allocation units, and then restore database availability.
Examine the list of actions (see exhibit):
Exhibit:

Identify the correct sequence of required steps:
정답: D
문제6
Examine the output of the asmcmd and srvct1 commands:

You execute this command:
$ srvctl modify asm -count 2
All databases on the cluster are running from Oracle 12c homes.
Which statement is true about the outcome of this command?
Examine the output of the asmcmd and srvct1 commands:

You execute this command:
$ srvctl modify asm -count 2
All databases on the cluster are running from Oracle 12c homes.
Which statement is true about the outcome of this command?
정답: A
문제7
Which three statements are true regarding ACFS snapshots in Oracle 12c ASM?
Which three statements are true regarding ACFS snapshots in Oracle 12c ASM?
정답: C,E,F
설명: (ExamPassdump 회원만 볼 수 있음)
문제8
Which three statements are true about ASM Cloud File System (ACFS) tagging?
Which three statements are true about ASM Cloud File System (ACFS) tagging?
정답: A,D,E
설명: (ExamPassdump 회원만 볼 수 있음)
문제9
Which two utilities support the "what-if" command evaluation?
Which two utilities support the "what-if" command evaluation?
정답: A,D
설명: (ExamPassdump 회원만 볼 수 있음)
문제10
You administer an Oracle 12c RAC database whose clients connect to the database instances using SCAN listeners.
Which two statements are true regarding client-side connect-time load balancing? (Choose two.)
You administer an Oracle 12c RAC database whose clients connect to the database instances using SCAN listeners.
Which two statements are true regarding client-side connect-time load balancing? (Choose two.)
정답: A,C
문제11
Examine this command and output:
[root@host01 ~]# / sbin/acfsutil snap create snap001 /u0l/app/grid/acfsmount/ acfsutil snap create: Snapshot operation is complete.
Examine this command:
[root@host01 ~]# / sbin/acfsutil snap create -p snap001
Snap002 /u01/app/grid/ acfsmount/
Which statement must be true for the successful execution of the second command?
Examine this command and output:
[root@host01 ~]# / sbin/acfsutil snap create snap001 /u0l/app/grid/acfsmount/ acfsutil snap create: Snapshot operation is complete.
Examine this command:
[root@host01 ~]# / sbin/acfsutil snap create -p snap001
Snap002 /u01/app/grid/ acfsmount/
Which statement must be true for the successful execution of the second command?
정답: A
문제12
Disk group DGRP1 has these attributes:
1. Normal redundancy
2. Two failure groups FG1 and FG2 with two disks each
3. Compatibility settings set to 12.1
The FG1 failure group goes offline due to hardware failure.
Which two statements are true? (Choose two.)
Disk group DGRP1 has these attributes:
1. Normal redundancy
2. Two failure groups FG1 and FG2 with two disks each
3. Compatibility settings set to 12.1
The FG1 failure group goes offline due to hardware failure.
Which two statements are true? (Choose two.)
정답: B,D
문제13
Which three statements are true concerning the Automatic Workload Repository (AWR) in a RAC environment?
Which three statements are true concerning the Automatic Workload Repository (AWR) in a RAC environment?
정답: C,D,E
설명: (ExamPassdump 회원만 볼 수 있음)
문제14
Which two actions can restrict the number of instances used for parallel execution of a SQL statement?
(Choose two.)
Which two actions can restrict the number of instances used for parallel execution of a SQL statement?
(Choose two.)
정답: A,D