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

B.SELECT dept_id, AVG(NAX(salary)) FROM employees GROUP BY dept_id;

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

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

A.When the MAXVALUElimit for the sequence is reached, you can increase the MAXVALUElimit by using the ALTERSEQUENCEstatement.

B.DELETE <sequencename>would remove a sequence from the database.

C.The numbers generated by a sequence can be used only for one table.

D.CURRVALis used to refer to the last sequence number that has been generated.

E.When a database instance shuts down abnormally, the sequence numbers that have been cached but not used would be available once again when the database instance is restarted.

A.All roles are owned by the sYs schema.

B.A role is owned by the user who created it.

C.PUBIIC can be revoked from a user.

D.PUBLIC acts as a default role granted to every user in a database.

E.A user has all object privileges for every object in their schema by default.

F.A role can contain a combination of several privileges and roles.

G.System prilgese always set prilge for an entire database.

A.All indexes defined on HR, EMPLOYEES are dropped.

B.Views referencing HR, EMPLOYEES are dropped.

C.The HR. EMPLOYEES table may be moved to the recycle bin.

D.Sequences used to populate columns in the HR. EMPLOYEES table are dropped.

E.ALL constraints defined on HR, EMPLOYEES are dropped.

F.Synonyms for HR EMPLOYEES are dropped.

A.ALTER TABLE productsADD price NUMBER(8,2) DEFAULT 0 NOT NULL;

B.ALTER TABLE productsADD price NUMBER(8,2) DEFAULT CONSTRAINT p_nn NOT NULL.

C.ALTER TABLE productsADD price NUMBER(8,2) NOT NULL;

D.ALTER TABLE productsADD price NUMBER(8,2) DEFAULT NOT NULL;