A.The primary key constraint on BMP_ID must have a name.

B.One of the LONG columns must be changed to a VARCHAR2 or CLOB.

C.The word CONSTRAINT in the foreign key constraint on DEPT_ID must be changed to FOREIGN KEY.

D.The foreign key constraint on DEPT_ID must be defined at the table level instead of the column level.

E.The NOT NULL constraint on ENAME must be defined at the column level instead of the table level.

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

B.SELECT dept_id, STDDEV (last_name), 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, LENGTH (last_name), SUM (salary) FROM employees GROUP BY dept_id

A.SELECT INTERVAL '1' DAY - INTERVAL '1' MINUTE FROM DUAL;

B.SELECT SYSTIMESTAMP + INTERVAL '1' DAY FROM DUAL;

C.SELECT SYSDATE "INTERRVAL '1' DAY FROM DUAL;

D.select INTERVAL '1' DAY +INTERVAL '1' MONTH FROM DUAL;

E.SELECT INTERVAL '1' DAY - SYSDATE FROM DUAL;

A.It executes successfully and introduces an 'sat the end of each promo_namein the output.

B.It executes successfully and displays the literal " {'s start date was \> "for each row in the output.

C.It produces an error because the data types are not matching.

D.It produces an error because flower braces have been used.

A.A DELETE FROM ..... statement can remove rows based on only a single condition on a table.

B.AH INSERT INTO. . .VALUES. . statement can add multiple rows per execution to a table.

C.An UPDATE...SET.... statement can modify multiple rows based on only a single condition on a table.

D.An INSERT INTO...VALUES..... statement can add a single row based on multiple conditions on a table.

E.An UPDATE...SET... statement can modify multiple rows based on multiple conditions on a table.

F.A DELETE FROM..... statement can remove multiple rows based on multiple conditions on a table.