Group functions on columns ignore NULL values.

Group functions on columns returning dates include NULL values

Group functions on columns returning numbers include NULL values.

Group functions on columns cannot be accurately used on columns that contain NULL values.

True

False

USER_OBJECTS

USER_PROCEDURES

USER_PROCS

USER_PLSQL_UNITS

True

False

CREATE OR REPLACE PROCEDURE <> as

CREATE OR REPLACE PROCEDURE <>(Parameter list) as

CREATE OR REPLACE PROCEDURE <> is

All of the above

When a parameter is passed as an IN variable it is passed by reference

When variables are passed in OUT or INOUT mode it is pass by value

The NOCOPY clause tells to PL/SQL engine to pass the variable by reference

All of the above

Use the DBMS_MANAGE_LOB.MIGRATE procedure

Use the UTL_MANAGE_LOB.MIGRATE procedure.

Use the ALTER TABLE command

You cannot migrate from a LONG to a LOB date type for a column

FOR EACH ROW trigger on the EMP table.

Statement-level trigger on the EMP table.

FOR EACH ROW trigger on the AUDIT_TABLE table.

Statement-level trigger on the AUDIT_TABLE table.

True

False

True

False

The tablespace must be online

The tablespace must not contain any active rollback segments

he tablespace must not be involved in an open backup

All of the above

IN

OUT

IN OUT

All of the above

DROP TRIGGER T1

DELETE TRIGGER T1

ALTER TRIGGER T1 DISABLE

None of the above

True

False

The Default tablespace

The temp tablespace

The SYSTEM tablespace

None of the above

in the INTO clause of an INSERT statement

in the GROUP BY clause of a SELECT statement

in the VALUES clause of an INSERT statement

in the ORDER BY clause of a SELECT statement

to move data from one data source to another

powerful ETL tool

To design various kind of reports

to provide business information to a wider audience within an organization

Selects the total number of orders from the Sales table, if this number is greater than 5

Selects all customers from table Sales that have made more than 5 orders.

Selects all Customers from the Sales table

None of the above

TRUNCATE Sales TABLE

TRUNCATE * FROM TABLE Sales

TRUNCATE TABLE Sales

All the above

A process for data export/import.

A set of SQL statements stored and executed as a single entity.

A process to convert tables.

Data stored in a database.