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.)
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 column 'rate' is defined with a number data type having a precision of 6 and a scale of 2, meaning it can store up to 4 digits before the decimal point and up to 2 digits after the decimal point. Option B is correct because the value of -0.9 can be stored within these constraints without any rounding or error. Option F is also correct because the value 0.551 will be rounded to 0.55 to fit into the scale of 2.
BF correct
100% BF correct. Have a try. CREATE TABLE rate_list (rate NUMBER(6,2)); INSERT INTO rate_list VALUES (0.999); select * from rate_list; INSERT INTO rate_list VALUES (-.9); select * from rate_list; INSERT INTO rate_list VALUES (87654.556); select * from rate_list; INSERT INTO rate_list VALUES (-10); select * from rate_list; INSERT INTO rate_list VALUES (-99.99); select * from rate_list; INSERT INTO rate_list VALUES (0.551); select * from rate_list;
BF ARE CORRECT
B,F tested
B and F are correct https://www.examtopics.com/discussions/oracle/view/8436-exam-1z0-071-topic-1-question-276-discussion/
BF tested
B, E is correct