Oracle
1Z0-071 · Question #309
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.)
The correct answer is C. INSERT INTO rate_list VALUES (0.551) inserts the value as .55. D. INSERT INTO rate_list VALUES (-99.99) inserts the value as 99.99. See the full explanation below for the reasoning.
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.
How the community answered
(34 responses)- A6% (2)
- B3% (1)
- C82% (28)
- E9% (3)
Community Discussion
No community discussion yet for this question.