2GB of spool space

5GB of spool space

2GB of permanent space

3GB of spool space

WHERE

ORDER BY

GROUP BY

Aggregate Function

MSUM

SUM

AVG

All of the above

Permanent Table

Set Table

Multiset Table

Volatile Table

Indexes are only used in special cases

Indexes are used to make table storage more efficient

Indexes rarely make a difference in SQL performance

Indexes exist solely to improve query speed

The number of CPUs on the server

The degree of parallelism on the tables

The quality of the SQL optimization

The use of bitmap indexes

We are joining two tables only

we are using left and right join together

we are joining table to itself

we are joining more than 2 tables

SELECT * FROM Contest WHERE ContestDate >= '05/25/2006'

SELECT * FROM Contest GROUPBY ContestDate >= '05/25/2006'

SELECT * FROM Contest WHERE ContestDate < '05/25/2006'

SELECT * FROM Contest HAVING ContestDate >= '05/25/2006'

returns all the matching rows from 2 tables.

returns only the rows from the first table, which have non-matching values with the second table in the field on which the 2 tables are joined.

returns all rows from 2 tables.

returns all rows that have matching value in the field on which the 2 tables are joined.

An index is the same as alias.

An index is a special way to join 2 or more tables.

An index is a database table attribute, which speeds-up data search within a table.

An index is a database row attribute, which speeds-up data search within a table.

There is no default value.

DESC

Random

ASC

TRUNCATE Sales TABLE

TRUNCATE * FROM TABLE Sales

TRUNCATE TABLE Sales

TRUNCATE * FROM COLUMN Sales

Removal of data redundancy

The introduction of data redundancy

The introduction of non-first normal form relations

The introduction of SQL*Plus

Access. Constant. Information. Data.

Atomicity. Consistency. Isolation. Durability.

Access. Constraint. Index. Data.

Access. Consistency. Isolation. Data.

UPDATE, DELETE, INSERT and SELECT statements.

UPDATE statements only.

DELETE statements only.

INSERT statements only.

NOT NULL

NULL

Function NVL2 is not defined

None of the above

TRUE

FALSE

UNDEFINED

NULL

%rowtype, %toomanyrows, %found

%found, %notfound, %rowcount

%rowtype, %rowcount, %notfound

None of the above

0

NULL

Results in a compilation error

An exception will be raised

Header

Declarative

Exception

Executable