Oracle
1Z0-071 · Question #150
1Z0-071 Question #150: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #150. The question stem and answer options stay visible for context.
Question
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?
Options
- AINSERT INTO transaction VALUES ('A1', DEFAULT, TO_DATE(DEFAULT+10))
- BINSERT INTO transaction VALUES ('A1', DEFAULT, TO_DATE('SYSDATE+10'))
- CINSERT INTO transaction (trn_id, end_date) VALUES ('A1', '10-DEC-2014')
- DINSERT INTO transaction (trn_id, start_date, end_date) VALUES ('A1', , '10-DEC-2014')
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.