C. Examples of DML, or data manipulation commands, include INSERT, UPDATE, and DELETE. DDL, or data definition language commands, include CREATE, ALTER, or DROP. DCL, or data control language commands, include GRANT and REVOKE.

B. Transactions are ended when the transaction is either committed using the COMMIT command, or rolled back using the ROLLBACK command.

C. Tables with a Primary Key constraint on them require that any rows inserted into the table have a value that is unique and not null for the primary key column.

C. SQL does not provide any condition testing or looping capabilities. Oracle provides PL/SQL to allow for these types of programming constructs.

D. Oracle 10g requires 1.5GB of free disk space for installation. An additional 1GB is required if a sample database is created using the OUI.

D. The tasks that a DBA performs encompass all these areas plus managing database storage, security, and availability.

D. iSQL*Plus can be used to access databases on both Unix and Windows servers, as can SQL*Plus.

B. The $ORACLE_HOME environment variable would point to the location where the Oracle binaries should be installed.

A. The SQL WHERE clause qualifies the results of the query and limits the rows that are returned to those that match the condition specified in the WHERE clause.

C. The ALL_TABLES view displays information about the tables that the user owns or has been granted access to. The DBA_TABLES view displays information about all tables in the database. The USER_TABLES view shows only information about the user's own tables. There is no view called MY_TABLES.

A. Setting SGA_TARGET to a nonzero value in the PFILE or SPFILE allows the automated memory management feature to dynamically assign space to these four areas of the SGA.

C. Although PFILEs and SPFILEs are physical files used to configure the Oracle instance, they are not considered part of the database.

C. Every database must have at least two redo log files, which may or may not be multiplexed.

D. The LRU mechanism ensures that each user's Server Process can find free space in the Shared Pool and Database Buffer Cache whenever they need it, but also keeps frequently used objects cached in those memory areas.

A. The instance consists of the SGA and all the Oracle background processes. The database is composed of the control files, datafiles, and redo logs.

B. Multiple operating system blocks make up database blocks, contiguous chunks of which make up extents, which comprise segments.

D. While the Unix system administrator is responsible for creating volume groups and mount points, the DBA generally decides where the Oracle binaries will be installed—the location designated by the $ORACLE_HOME environment variable.

A. The OFA model does not include any reference to naming conventions for things inside the database, such as users, tables, or tablespaces.

B. The runInstaller executable performs a preinstall check of the operating system and hardware resources before starting the OUI graphical tool.

D. The root.sh script copies configuration files to directories outside $ORACLE_HOME and sets the permissions on those files accordingly.