A.150

B.200

C.160

D.16

E.100

A.INSERT INTO ordersVALUES (1,'09-mar-2007', DEFAULT, 101, DEFAULT);

B.INSERT INTO(SELECT order_id,order_date,customer_id FROM orders)VALUES (1,'09-mar-2007',
101);

C.INSERT INTO orders(order_id,order_date,order_mode,(customer_id,order_total)VALUES (1,TO_DATE(NULL), 'online', 101, NULL);

D.INSERT INTO orders(order_id,order_date,order_mode,order_total)VALUES (1,'10-mar-2007','online',1000);

E.INSERT INTO ordersVALUES (1,'09-mar-2007', 'online','', 1000);

A.WHERE

B.SELECT

C.ORDER BY

D.GROUP BY

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

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

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

D.Views have no segment.

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

F.Views have no object number.

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

B.PUBLIC should be replaced with specific usernames.

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

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