Oracle 1Z0-068 Online Practice Questions and Exam Preparation

Oracle 1Z0-068 Online Questions & Answers

• Question 91:

  Which three options have a RAC-specific tuning component?

  A. contention on index leaf blocks
  B. sequence definitions
  C. the size of the online redo log buffers
  D. contention for online redo log files
  E. contention for archived redo log files
  F. the load on the Cluster Interconnect
  A. contention on index leaf blocks
  C. the size of the online redo log buffers
  F. the load on the Cluster Interconnect

  ---

  A: Contention for data and index blocks in a single instance database will probably magnify in a RAC environment.

  C: A typical cause of high latencies is when the LMS process must flush uncommitted changes to the redo log prior to sending the block to the requesting instance. If the application design is such that uncommitted blocks are often in demand

  across instances in the cluster then these redo log flushes might become common.

  F: Examining the interconnect

  When Global Cache waits are high, we should first determine if the latency is primarily the result of interconnect network waits.

  References: http://www.toadworld.com/platforms/oracle/w/wiki/10939.optimizing-oracle-rac#rac-tuning- principles

• Question 92:

  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. It can be executed only by a common user with the CREATE PLUGGABLE DATABASE system privilege connected to the root container.
  B. The source PDB must use a global temporary tablespace.
  C. The source PDB must be in READ ONLY mode on all CDB instances.
  D. Oracle Managed Files must be enabled or PDB_FILE_NAME_CONVERT must be set.
  E. All running CDB instances must be open in restricted mode.
  F. The source PDB must be closed on the CDB instance from where the command is executed.
  D. Oracle Managed Files must be enabled or PDB_FILE_NAME_CONVERT must be set.
  E. All running CDB instances must be open in restricted mode.
  F. The source PDB must be closed on the CDB instance from where the command is executed.

• Question 93:

  Which three statements are true about Global Resource Management in an Oracle 12c RAC database?

  A. Lazy remastering occurs when an instance shuts with SHUTDOWN IMMEDIATE.
  B. Object remastering causes all blocks in any instances' buffer cache from the same object to be mastered in the Global Resource Directory (GRD).
  C. When a database instance fails, then some global resource masters lost from the failing instance are remastered among the surviving instances.
  D. Lazy remastering instances occurs when an instance shuts with SHUTDOWN TRANSACTIONAL.
  E. Global Enqueue resources are recovered after Global Cache Resources after an instance failure.
  B. Object remastering causes all blocks in any instances' buffer cache from the same object to be mastered in the Global Resource Directory (GRD).
  C. When a database instance fails, then some global resource masters lost from the failing instance are remastered among the surviving instances.
  D. Lazy remastering instances occurs when an instance shuts with SHUTDOWN TRANSACTIONAL.

  ---

  B: Remastering is the term used that describes the operation whereby a node attempting recovery tries to own or master the resource(s) that were once mastered by another instance prior to the failure. When one instance leaves the cluster, the GRD of that instance needs to be redistributed to the surviving nodes. RAC uses an algorithm called lazy remastering to remaster only a minimal number of resources during a reconfiguration.

  D: Using the SHUTDOWN TRANSACTIONAL command with the LOCAL option is useful to shut down a particular Oracle RAC database instance. Transactions on other instances do not block this operation.

  C: Recovery from instance failure is automatic, requiring no DBA intervention. In case of instance failure, a surviving instance can read the redo logs of the failed instance. For example, when using the Oracle Parallel Server, another instance performs instance recovery for the failed instance. In single-instance configurations, Oracle performs crash recovery for a database when the database is restarted, that is, mounted and opened to a new instance. The transition from a mounted state to an open state automatically triggers crash recovery, if necessary.

  Incorrect Answers:

  A: After a NORMAL or IMMEDIATE shutdown, instance recovery is not required. References: https://docs.oracle.com/database/121/RACAD/admin.htm#RACAD8910

• Question 94:

  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_1

  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 3, 4, 5 and 6
  B. 2, 3, 4,5 and 6
  C. 1, 4, 5 and 6
  D. 2, 4, 5 and 6
  E. 1,4 and 6
  F. 2,4 and 6
  A. 1 3, 4, 5 and 6

• Question 95:

  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. One site of an ACFS replication configuration can be host both primary and standby file systems.
  C. Replication is automatically terminated if the primaries file system has less than 2GB free space.
  D. Standby redo log files are required on the standby site for synchronous redo transport.
  E. The privilege SYSREPL has been introduced for ACFS replication.
  B. One site of an ACFS replication configuration can be host both primary and standby file systems.
  C. Replication is automatically terminated if the primaries file system has less than 2GB free space.
  D. Standby redo log files are required on the standby site for synchronous redo transport.

  ---

  B: A site can host both primary and standby file systems.

  C: If the primary file system has less than 2 GB available free disk space, Oracle ACFS attempts to automatically terminate replication on the primary file system.

  D: On the standby system, the remote file server (RFS) receives redo data over the network from the LGWR process and writes the redo data to the standby redo log files.

  Reference: https://docs.oracle.com/database/121/OSTMG/GUID-8522E0B6-BE6E-4BE3-B7C7- 5EA2ED4A602C.htm#OSTMG34600 https://docs.oracle.com/cd/B19306_01/server.102/b14239/log_transport.htm#i1280979

• Question 96:

  Which two types of IP address details are administered using the srvctl command for Oracle Clusterware 12c?

  A. the Grid Naming Service (GNS) VIP
  B. public IP addresses
  C. High Available VIP (HAIP) addresses
  D. Single Client Access Name (SCAN) VIPs
  E. Storage Network IP addresses
  A. the Grid Naming Service (GNS) VIP
  D. Single Client Access Name (SCAN) VIPs

  ---

  A: To convert a cluster that is not running GNS to a GNS server cluster, run the following command as root, providing a valid IP address and a domain:

  # srvctl add gns -vip IP_address -domain domain

  D: Example:

  1.

  Modify the VIP using a VIP name that resolves to IPv6 by running the following command as root:

  # srvctl modify vip -node node_name -address vip_name -netnum network_number Do this once for each node.

  2.

  2. Modify the SCAN using a SCAN name that resolves to IPv6 by running the following command:

  $ srvctl modify scan -scanname scan_name

  Incorrect Answers:

  C: The oifcfg command is used configure HAIP addresses. For example:

  oifcfg setif -global eth3/172.16.2.0:cluster_interconnect

  References: https://docs.oracle.com/database/121/CWADD/admin.htm#CWADD92641

• Question 97:

  Which three statements are true about services when used with transparent application failover (TAF) for an administrator-managed RAC database?

  A. TAF-enabled sessions fail over to a surviving instance accepting logins for the service.
  B. TAF-settings for the service override TAF settings in TNS entry used by the client.
  C. TAF can restart a query or a transaction after failover.
  D. The TAF settings for a client connections overrides any TAF settings in the service definition.
  E. TAF PRECONNECT requires configuration for the service and in the client TNS entry.
  A. TAF-enabled sessions fail over to a surviving instance accepting logins for the service.
  C. TAF can restart a query or a transaction after failover.
  D. The TAF settings for a client connections overrides any TAF settings in the service definition.

  ---

  A: SESSION failover. When the connection to an instance is lost, SESSION failover results only in the establishment of a new connection to another Oracle RAC node; any work in progress is lost. SESSION failover is ideal for online transaction processing (OLTP) systems, where transactions are small.

  C: SELECT failover. With SELECT failover, Oracle Net keeps track of all SELECT statements issued during the transaction, tracking how many rows have been fetched back to the client for each cursor associated with a SELECT statement. If the connection to the instance is lost, Oracle Net establishes a connection to another Oracle RAC node and re-executes the SELECT statements, repositioning the cursors so the client can continue fetching rows as if nothing has happened. The SELECT failover approach is best for data warehouse systems that perform complex and time-consuming transactions.

  D: Oracle's answer to application failover is a new Oracle Net mechanism dubbed Transparent Application Failover. TAF allows the DBA to configure the type and method of failover for each Oracle Net client. Incorrect Answers:

  E: In PRECONNECT failover, the application simultaneously connects to both a primary and a backup node. This offers faster failover, because a pre-spawned connection is ready to use. But the extra connection adds everyday overhead by duplicating connections.

  References: http://www.dba-oracle.com/art_oramag_rac_taf.htm

• Question 98:

  Examine the output of this command: ASMCMD> volinfo A. It resizes VOL1.
  B. It fails to resize the filesystem because it must be unmounted before resizing.
  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 resizes the filesystem mounted on /u01/app/grid/acfsmount.

  A. It resizes VOL1.
  D. It succeeds but leaves the filesystem unmounted.

• Question 99:

  Which three statements are true about Oracle Clusterware components, architecture, and behavior?

  A. The Cluster Ready Services Daemon (CRSD) is responsible for monitoring and maintaining the availability of cluster resources defined in the Oracle Local Repository file (OLR).
  B. All cluster nodes can write or read from the Oracle Clusterware Repository (OCR) file at the same time.
  C. The Oracle High Availability Services Daemon (OHASD) is responsible for monitoring and maintaining the availability of the Clusterware stack on a cluster node.
  D. Voting disks stored in Automatic Storage Management (ASM) can be discovered or used even if the ASM instance on a cluster node is down.
  E. The Cluster Synchronization Services Daemon (CSSD) must connect to the cluster by accessing the Oracle Clusterware Repository (OCR) file before the Oracle High Availability Services Daemon (OHASD) is started.
  F. Time synchronization in an Oracle Cluster is possible without using network Time Protocol (NTP).
  C. The Oracle High Availability Services Daemon (OHASD) is responsible for monitoring and maintaining the availability of the Clusterware stack on a cluster node.
  D. Voting disks stored in Automatic Storage Management (ASM) can be discovered or used even if the ASM instance on a cluster node is down.
  F. Time synchronization in an Oracle Cluster is possible without using network Time Protocol (NTP).

  ---

  F: To activate CTSS in your cluster, you must stop and deconfigure the vendor time synchronization service on all nodes in the cluster. CTSS detects when this happens and assumes time management for the cluster.

  For example, to deconfigure NTP, you must remove or rename the ntp.conf file.

  Incorrect Answers:

  A: The CRS daemon (crsd) manages cluster resources based on the configuration information that is stored in OCR, not the OLR, for each resource.

  B: You must update OCR through supported utilities such as Oracle Enterprise Manager, the Oracle Clusterware Control Utility (CRSCTL), the Server Control Utility (SRVCTL), the OCR configuration utility (OCRCONFIG), or the Database Configuration Assistant (DBCA)

  E: Please refer to the cluster startup picture below.

  

  References: https://docs.oracle.com/cd/E11882_01/rac.112/e41959/intro.htm#CWADD90955

• Question 100:

  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 started and the database instances will be started automatically when restarting the clusterware stack after normal shutdown of the sales database.
  B. The sales database resource will be restored to its previous running condition when restarting the clusterware stack after normal shutdown of the sales database.
  C. The sales database resource will be restarted automatically after an instance failure.
  D. The concurrency values are not shown because sales in not a RAC One Node database.
  E. The concurrency values are not shown because sales has only one of its four instances running.
  B. The sales database resource will be restored to its previous running condition when restarting the clusterware stack after normal shutdown of the sales database.
  D. The concurrency values are not shown because sales in not a RAC One Node database.