Oracle
1Z0-071 · Question #192
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? (Choose two.)
The correct answer is A. The CUST_STATUS column would store exactly one character. F. The TRANS_VALIDITY column would give an error. See the full explanation below for the reasoning.
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? (Choose two.)
Exhibit
Options
- AThe CUST_STATUS column would store exactly one character.
- BThe TRANS_VALIDITY column would have a maximum size of one character.
- CThe CUST_CREDIT_LIMIT column would be able to store decimal values.
- DThe CUST_STATUS column would give an error.
- EThe TRANS_DATE column would be able to store day, month, century, year, hour, minutes,
- FThe TRANS_VALIDITY column would give an error.
How the community answered
(27 responses)- A85% (23)
- C7% (2)
- D4% (1)
- E4% (1)
Community Discussion
No community discussion yet for this question.