Examine the structure proposed for the transactions table: Which two statements are true regarding the creation and storage of data in the above table structure?

The correct answer is B. The TRANS_VALIDITY column would give an error. C. The CUST_STATUS column would store exactly one character. VARCHAR2(size)Variable-length character data (A maximum size must be specified: minimum size is 1; maximum size is 4, 000.) CHAR [(size)] Fixed-length character data of length size bytes (Default and minimum size is 1; maximum size is 2, 000.) NUMBER [(p, s)] Number having…

Using DDL Statements to Create and Manage Tables

Question

Examine the structure proposed for the transactions table:

Which two statements are true regarding the creation and storage of data in the above table structure?

Exhibit

Options

AThe CUST_STATUS column would give an error.
BThe TRANS_VALIDITY column would give an error.
CThe CUST_STATUS column would store exactly one character.
DThe CUST_CREDIT_LIMIT column would not be able to store decimal values.
EThe TRANS_VALIDITY column would have a maximum size of one character.
FThe TRANS_DATE column would be able to store day, month, century, year, hour, minutes, seconds,

How the community answered

(47 responses)

A
2% (1)
B
81% (38)
D
6% (3)
E
2% (1)
F
9% (4)

Explanation

VARCHAR2(size)Variable-length character data (A maximum size must be specified: minimum size is 1; maximum size is 4, 000.) CHAR [(size)] Fixed-length character data of length size bytes (Default and minimum size is 1; maximum size is 2, 000.) NUMBER [(p, s)] Number having precision p and scale s (Precision is the total number of decimal digits and scale is the number of digits to the right of the decimal point; precision can range from 1 to 38, and scale can range from ?4 to 127.) DATE Date and time values to the nearest second between January 1, 4712 B.C., and December 31, 9999 A.D.

Topics

#DDL#data types#CHAR#table creation

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice