A.SELECT cust_first_nameFROM customersWHERE INSTR(cust_first_name, 'e')<>'' ANDSUBSTR(cust_first_name, -2, 1)='a';

B.SELECT cust_first_nameFROM customersWHERE INSTR(cust_first_name, 'e')<>0 ANDSUBSTR(cust_first_name, -2, 1)='a';

C.SELECT cust_first_nameFROM customersWHERE INSTR(cust_first_name, 'e')<>0 ANDSUBSTR(cust_first_name, LENGTH(cust_first_name), -2)='a';

D.SELECT cust_first_nameFROM customersWHERE INSTR(cust_first_name, 'e')IS NOT NULL ANDSUBSTR(cust_first_name, 1, -2)='a';

A.Aggregate functions can be nested to any number of levels

B.The AVG function implicitly converts NULLS to zero

C.Aggregate functions can be used in any clause of a SELECT statement

D.The MAX and MIN functions can be used on columns with character data types

A.DELETEand TRUNCATEstatements remove all indexes for the tables on which they are performed.

B.DELETE but not TRUNCATEstatement can be used to remove data from selective columns and rows of a table.

C.DELETEbut not TRUNCATEstatement can be used to selectively remove rows from a table.

D.DELTEand TRUNCATEstatements can have a rollback done to restore data into a table.

A.Views have no segment.

B.Views have no object number.

C.Views can join tables only if they belong to the same schema.

D.A view can be created that refers to a non-existent table in its defining query.

E.Rows inserted into a table using a view are retained in the table if the view is dropped

F.A SELECT statement cannot contain a where clause when querying a view containing a WHERE clause in its defining query

A.PUBLIC should be replaced with specific usernames.

B.ALL should be replaced with a list of specific privileges.

C.WITH GRANT OPTION should be added to the statement.

D.Separate GRANT statements are required for the ORDERS and ORDER_ITEMS tables.