A.Savepoints may be used to ROLLBACK.

B.Savepoints can be used for only DML statements.

C.Savepoints are effective only for COMMIT.

D.Savepoints are effective for both COMMITand ROLLBACK.

E.Savepoints can be used for both DML and DDL statements.

A.Statement 2 would not execute because system privileges and object privileges cannot be granted together in a single GRANT command.

B.Statement 1 would not execute because the IDENTIFIED BY <password> clause is missing.

C.Statement 3 would not execute because role and system privileges cannot be granted together in a single GRANT statement.

D.Statement 1 would not execute because the WITH GRANT option is missing.

A.An INSERT INTO...VALUES.. statement can add multiple rows per execution to a table.

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

C.A DELETE FROM..... statement can remove 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.A DELETE FROM..... statement can remove multiple rows based on multiple conditions on a table.

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

A.COUNT(DISTINCT inv_amt) returns the number of rows excluding rows containing duplicates and NULLs in the INV_AMT column.

B.COUNT(inv_amt) returns the number of rows in a table including rows with NULL in the INV_AMT column.

C.COUNT(*) returns the number of rows including duplicate rows and rows containing NULL value in any column.

D.It can only be used for NUMBER data types.

E.A SELECT statement using the COUNT function with a DISTINCT keyword cannot have a WHERE clause.

A.invoice_date> '01-02-2019': uses implicit conversion

B.qty_sold BETWEEN '101' AND '110': uses implicit conversion

C.qty_sold ='05549821 ': requires explicit conversion

D.invoice_date = '15-march-2019': uses implicit conversion

E.CONCAT(qty_sold, invoice_date): requires explicit conversion