A.SELECT dept_id, LENGTH (last_name), SUM (salary) FROM employees GROUP BY dept_id

B.SELECT dept_id, INSTR (last_name,'A'), SUM (salary) FROM employees GROUP BY dept_id

C.SELECT dept_id, MAX (Last_name), SUM (salary) FROM employees GROUP BY dept_id

D.SELECT dept_id, STDDEV (last_name), SUM (salary) FROM employees GROUP BY dept_id

A.When a row in the BOOKS table is deleted, the rows in the BOOK_TRANSACTIONS table whose BOOK_ID matches that of the deleted row in the BOOKS table are also deleted.

B.When the BOOKS table is dropped, all the rows in the BOOK_TRANSACTIONS table are deleted but the table structure is retained.

C.When the BOOKS table is dropped, the BOOK_TRANSACTIONS table is dropped.

D.When a value in the BOOKS.BOOK_ID column is deleted, the corresponding value is updated in the BOOKS_TRANSACTIONS.BOOK_ID column.

A.It would give an error because the USING INDEX clause cannot be used on a composite primary.

B.It would give an error because the USING INDEX is not permitted in the CRETAE TABLE command.

C.It would execute successfully and two indexes ORD_ITM_IDX and ORD_ITM_ID PK would be created.

D.It would execute successfully and only ORD_ITM_IDX index would be created.

A.Both ROLLBACK commands restore the 101 rows that were deleted.

B.Both ROLLBACK commands restore the 100 rows that were deleted.

C.The first rollback restores the 101 rows that were deleted and the second rollback causes the row was inserted to be deleted and commits the changes.

D.The first rollback restores the 100 rows that were deleted and the second rollback commits only the changes.

A.It executes successfully but does not give the correct output.

B.It generates an error because the concatenation operator can be used to combine only two items.

C.It generates an error because the usage of the ROUND function in the expression is not valid.

D.It generates an error because the alias is not valid.

E.IT executes successfully and gives the correct output.