Examine the structure of the BOOKS_TRANSACTIONS table:
Name Null? Type
—————- —————– —————————
TRANSACTION_ID NOT NULL VARCHAR2 (6)
BORROWED_DATE VARCHAR2 (50)
DUE_DATE DATE
BOOK_ID DATE
MEMBER_ID VARCHAR2 (6)
You want to display the member IDs, due date, and late fee as $2 for all transactions.
Which SQL statement must you execute?
A.
SELECT member_id AS MEMBER_ID, due_date AS DUE_DATE, $2 AS LATE_FEE FROM
BOOKS_TRANSACTIONS;
B.
SELECT member_id ‘MEMBER ID’, due_date ‘DUE DATE’, ‘$2 AS LATE FEE’ FROM
BOOKS_TRANSACTIONS;
C.
SELECT member_id AS “MEMBER ID”, due_date AS “DUE DATE”, ‘$2’ AS “LATE FEE”
FROM BOOKS_TRANSACTIONS;
D.
SELECT member_id AS “MEMBER ID”, due_date AS “DUE DATE”, $2 AS “LATE FEE” FROM
BOOKS_TRANSACTIONS;