Oracle Oracle Database 1Z0-068 Questions & Answers

• Question 111:

  You plan to create a three-instance RAC database stored in ASM, with its data files in the DATA disk group.

  Identify three supported storage solutions for the Fast Recovery Area (FRA).

  A. a shared nothing file system accessed directly by the database instances

  B. a cluster file system

  C. a shared NFS file system D. the DATA disk group

  E. a local file system with the same path name on each cluster node

  Correct Answer: BCD

  Section: (none)

  There are special considerations for choosing a location for the flash recovery area in a RAC environment. The location must be on a cluster file system, ASM or a shared directory configured through NFS. The location and disk quota must be

  the same on all instances.

  References: https://docs.oracle.com/cd/B19306_01/backup.102/b14192/setup005.htm

• Question 112:

  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.

  Correct Answer: ACD

  Section: (none)

  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 113:

  Which two statements are true about Quality of Service Management?

  A. It can enable a more efficient sharing of hardware resources.

  B. It can improve the performance of SQL statements.

  C. It can improve system stability as the workload changes.

  D. It can improve the performance of PL/SQL.

  E. It can reduce the load on the system caused by Oracle background processes.

  Correct Answer: AC

  Section: (none)

  Oracle Database QoS Management provides the following benefits:

  Enables more effective sharing of hardware resources

  Provides stability to the system as the workloads change

  Note: More benefits are:

  Reduces the time and expertise requirements for system administrators who manage Oracle Real

  Application Clusters (Oracle RAC) resources Helps reduce the number of performance outages

  Reduces the time needed to resolve problems that limit or decrease the performance of your

  applications Makes the addition or removal of servers transparent to applications

  Reduces the impact on the system caused by server failures

  Helps ensure that service-level agreements (SLAs) are met

  Reference: https://docs.oracle.com/cd/E11882_01/server.112/e24611/apqos_intro.htm#APQOS268

• Question 114:

  After creating a RAC One Node database using SQL statements, you want to register this database with Oracle Clusterware as a policy-managed resource.

  Which command, or sequence of commands, should you use?

  A. srvctl add srvpool 璼erverpool ron 璱mportance 100 璵in 2 璵ax 2 璼ervers 016n1, 016n2 srvctl add db 璬b ron 璷raclehome $ORACLE_HOME 璬btype raconenode 璼erverpool ron

  B. srvctl add db 璬b ron 璷raclehome $ORACLE_HOME 璬btype raconenode 璼erver 016n1, 016n2

  C. srvctl add db 璬b ron 璷raclehome $ORACLE_HOME 璬btype raconenode 璼erverpool ron 璼erver 016n1, 016n2

  D. srvctl add srvpool 璼erverpool ron 璱mportance 100 璵in 2 璵ax 2 璼ervers 016n1, 016n2 srvctl add db 璬b ron 璷raclehome $ORACLE_HOME 璬btype raconenode 璼erver 016n1, 016n2

  Correct Answer: C

  Section: (none)

  If your Oracle RAC One Node database did not register automatically with Oracle Clusterware, then use the srvctl add database command to add an Oracle RAC One Node database to your cluster.

  For example:

  srvctl add database -c RACONENODE [-e server_list] [-i instance_name] [-w timeout]

  When you add services to a policy-managed Oracle RAC One Node database, SRVCTL does not accept any placement information, but instead configures those services using the value of the SERVER_POOLS attribute.

  Note: Use the srvctl add database command to add an Oracle RAC One Node database to your cluster.

  For example:

  srvctl add database -c RACONENODE [-e server_list] [-i instance_name] [-w timeout]

  * -c {RACONENODE | RAC | SINGLE}

  The type of database you are adding: Oracle RAC One Node, Oracle RAC, or single instance.

  Reference: https://docs.oracle.com/cd/E11882_01/rac.112/e41960/onenode.htm#RACAD8194

• Question 115:

  PROD1, PROD2 and PROD3 are three instances that have multitenant container database PROD open.

  PROD contains multiple PDBs.

  Examine these successful commands:

  $ srvctl add service 璬b PROD 璸db PRDPDB1 璼ervice SRVPDB1 $ srvctl start service 璬b PROD 璼ervice SRVPDB1

  Which statement is true about the srvctl start service command?

  A. It opens the PRDPDB1 PDB if not already opened.

  B. It can open the PRDPDB1 PDB only if it is policy managed.

  C. It can open the PRDPDB1 PDB automatically.

  D. It can open the PRDPDB1 PDB only if it is manually managed.

  Correct Answer: B

  Section: (none)

• Question 116:

  Which method can be used to convert a single-instance Oracle 12c Database to a RAC Database?

  A. using DBCA to migrate the database to shared storage and then start one or more RAC database instances on the cluster

  B. using DBCA to create a template from the single-instance database and then to create a RAC database on the cluster using that template

  C. using the rconfig utility to create a template from the single-instance database and then using DBCA to create a RAC database on the cluster using that template

  D. using the rconfig utility to migrate the database to shared storage and then using DBCA to start one or more RAC database instances on the cluster.

  Correct Answer: A

  Section: (none)

• Question 117:

  Which three are benefits of using RAC One Node in Oracle 12c?

  A. automatic failover for high availability

  B. ability to perform rolling patches

  C. online conversion from RAC One Node databases to multi-instance RAC databases

  D. load-balancing of services within a single instance

  E. online-conversion from non-RAC databases to RAC One Node databases

  F. multiple instances of the same database on a single node to protect against instance failure

  Correct Answer: BCF

  Section: (none)

  Oracle Real Application Clusters One Node is a single instance of an Oracle Real Application Clusters- enabled database running on one node in a cluster. It lets you consolidate multiple databases onto a single cluster and thereby adds to

  the flexibility that Oracle offers for database consolidation while reducing management overhead by providing a standard deployment for highly available Oracle Database editions.

  Overview

  Failover cluster protection for unplanned downtime

  Online Database Relocation for workload management

  Online database patching to reduce planned downtime

  (C) Online upgrade to Oracle RAC for full scalability

  Benefits

  (F) Protection from unplanned database or system failures

  (B) Rolling upgrades and patches for your OS and database

  Standard management for highly available Oracle Databases

  Online Databases Relocation for database virtualization

  References: http://www.oracle.com/us/products/database/options/rac-one-node/overview/index.html

• Question 118:

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

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

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

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

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

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

  Correct Answer: BCD

  Section: (none)

  B: Database services should be created as UNIFORM services, meaning the service is offered by every available instance running in the specified server pool. If your application requires a SINGLETON service, then, to use Oracle Database

  QoS Management in management mode, the service must run in a server pool that has a maximum size of one. If you use a SINGLETON service in a server pool that has a maximum size greater than one, then Oracle Database QoS

  Management reports a configuration violation.

  C: Initial QoS configuration includes:

  Installing and Configuring Oracle Grid Infrastructure for a Cluster

  Creating and Configuring Server Pools

  Creating and Configuring an Oracle RAC Database

  Enabling Oracle Database QoS Management

  Incorrect Answers:

  E: It must be policy managed. When you use DBCA to create an Oracle RAC database, you select policy- managed for the database, and choose the server pools which the database instances should run in.

  References: https://docs.oracle.com/cd/E11882_01/server.112/e24611/install_config.htm#APQOS157 https://docs.oracle.com/database/121/APQOS/wlm_strats.htm#APQOS341

• Question 119:

  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

  Correct Answer: ACF

  Section: (none)

  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 120:

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

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

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

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

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

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

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

  Correct Answer: ADF

  Section: (none)

  A: An Oracle home is the directory in which you install Oracle Database binaries, and from which Oracle Database runs. Use Oracle Appliance Manager (through oakcli commands) to create and manage multiple Oracle homes and databases on Oracle Database Appliance. Oracle Database Appliance supports multiple Oracle Homes including different versions for Oracle Database 11g Release 2, 11gR2 and Oracle Database Release 12c Release 1.

  D: You can use Cluster Verification Utility (CVU) to assist you with system checks in preparation for starting an upgrade.

  F: The same user that owned the earlier release Oracle Grid Infrastructure software must perform the Oracle Grid Infrastructure 12c Release 1 (12.1) upgrade. Before Oracle Database 11g, either all Oracle software installations were owned by the Oracle user, typically oracle, or Oracle Database software was owned by oracle, and Oracle Clusterware software was owned by a separate user, typically crs.

  Reference:

  https://docs.oracle.com/cd/E22693_01/doc.12/e55580/dbadmin.htm#CHDJIBEE https://docs.oracle.com/database/121/CWLIN/procstop.htm#CWLIN517