PCTFREE defaults to 10% for all blocks in all segments for all compression methods

ASSM assigns blocks to one of four fullness categories based on what percentage of the block is allocated for rows

Update operations always attempt to find blocks with free space appropriate to the length of the row being updated

Insert operations always attempt to find blocks with free space appropriate to the length of the row being inserted

A block will always be eligible for inserts if the row is short enough to fit into the block

Views can be updated without the need to re-grant privileges on the view

Tables in the defining query of a view must always exist in order to create the view

The WITH CHECK clause prevents certain rows from being displayed when querying the view

Data Manipulation Language (DML) can always be used on views

Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error

Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error

The WITH CHECK clause prevents certain rows from being updated or inserted

SELECT & & col1, & & col2FROM & tableWHERE & & condition = & & cond;

SELECT & col1, & col2FROM & & tableWHERE & condition;

SELECT & col1, & col2FROM “ & table”WHERE & condition;

SELECT ‘ & & col1’, ‘ & & col2’FROM & tableWHERE ‘ & & condition’ = ‘ & cond’;

SELECT & & col1, & & col2FROM & tableWHERE & & condition;

COLUMN STORE COMPRESS FOR QUERY LOW

ROW STORE COMPRESS BASIC

COLUMN STORE COMPRESS FOR ARCHIVE LOW

COLUMN STORE COMPRESS FOR ARCHIVE HIGH

ROW STORE COMPRESS ADVANCED

The generation of UNDO generates REDO

DML modifies Oracle database objects and only generates UNDO

The generation of REDO generates UNDO

DML modifies Oracle database objects and only generates REDO

DML modifies Oracle database objects and generates UNDO and REDO

Table aliases can improve performance

The BETWEEN condition always performs better than using the > = and < = conditions

The join syntax used makes no difference to performance

The BETWEEN condition always performs less well than using the > = and < = conditions

The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax

It must be the value of the SERVICE_NAMES parameter on the client side

It must resolve to a valid connect descriptor in the server’s tnsnames.ora file

It must resolve to a valid connect descriptor in the client’s tnsnames.ora file

It must be the name of the database to whose instance HR wishes to connect

It must be the name of the server running the database to whose instance HR wishes to connect

The Oracle Net Configuration Assistant is only used when running the Oracle installer

Oracle Net Manager can be used to centrally configure listeners on any database server target

The lsnrctl utility requires a listener.ora file to exist before it is started

Oracle Net Manager can be used to locally configure naming methods on a database server

Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server

Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target

It displays the PRIMARY KEY constraint for any column or columns that have that constraint

It can be used from SQL Developer

It displays the NOT NULL constraint for any columns that have that constraint

It can be used to display the structure of an existing view

It displays all constraints that are defined for each column

It can be used only from SQL*Plus

The primary key constraint will be enabled and deferred.

The foreign key constraint will be enabled and deferred.

The foreign key constraint will be disabled.

The foreign key constraint will be enabled and immediate.

The primary key constraint will be enabled and immediate.