1z1-068試験無料問題集（152題）「Oracle Database 12c: RAC and Grid Infrastructure Administrator 認定」

出題：1

Examine these commands:
srvctl add service -db RACDB -service CRM -preferred RACDB_1 -available RACDB_2 - tafpolicy preconnect srvcl start service -db RACDB -service CRM Instances RACDB_1 and RACDB_2 run on host0l and host02, respectively.
This is the only TNS entry in the client side tnsnames.ora:
CRM =
(DESCRIPTION =(FAILOVER=ON) (LOAD_BALANCE=ON)
(ADDRESS= (PROTOCOL=TCP) (HOST=host0l-VIP.example.com)(PORT=1521))
(ADDRESS= (PROTOCOL=TCP) (HOST=host02-VIP.example.com)(PORT=1521))
(CONNECT_DATA = (SERVICE_NAME = CRM)
(FAILOVER_MODE = (BACKUP=CRM_PRECONNECT)
(TYPE=SESSION)(METHOD=PRECONNECT))))
Which statement is true regarding the TAF settings?

A. Clients using this configuration fail over and restart any active transactions automatically.

B. Clients using this configuration fail over and restart any active queries automatically.

C. This configuration will work only for a policy-managed RAC database.

D. The configuration is incomplete because the TNS entry for the preconnected backup session is missing.

正解：D 解答を投票する

出題：2

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. DNS must be configured to delegate name resolution for the cluster subdomain to the cluster.

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

C. You must create a Grid Management Repository database.

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

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

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

正解：A,D,F 解答を投票する

出題：3

Which three statements are true concerning diagnostic components and requirements of Oracle 12c Clusterware? (Choose three.)

A. There is one ologgered service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.

B. There is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.

C. The Grid Infrastructure Management Repository database must run on a hub node if Flex Clusters are used.

D. The oclumon utility may be used to get and set parameters for the cluster health monitor (CHM) repository.

E. The diagcollection.pl script must be run from the Grid home directory as the Grid infrastructure owner.

F. The clusterware log files are stored inside the Grid Infrastructure Management Repository database used by the cluster health monitor (CHM).

正解：B,C,D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：4

Which two statements are true about clustered ASM instances? (Choose two.)

A. The SPFILE must be stored in $GRID_HOME/dbs on local storage of a cluster node.

B. The ASM passwordfile can be stored in $GRID_HOME/dbs on local storage of a cluster node.

C. The ASM passwordfile can be stored in a diskgroup that is accessible to all ASM instances.

D. An ASM instance must store its SPFILE in ASM.

E. The SPFILE must be stored in a diskgroup that is accessible to all ASM instances.

正解：A,D 解答を投票する

出題：5

Which three statements are true about Oracle Flex ASM? (Choose three.)

A. An ASM instance can run on a leaf node.

B. ASM clients can fail over to other ASM instances.

C. Only three ASM instances are supported in Flex ASM.

D. The SPFILE and password file for ASM are stored by default in an ASM disk group.

E. A designated network is used for communication between ASM instances and theirclients.

F. It always requires a Flex cluster.

正解：B,D,E 解答を投票する

出題：6

Which two statements are true about vsam views in a clustered environment
?

A. gvasm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in the cluster.

B. They exist both in ASM and RDBMS instances, and display the same output.

C. Their names can be seen in vfixed_table when connected to an instance of any type that is started.

D. They exist in both in ASM and RDBSM instances, but they can display different outputs depending on the instance type.

E. Their names can be seen in dict when connected to an ASM instance.

正解：D,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：7

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

A. ACFS auditing information is replicated from the primary file system to the standby file system.

B. Replication is automatically terminated if the primary file system has less than 2GB free space.

C. One site of an ACFS replication configuration can be host both primary and standby file systems.

D. The privilege SYSREPL has been introduced for ACFS replication.

E. Standby redo log files are required on the standby site for synchronous redo transport.

正解：B,C,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：8

Which three statements are true about the Global Enqueue Service and Global Enqueue Service (GES) Resources in Oracle 12c RAC?

A. The mastering instance for a GES resource is never the same as the instance that owns an enqueue in shared mode.

B. The LMD0 process on the requesting instance communicates with the LMD0 process on the mastering instance if they are not the same instance.

C. The LMD0 runs only on the instance that masters all GES resources.

D. When a GES resource is dequeued, converters if any exist for that resource, are processed before any waiter for that resource.

E. An LMD0 process runs on all instances.

F. The mastering instance for a GES resource is never the same as the instance that owns the enqueue in exclusive mode.

G. The foreground process on the requesting instance communicates with the LMD0 process on the mastering instance if they are not the same instance.

正解：A,B,G 解答を投票する

出題：9

Which three statements are true about Oracle 12 RAC Database software installations?

A. The RAC database 12c software home and Grid Infrastructure homes must be owned by the same OS user.

B. It is possible to install RAC database software on a one node cluster.

C. It is possible to install multiple RAC database 12c software homes on the same cluster.

D. The RAC database 12c software home and Grid infrastructure homes must be owned by separate OS users.

E. The Cluster Verification Utility (CLUVFY) must be used to check the cluster before installing the RAC database software.

F. The Cluster Verification Utility (CLUVFY) must be used to check the cluster after installing the RAC database software.

正解：B,C,E 解答を投票する

出題：10

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

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

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

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

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

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

正解：A,B,E 解答を投票する

出題：11

You administer a three-instance, policy-managed, multitenant RAC database CDB1 with two PDBs: PDB_1 and PDB_2.
Examine these commands executed on host01:
$ srvctl add service -db CDB1 -pdb PDB_1 -serverpool prod_pool -cardinality singleton
$ srvctl start service -db CDB1 -service CRM
$ srvctl stop service -db CDB1 -service CRM
Which three statements are true?

A. The srvctl start service command automatically opens PDB_1 if not already opened.

B. The CRM service is not available for new logins on any instance of CDB1.

C. CRM is only available for new logins on the CDB1 instance on host01.

D. The srvctl stop service command does not close PDB_1 on any instance of CDB1.

E. CRM is available for new logins on one CDB1 instance.

正解：A,B,D 解答を投票する

1z1-068試験無料問題集「Oracle Database 12c: RAC and Grid Infrastructure Administrator 認定」