Examine the SQL statement used to create the TRANSACTION table.
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?
A. INSERT INTO transaction VALUES (‘A1’, DEFAULT, TO_DATE(DEFAULT+10))
B. INSERT INTO transaction VALUES (‘A1’, DEFAULT, TO_DATE(‘SYSDATE+10’))
C. INSERT INTO transaction (trn_id, end_date) VALUES (‘A1′, ’10-DEC-2014’)
D. INSERT INTO transaction (trn_id, start_date, end_date) VALUES (‘A1′, , ’10-DEC-2014’)
|
Download Printable PDF. VALID exam to help you PASS. |
 |