nerdexam
Oracle

1Z0-071 · Question #189

Examine the structure proposed for the TRANSACTIONS table: Which two statements are true regarding the storage of data in the above table structure? (Choose two.)

The correct answer is A. The CUST_CREDIT_VALUE column would allow storage of positive and negative integers. B. The TRANS_VALIDITY column would allow storage of a time interval in days, hours, minutes. See the full explanation below for the reasoning.

Question

Examine the structure proposed for the TRANSACTIONS table:

Which two statements are true regarding the storage of data in the above table structure? (Choose two.)

Exhibit

1Z0-071 question #189 exhibit

Options

  • AThe CUST_CREDIT_VALUE column would allow storage of positive and negative integers.
  • BThe TRANS_VALIDITY column would allow storage of a time interval in days, hours, minutes,
  • CThe CUST_STATUS column would allow storage of data up to the maximum VARCHAR2 size of
  • DThe TRANS_DATE column would allow storage of dates only in the dd-mon-yyyy format.

How the community answered

(59 responses)
  • A
    78% (46)
  • C
    8% (5)
  • D
    14% (8)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice