Tag: databases

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