1Z0-071 Free Practice Test

Examine the SQL statement used to create the TRANSACTION table. (Choose the best answer.)
SQL > CREATE TABLE transaction (trn_id char(2) primary key,
Start_date date DEFAULT SYSDATE, End_date date NOT NULL);
The value 'A1' does not exist for trn_id in this table.
Which SQL statement successfully inserts a row into the table with the default value for START_DATE?

1. A. INSERT INTO transaction VALUES (\'A1\', DEFAULT, TO_DATE(DEFAULT+10))
2. B. INSERT INTO transaction VALUES (\'A1\', DEFAULT, TO_DATE(\'SYSDATE+10\'))
3. C. INSERT INTO transaction (trn_id, end_date) VALUES (\'A1\', \'10-DEC-2014\')
4. D. INSERT INTO transaction (trn_id, start_date, end_date) VALUES (\'A1\', , \'10-DEC-2014\')

Correct Answer: C