Oracle
1Z0-071 · Question #309
1Z0-071 Question #309: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #309. The question stem and answer options stay visible for context.
Question
You create a table by using this command: CREATE TABLE rate_list (rate NUMBER(6,2)); Which two are true about executing statements? (Choose two.)
Options
- AINSERT INTO rate_list VALUES (-10) produces an error.
- BINSERT INTO rate_list VALUES (87654.556) inserts the value as 87654.6.
- CINSERT INTO rate_list VALUES (0.551) inserts the value as .55.
- DINSERT INTO rate_list VALUES (-99.99) inserts the value as 99.99.
- EINSERT INTO rate_list VALUES (0.999) produces an error.
- FINSERT INTO rate_list VALUES (-.9) inserts the value as -.9.
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.