Create groups of data

Sort data in a specific order

Convert data to a different format

Retrieve data based on an unknown condition

query will retrieve only one row

authorization failure

no such code available

rollback

TSO

IMC

CICS

None of the above

returns 5 rows

returns 3 rows

returns all 8rows

none

You cannot use IN operator in a condition that involves an outerjoin

You use (+) on both sides of the WHERE condition to perform an outerjoin

You use (*) on both sides of the WHERE condition to perform an outerjoin

You use an outerjoin to see only the rows that do not meet the join condition

In the WHERE condition, you use (+) following the name of the column in the table

You cannot link a condition that is involved in an outerjoin to another condition by

DELETE employees;

DESCRIBE employees;

ROLLBACK TO SAVEPOINT C;

GRANT SELECT ON employees TO SCOTT;

ALTER TABLE employees SET UNUSED COLUMN sal;

Select MAX(sal) FROM employees WHERE department_id = 20;

You can use aggregate functions in any clause of a SELECT statement.

You can use aggregate functions only in the column list of the SELECT clause and in the WHERE clause of a SELECT statement.

You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.

You can pass column names, expressions, constants, or functions as parameters to an aggregate function.

You can use aggregate functions on a table, only by grouping the whole table as one single group.

You cannot group the rows of a table by more than one column while using aggregate functions.

COUNT

SUM

COMPUTE

MIN

TRUE

FALSE

BOTH

NONE

Scalar

LOB

Reference

host

True

False

CASCADE

UNIQUE

NONUNIQUE

CHECK

PRIMARY KEY

NOT NULL

INSERT

UPDATE

SELECT

DESCRIBE

DELETE

RENAME

the use of rowed

a GROUP BY clause

an ORDER BY clause

only an inline view

an inline view and an outer query

UNIQUE

NOT NULL

CHECK

PRIMARY KEY

FOREIGN KEY

creates a view with constraints

creates a view even if the underlying parent table has constraints

creates a view in another schema even if you don't have privileges

creates a view regardless of whether or not the base tables exist

GRANT select ON dept TO ALL USERS;

GRANT select ON dept TO ALL;

GRANT QUERY ON dept TO ALL USERS;

GRANT select ON dept TO PUBLIC;

A MERGE statement is used to merge the data of one table with data from another

A MERGE statement replaces the data of one table with that of another

A MERGE statement can be used to insert new rows into a table

A MERGE statement can be used to update existing rows in a table

Once created, a sequence belongs to a specific schema

Once created, a sequence is linked to a specific table

Once created, a sequence is automatically available to all users

Only the DBA can control which squence is used by certain a table

Once created, a sequence is automatically in all INSERT and UPDATE statements

SELECT text FROM user_source WHERE name ='SALARY_CALC';

SELECT * FROM user_source WHERE source_name ='salary_calc';

SELECT * FROM user_objects WHERE object_name = 'SALARY_CALC';

SELECT text FROM user_source WHERE name='SALARY_CALC' AND owner ='JOHN';