A.Display suppliers whose PROD_LIST_PRICE is less than 1000.

B.Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable.

C.Display the minimum PROD_LIST_PRICE for each product status.

D.Display the total number of products supplied by supplier 102 which have a product status of obsolete.

E.Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE.

A.SELECT * FROM customers WHERE customer_ id = 0001 ;

B.SELECT * FROM customers WHERE TO_ CHAR (customer_ id) ='0001';

C.SELECT * FROM customers WHERE insert_ date = DATE '2019-01-01';

D.SELECT * FROM customers WHERE insert date ='01-JAN-19'

E.SELECT * FROM customers WHERE customer id = '0001';

A.A role is a named group of related privileges that can only be assigned to a user.

B.Roles are assigned to users using the ALTER USER statement.

C.Privileges are assigned to a role using the GRANT statement.

D.A single user can be assigned multiple roles.

E.Privileges are assigned to a role using the ALTER ROLE statement.

F.Roles are assigned to roles using the ALTER ROLE statement.

G.A single role can be assigned to multiple users.

A.A SEQUENCE can have a synonym.

B.A synonym can be available to all users .

C.A synonym cannot be created for a PL /SQL package.

D.Any user can drop a PUBLIC synonym.

E.A synonym created by one user can refer to an object belonging to another user.

A.The SYS user owns all base tables and user-accessible views in the data dictionary.

B.The data dictionary is constantly updated to reflect changes to database objects, permissions, and data.

C.All users have permissions to access all information in the data dictionary by default

D.All user actions are recorded in the data dictionary.

E.Base tables in the data dictionary have the prefix DBA_.