Correct Answer: BCE

Section: (none)

B: For an Oracle RAC CDB, one active undo tablespace exists for each instance.

C: From a physical perspective, a CDB has basically the same structure as a non-CDB, except that each PDB has its own set of tablespaces (including its own SYSTEM and SYSAUX tablespaces) and data files.

References: https://docs.oracle.com/database/121/CNCPT/cdblogic.htm#CNCPT89268

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

Correct Answer: BE

Section: (none)

When installed, the Oracle Preinstallation RPM does the following:

As needed, sets sysctl.conf settings, system startup parameters, and driver parameters to values

based on recommendations from the Oracle Preinstallation RPM program Creates an oracle user, and creates the oraInventory (oinstall) and OSDBA (dba) groups for that user

Automatically downloads and installs any additional RPM packages needed for installing Oracle Grid

Infrastructure and Oracle Database, and resolves any dependencies Sets hard and soft resource limits

Sets other recommended parameters, depending on your kernel version

Note: The Oracle RPMs for your Oracle Linux distributions and Oracle RDBMS releases automatically install any additional packages needed for installing Oracle Grid Infrastructure and Oracle Database, and configure your server operating system automatically, including setting kernel parameters and other basic operating system requirements for installation.

References: https://docs.oracle.com/database/121/LADBI/pre_install.htm#LADBI7493

Correct Answer: BE

Section: (none)

B: The srvctl predict filesystem command predicts the consequences of file system failure.

E: The acfsutil info fs command displays detailed Oracle ACFS file system information, such as: iscorrupt - 1 if the file system is corrupt, 0 if file system is not corrupt.

Incorrect Answers:

A: ASMCMD is a command-line utility that you can use to manage Oracle ASM instances, disk groups, file access control for disk groups, files and directories within disk groups, templates for disk groups, and volumes.

C: There is no crsctl fail command.

There is a crsctl eval fail resource command to predict the consequences of a resource, not the file system, failing.

D: Oracle ASM Configuration Assistant (ASMCA) supports installing and configuring Oracle ASM instances, disk groups, volumes, and Oracle Automatic Storage Management Cluster File System (Oracle ACFS). In addition, you can use the

ASMCA command-line interface as a non-GUI utility.

F: advmutil canonical displays the canonical name of the specified Oracle ADVM device name. dvmutil tune displays the value of a specific Oracle ADVM parameter or sets the value of a specific Oracle ADVM parameter.

advmutil volinfo displays information about Oracle ADVM volume devices.

References:

https://docs.oracle.com/database/121/RACAD/srvctladmin.htm#sthref1656 https://docs.oracle.com/cd/E11882_01/server.112/e18951/asmfs_util010.htm#OSTMG95207

Correct Answer: BC

Section: (none)