A.A row whose UNIT_PRICEcolumn contains the value 1023.99will be displayed as $1,023.

B.A row whose UNIT_PRICEcolumn contains the value 10235.99will be displayed as #######.

C.A row whose UNIT_PRICEcolumn contains the value 10235.99will be displayed as $1,023.

D.A row whose UNIT_PRICEcolumn contains the value 10235.99will be displayed as $1,0236.

E.A row whose UNIT_PRICEcolumn contains the value 1023.99will be displayed as $1,024.

A.displaying the minimum list price for each product status

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

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

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

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

A.WHERE borrowed_date = SYSDATE AND transaction_type = 'RM' OR member_id IN('A101','A102');

B.WHERE borrowed_date = SYSDATE AND transaction_type = 'RM' AND member_id = 'A101' OR member_id = 'A102');

C.WHERE borrowed_date = SYSDATE AND transaction_type = 'RM' AND (member_id = 'A101' OR member_id = 'A102'));

D.WHERE (borrowed_date = SYSDATE AND transaction_type = 'RM') OR member_id IN ('A101','A102');

E.WHERE borrowed_date = SYSDATE AND transaction_type = 'RM' OR member_id IN('A101','A102');

A.CREATE TABLE employees
(employee_id NUMBER,
Login_id NUMBER,
Employee_name VARCHAR2(100),
Hire_date DATE,
CONSTRAINT emp_id_uk UNIQUE (employee_id, login_id);
CONSTRAINT emp_id_nn NOT NULL (employee_id, login_id));

B.CREATE TABLE employees
(employee_id NUMBER CONSTRAINT emp_id_pk PRIMARY KEY,
Login_id NUMBER UNIQUE,
Employee_name VARCHAR2(25),
Hire_date DATE);

C.CREATE TABLE employees
(employee_id NUMBER,
login_id NUMBER,
employee_name VARCHAR2(25),
hire_date DATE,
CONSTRAINT emp_id_pk PRIMARY KEY (employee_id, login_id));

D.CREATE TABLE employees
(employee_id NUMBER CONSTRAINT emp_id_nn NOT NULL,
Login_id NUMBER CONSTRAINT login_id_nn NOT NULL,
Employee_name VARCHAR2(100),
Hire_date DATE,
CONSTRAINT emp_id_ukUNIQUE (employee_id, login_id));

E.CREATE TABLE employees
(employee_id NUMBER,
Login_id NUMBER,
Employee_name VARCHAR2(100),
Hire_date DATE,
CONSTRAINT emp_id_ukUNIQUE (employee_id, login_id));

A.A substitution variable can be used with any clause in a SELECT statement

B.A substitution variable used to prompt for a column name must be enclosed in a single quotation marks

C.A substitution variable prefixed with & always prompts only once for a value in a session

D.A substitution variable can be used only in a SELECT statement

E.A substitution variable used to prompt for a column name must be enclosed in double quotation marks

F.A substitution variable prefixed with && prompts only once for a value in a session unless it is set to undefined in the session