The tablespace must be offline

The tablespace must be online

The tablespace cannot have active segments

The administrator NOT needs the correct system privilege

sysdate

Truncate

avg

To_date

"SELECT"

"_Marketing"

m364DaYs

SELECT

SELECT last_name FROM employees WHERE last_name LIKE '%A_B%' ESCAPE '\';

SELECT last_name FROM employees WHERE last_name LIKE '%A_B%' ESCAPE;

SELECT last_name FROM employees WHERE last_name LIKE 'A_B%' ESCAPE '%';

SELECT last_name FROM employees WHERE last_name LIKE '%A_B%' ESCAPE '\';

any outer join

a left outer join

a cross join

a right outer join

SUM(start_date)

AVG(start_date)

COUNT(start_date)

MIN(start_date)

SELECT TO_DATE (SYSDATE, 'FMDAY, DD Month, YYYY') FROM dual;

SELECT TO_CHAR (SYSDATE, 'FMDD, DY Month, YYYY') FROM dual;

SELECT TO_CHAR (SYSDATE, 'FMDay, DD Month, YYYY') FROM dual;

SELECT TO_CHAR (SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;

DELETE employees;

DESCRIBE employees;

ROLLBACK TO SAVEPOINT C;

ALTER TABLE employees SET UNUSED COLUMN sal;

GRANT SELECT ON employees TO SCOTT;

none

DELETE, INSERT, SELECT

ALTER, DELETE, INSERT, SELECT

DELETE, INSERT, SELECT, UPDATE

DROP

DELETE

CASCADE

TRUNCATE

Primary key access

Access via unique index

Table access by ROWID

Full table scan

INSTR

SUBSTR

SUBSTRING

POS

System tablespace

Users tablespace

Default tablespace for the user

Oracle will give an error

Undefined

*

#

/

-

@

21-AUG-09

28-AUG-09

04-SEP-09

29-AUG-09

27-AUG-09

8

3

5

There is no such criteria

Column

1966_Invoices

Catch_#22

#Invoices

None of the above

the process of arranging information stored in a database in a way, which removes redundancy and ambiguity.

a special way of selecting data

the process of adding primary key to a table

All the above

a special type of store procedure, executed when certain event occurs

a special type of table

a special type of view

All the above

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

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

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

none of the above