A.It can be used to join a maximum of three tables.

B.It can be used to restrict the number of columns used in a NATURALjoin.

C.It can be used to join tables that have columns with the same name and compatible data types.

D.It can be used to access data from tables through equijoins as well as nonequijoins.

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

B.An uncommitted transaction commits automatically if the user exists SQL*Plus.

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

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

E.If a session has an uncommitted transaction, then a DDL statement issues a COMMITbefore starting a new transaction.

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

A.The statement produces an error because ITEM_CNTcannot be displayed in the outer query.

B.The statement produces an error because the GROUP BYclause cannot be used in a subquery in the FROMclause.

C.The statement produces an error because a subquery in the FROMclause and outer-joins cannot be used together.

D.The statement executes successfully and produces the required output.

A.join_date;
SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;

B.SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id,

C.SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;

D.SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;

A.second normal form

B.first normal form

C.third normal form

D.fourth normal form