A.It contains the system privileges granted to other users by the current User session.

B.It contains the object privileges granted to other users by the current user session.

C.It contains the current object privileges available in the user session.

D.It contains the current system privileges available in the user session.

A.A session can always see uncommitted updates made by itself.

B.A user can always see uncommitted updates made by the same user in a different session.

C.Data Manipulation Language (DML) statements always start a new transaction.

D.A Data Definition Language (DDL) statement does a commit automatically only for the data dictionary updates caused by the DDL

E.If a session has an uncommitted transaction, then a DDL statement issue a COMMIT before starting a new transaction.

F.An uncommitted transaction commits automatically if the user exits SQL*Plus

A.Operators are evaluated before conditions.

B.|| has a higher order of precedence than +(addition)

C.AND and OR have the same order of precedence in a condition

D.NOT has a higher order of precedence than AND and OR in a condition.

E.+ (addition) has a higher order of precedence than * (mliplpition)

A.SELECT
FROM emp80
WHERE department_ id = 90;

B.SELECT
FROM emp80
WHERE department. id = 80;

C.UPDATE emp80
SET department. 1d =80;
WHERE department_ id =90;

D.DELETE FROM emp80
WHERE department_ id = 90;

A.A NOT NULL Constraint can be defined at the table level.

B.A PRIMARY KEY Constraint can be added after a table has been created and populated.

C.A FOREIGN KEY Column can contain NULLS.

D.A UNIQUE constraint permits NULLS.

E.A Column can have only one CHECK Constraint.

F.A UNIQUE Constraint can use a pre-existing index on the constrained column or columns.

G.A CHECK Constraint can refer to values in other rows.