(a) AVG

(b) COUNT

(c) STDEV

(d) COUNT_BIG

(a) Full outer join

(b) Inner join

(c) Right outer join

(d) Left outer join

(a) AS

(b) STR

(c) FROM

(d) COLUMN

A. SELECT TO CHAR(8000,’$#,###.##’) FROM DUAL;

B. SELECT TO CHAR(8000,’$0,000.00’) FROM DUAL;

C. SELECT TO CHAR(8000,’$9,999.00’) FROM DUAL;

D. SELECT TO CHAR(8000,’$9,999.99’) FROM DUAL;

E. SELECT TO CHAR(8000,’$8,000.00’) FROM DUAL;

F. SELECT TO CHAR(8000,’$N,NNN.NN’) FROM DUAL;

At the beginning of the list

At the end of the list

In the middle of the list

At the same location they are listed in the unordered table

The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist

The ROLLBACK statement frees the storage space occupies by the DEPT table

The DESCRIBE DEPT statement displays the structure of the DEPT table

The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement

TIMESTAMP

INTERVAL MONTH TO DAY

TIMESTAMP WITH DATABASE TIMEZONE

INTERVAL YEAR TO MONTH

INTERVAL DAY TO SECOND

USER_TAB_PRIVS_MADE

USER_TAB_PRIVS

USER_COL_PRIVS_MADE

USER_COL_PRIVS

The SQL statement displays the desired results

The operator in the WHERE clause should be changed to display the desired results

The WHERE clause should be changed to use an outer join to display the desired results

The column in the WHERE clause should be changed to display the desired results

Database

Each File

Both a & b

None

True

False

ASCII files

comma separated list

excel spreadsheet

All the above

.XFR

.TXT

.DML

None of the above

Ramp

Limit

Check-sort

Reject - Threshold

True

False

10

20

15

5

Implicit

Explicit

inner join

Outer join

8388806

3866086

8388608

None of the above

Writes the record to the reject port

Writes a descriptive error message to the error port

Discards the information if you do not connect flows to the reject or error ports

Processes all records

Abort on any error

Abort after 50 errors

Abort if more than 2 in 100

Abort if more than 1 in 100