最新的Oracle 1z0-068免費考試真題

問題1

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

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

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

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

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

E. Use Locally Managed Tablespaces with autoallocate.

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

正確答案: B,E

問題2

Which two statements are true about High Availability NFS (HANFS)? (Choose two.)

A. HANFS performance depends on the characteristics of the underlying ASM disks.

B. NFS client requests are distributed by DNS in a round-robin fashion to the cluster nodes that export the NFS filesystem.

C. HANFS does not depend on NFS services provided by the underlying operating system.

D. HANFS provides high availability in case of cluster node failure.

E. HANFS provides high availability in case of an NFS client failure.

正確答案: A,E

問題3

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

A. New allocation units are not mirrored but changes to allocation units are tracked in the FG2 failure group.

B. Transactions on database objects stored in tablespaces in the DGRP1 disk group fail.

C. The redundancy is lowered until the FG1 failgroup is restored and the disk group resynchronized.

D. New allocation units are mirrored in the FG2 failure group until FG1 is restored and the disk group resynchronized.

正確答案: B,D

問題4

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

A. acfsutil tag set can be used to tag files.

B. acfssettag is a command provided by a platform-independent API to tag files.

C. acfsutil encr on can be used to specify the tag names of the files to be encrypted.

D. ACFS tagging is used to mark a subset of files in an ACFS file system for replication.

E. acfssettag is a command provided by a platform-dependent API to tag files.

正確答案: A,B,D

說明：（僅 Fast2test 成員可見）

問題5

Which three statements are true about Oracle 12c multitenant RAC databases created using the Database Configuration Assistant (DBCA) on a cluster from a RAC database home? (Choose three.)

A. They can be administrator managed.

B. They are automatically configured to use Enterprise Manager Express.

C. They can be policy managed.

D. They have a unique service name created for each pluggable database (PDB) automatically registered as a cluster service resource.

E. They can have multiple pluggable databases (PDB) when the container database (CDB) is created.

F. They have their pluggable databases (PDBs) opened in each container database (CDB) instance automatically after CDB creation.

正確答案: A,C,E

問題6

Which two types of network adapters are required in which quantity in order to comply with Oracle recommendations for hardware in a cluster? (Choose two.)

A. at least two for the public network

B. at least one for the storage network

C. at least two for the interconnect

D. at least two for the storage network

E. at least one for the public network

F. at least one for the interconnect

正確答案: E,F

說明：（僅 Fast2test 成員可見）

問題7

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

A. NFS

B. HAVIP

C. Application VIP

D. ExportFS

E. HAIP

F. DHCP

正確答案: A,B,D

說明：（僅 Fast2test 成員可見）

問題8

You created a RAC database with DBCA and decide to verify it.
The server pool large_db has four servers.
Examine the output shown:

Which two statements are true based on this output? (Choose two.)

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

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

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

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

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

正確答案: A,C

問題9

Examine this command:
$ srvctl modify service -db RACDB -service SRVBl -clbgoal LONG
This three-Instance RAC database uses Flex ASM.
Which two statements are true regarding server-side connect-time load balancing using SCAN listeners for this service? (Choose two.)

A. The SCAN listeners automatically balance the connections across the instances accepting logins for the SRVB1 service.

B. The SCAN listeners redirect clients to the node listener serving the instance that has the fewest sessions for the SRVB1 service.

C. The SCAN listeners redirect clients to the node listener serving the instance that has the fastest response time for the SRVB1 service.

D. It is disabled because the -c1bgoal attribute is set to LONG.

E. It is enabled only when LOAD_BALANCE=YES is coded in the client-side TNS entry used by the client.

正確答案: D,E

問題10

Examine these commands:
$ srvctl add service -db racdb -service erp -serverpool srvpooll
- failovertype TRANSACTION -commit_outcome TRUE - replay_init_time 1800
- retention 86400 -notification TRUE -rlbgoal SERVICE_TIME -clbgoal SHORT
- failoverretry 30 - failoverdelay 10
$ srvctl start service - db racdb - service erp
Instances RACDB_1 and RACDB_2 run on host01 and host02, respectively.
Which three statements are true regarding the service erp?

A. Load Balancing Advisory (LBA) will be disabled for this service.

B. Connections to the database using erp benefit from Application Continuity.

C. erp is configured for an administrator-managed RAC database.

D. Connections to the database using erp benefit from Transaction Guard.

E. Connections to the database using erp benefit from Load Balancing.

正確答案: B,D,E

說明：（僅 Fast2test 成員可見）

問題11

Examine this command:
SQL> ALTER TABLESPACE TBS1 ADD DATAFILE '+DATA(newtemplate)/ORCL/USERS/mytab.dbf' SIZE 100M; Which two statements are required for this command to succeed? (Choose two.)

A. The DB_CREATE_FILE_DEST parameter must be set to +DATA(newtemplate).

B. The +DATA disk group should not be part of Flex ASM.

C. Existing data les in TBS1 must also use the same template.

D. User-defined subdirectories ORCL and USERS must already exist.

E. newtemplate must be defined for the +DATA disk group.

正確答案: B,C

最新的Oracle Database 12c: RAC and Grid Infrastructure Administrator - 1z0-068免費考試真題

聯系我們

站內鏈接

最新更新