A.displaying the total number of products supplied by supplier 102071 and having product status OBSOLETE

B.displaying the number of products whose list prices are more than the average list price

C.displaying the minimum list price for each product status

D.displaying all the products whose minimum list prices are more than average list price of products having the status orderable

E.displaying all supplier IDs whose average list price is more than 500

A.INSERT statements can insert NULLS explicitly into a column.

B.INSERT INTO...SELECT...FROM statements automatically commit.

C.UPDATE statements can have different subqueries to specify the values for each updated column.

D.DML statements require a primary key be defined on a table.

E.DELETE statements can remove multiple rows based on multiple conditions.

A.Adding a column with a default value while inserting a row into a table.

B.Removing all data from a single column on which a unique constraint is defined.

C.Adding a column constraint while inserting a row into a table.

D.Removing all data only from a single column on which a primary key constraint is defined.

A.It can be accessed by any user who has the SELECT privilege in any schema

B.It can be used to display only constants or pseudo columns.

C.It consists of a single row and single column of VARCHAR2 data type.

D.It can display multiple rows and columns.

E.It can display multiple rows but only a single column.

F.It can be accessed only by the SYS user.

A.The statement executes successfully and produces the required output.

B.The statement produces an error because ITEM_CNT cannot be displayed in the outer query.

C.The statement produces an error because a subquery in the FROM clause and outer- joins cannot be used together.

D.The statement produces an error because the GROUP BY clause cannot be used in a subquery in the FROM clause.