A.It displays details for members who have borrowed before today with RM as TRANSACTION_TYPE and the details for members A101 or A102.

B.It displays details only for members who have borrowed before today with RM as TRANSACTION_TYPE.

C.It displays details for only members A101 and A102 who have borrowed before today with RM TRANSACTION_TYPE.

D.It displays details for members who have borrowed before today's date with either RM as TRANSACTION_TYPE or MEMBER_ID as A101 and A102.

A.They can be used on columns or expressions.

B.They can be passed as an argument to another group function.

C.They can be used with a SQL statement that has a GROUP BY clause.

D.They can be used only on one column in the SELECT clause.

E.They can be used together with the single-row functions in the SELECT clause.

A.Employee 200 will have SALARY set to the same value as the SALARY of employee 100

B.Employee 100 will have SALARY set to the same value as the SALARY of employee 200

C.Employees 100 and 200 will have the same JOB_ID as before the update command

D.Employees 100 and 200 will have the same SALARY as before the update command

E.Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100

F.Employees 100 will have JOB_ID set to the same value as the JOB_ID of employee 200

A.Line 5

B.Line 7

C.Line 8

D.Line 3

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

B.WHERE borrowed_date = SYSDATE AND transaction_type = 'RM' OR member_id IN('A101','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');