最新12c 1z0-068考試題庫，Oracle 1z0-068課程的擬真試題下載

問題1
Which two statements are true about the Global Enqueue Service, Instance Locks, and global enqueues in Oracle 12c RAC?

A. Global Enqueues and Instance Locks replace latches completely in RAC database instances.

B. Global Enqueues and Instance Locks replace mutexes completely in RAC database instances.

C. Global Enqueues may have owners and waiters in the same instance.

D. Global Enqueues may have converters and waiters in the same instance.

E. In a RAC One Node database, there is no LMD0 process if only one instance is running.

F. In a RAC database, there is no LMD0 process if only one instance is running.

正確答案: D,E

說明：（僅 NewDumps 成員可見）

問題2
Which four tasks are performed by DBCA when you convert a single-instance database to a four-instance RAC database?

A. adding additional initialization parameters

B. adding cluster resources

C. creating database services

D. creating shared ASM disk groups

E. creating additional redo threads

F. creating additional undo tablespaces

正確答案: A,B,E,F

說明：（僅 NewDumps 成員可見）

問題3
Examine this command:
SQL> CREATE DISKROUP data NORMAL REDANDUNCY:
FAILGROUP fgrp1 DISK
'/dev/disk1' NAME disk1,
'/dev/disk2' NAME disk2,
'/dev/disk3' NAME disk3,
FAILGROUP fgrp2 DISK
'/dev/disk4' NAME disk4,
'/dev/disk5' NAME disk5,
'/dev/disk6' NAME disk6,
FAILGROUP fgrp3 DISK
'/dev/disk7' NAME disk7,
'/dev/disk8' NAME disk8,
'/dev/disk9' NAME disk9,
ATTRIBUTE 'au_size'='4M',
'compatible.asm' = '11.2',
'compatible.rdbms' = '11.2',
'compatible.advm' = '11.2',
'content_type' = 'recovery';
Which two statements a true about this disk group, created using Grid Infrastructure 12.1?

A. Files created in this disk group always has two copies for each allocation unit: one primary and one secondary.

B. Any database instance with the COMPATIBLE parameter set to 11.2 or higher can access it.

C. The ASM compatible attributes can be changed to 11.1 for this disk group.

D. It can contain ASM Dynamic Volume Manager (ADVM) volumes.

E. Each disk in each of the three fail groups is a mirror of the corresponding disk of the other two failure groups.

正確答案: B,D

問題4
Which two types of IP address details are administered using the srvctl command for Oracle Clusterware 12c?
(Choose two.)

A. Storage Network IP addresses

B. public IP addresses

C. High Available VIP (HAIP) addresses

D. Single Client Access Name (SCAN) VIPs

E. the Grid Naming Service (GNS) VIP

正確答案: D,E

說明：（僅 NewDumps 成員可見）

問題5
Which two statements are true regarding ASM when installing Oracle Grid Infrastructure 12c? (Choose two.)

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

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

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

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

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

正確答案: A,E

問題6
Which two statements are true about Oracle Clustered ASM performance? (Choose two.)

A. All ASM Disks belonging to a disk group should be of the same size for optimal performance.

B. All ASM Disks belonging to a disk group should have the same hardware specifications and storage attributes for optimal performance.

C. Hardware-based mirroring combined with ASM mirroring guarantees optimal performance.

D. Data files, redo logs, and RMAN backup pieces must be stored in different ASM disk groups for optimal performance.

E. To improve performance a database must have two disk groups; one for data and one for the fast recovery area.

正確答案: A,B

問題7
A directory +DATA/ORCL/DATAFILE/USERS exists in ASM.
USERS is a user created directory; ORCL and DATAFILE are system generated directories.
Which two statements are true about user-created directories?

A. You cannot drop a directory containing aliases unless you delete the aliases first.

B. You cannot create a user-defined directory at the root (+) level.

C. You cannot rename a user-created subdirectory.

D. You can create subdirectories under the USERS directory.

E. You cannot create a nested subdirectory /USER1/2014 under USERS with a single CREATE DIRETORY command even if directory USER1 doesn't exist.

正確答案: B,E

問題8
Which three statements are true about displaying the location of voting files, OCR files, or OLR files in Oracle Clusterware 12c on a UNIX system?

A. Use crsctl querry css votedisk to view the location of voting files if stored in ASM.

B. Use cat /etc/oracle/ocr.loc to view the location of the OCR if stored in ASM.

C. Use crsctl query css votedisk to view the location of voting files if stored in a file system.

D. Use ocrcheck command to view the location of the OCR only if stored in a file system.

E. Use the ls command in the asmcmd utility to view the location of voting files if stored in ASM.

F. Use cat /etc/oracle/olr.loc to view the location of the OCR and OLR if stored on a file system.

正確答案: A,B,C

問題9
Examine the output of this command:
ASMCMD> volinfo -G ACFS -a
Diskgroup Name: ACFS
Volume Name: VOL1
Volume Device: /dev/asm/vol1-280
State: ENABLED
Size (MB): 2048
Resize Unit (MB): 32
Redundancy: MIRROR
Stripe Columns: 4
Stripe Width (K): 128
Usage: ACFS
Mountpath: /u01/app/grid/acfsmount
The ACFS disk group is a normal redundancy disk group with 5 GB of free space.
To increase the size of the ACFS file system, you execute this command as the root user:
$ /sbin/acfsutil size +200M /u01/app/grid/acfsmount
Which two statements are true regarding the outcome of this command?

A. It resizes VOL1.

B. It resizes the filesystem mounted on /u01/app/grid/acfsmount.

C. It fails to resize VOL1 because it must be executed as a user belonging to the SYSASM group.

D. It succeeds but leaves the filesystem unmounted.

E. It fails to resize the filesystem because it must be unmounted before resizing.

正確答案: A,D

問題10
Which two statements are true concerning ASM diskgroups using disks with a 4k sector size?

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

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

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

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

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

正確答案: D,E

說明：（僅 NewDumps 成員可見）

問題11
Identify three prerequisites for the successful installation of Oracle Grid Infrastructure 12c for a standard cluster when using Full Featured Grid Naming Service (GNS).

A. You must enable the Name Server Cache Daemon (NSCD).

B. Each cluster node must have at least two network interface cards,

C. A DHCP service on the private network for the cluster is required to allocate virtual IP addresses for HAIP.

D. A DHCP service on the public network for the cluster is required to allocate virtual IP addresses as required by the cluster.

E. DNS must be configured to delegate name resolution for the cluster subdomain to the cluster.

F. You must create a Grid Management Repository database.

正確答案: C,D,E

問題12
Which three statements are true about Quality of Service Management (QoS)?

A. Databases managed by QoS can be administrator managed or policy managed.

B. It requires Oracle Grid Infrastructure for a Cluster to be installed and Clusterware to be running.

C. A server-pool can be managed by QoS even if it does have database instances running on any server in the pool.

D. It supports multiple databases assigned to the same server pool.

E. It can manage database services only if they are defined as UNIFORM services.

正確答案: B,D,E

說明：（僅 NewDumps 成員可見）

問題13
Examine this output:

The ACFS disk group has 10 GB free space and the file system is currently mounted.
You execute this command to increase the volume size:
ASMCMD >volresize -G ACFS -s 3G VOL1
Which statement is true regarding the outcome?

A. It fails because the file system must be unmounted before resizing.

B. It succeeds.

C. It fails because the -f option is not specified.

D. It fails because resizing a volume containing an ACFS file system must be performed using ACFSUTIL.

E. It succeeds but the file system is automatically unmounted.

正確答案: D

說明：（僅 NewDumps 成員可見）

問題14
You administer a six-instance, policy-managed, multitenant RAC database CDB1 with three PDBs: PDB_1, PDB_2 and PDB_3.
Server pool prod_pool has a cardinality of three and all six hosts of the cluster app.
Examine these commands executed on HOST01:
$ srvctl add service -db CDB1 -pdb PDB_1 service AR -serverpool prod_pool -cardinality singleton
$ srvctl start service -db CDB1 -service AR
Which two statements are true regarding the AR service?

A. AR can fail over to any other available CDB1 instance in prod_pool.

B. AR runs as a singleton service in the server pool prod_pool and the AR service is available in each of the CDB1 instances.

C. AR can fail over to any one of the available CDB1 instances.

D. AR is available only on the CDB1 instance on HOST01.

E. AR is available on any one available CDB1 instance in prod_pool at any one time.

正確答案: A,E

先試後買

購買之前，你可以先嘗試下載一個試用版本。目前我們只提供PDF版本的試用DEMO，軟件版本只提供截圖。

專業認證

品質保證

輕松通過

Try Before Buy

最新的真實試題

相關鏈接

聯繫我們