nerdexam
CIW

1D0-441 · Question #10

Consider the following domain description: domain Student_ID: integer domain Grade: fixed length character string length 1 To meet business needs, you must add enterprise constraints to this domain…

The correct answer is A. CREATE DOMAIN Student_ID AS INTEGER. See the full explanation below for the reasoning.

Question

Consider the following domain description: domain Student_ID: integer domain Grade: fixed length character string length 1 To meet business needs, you must add enterprise constraints to this domain description. The Student_ID should always be a positive integer. The initial value of Student_ID should be 0 (zero) to indicate that a valid ID number has not been assigned. The Grade should be limited to the letters A through F. Which SQL statements would perform these tasks?

Options

  • ACREATE DOMAIN Student_ID AS INTEGER
  • BCREATE DOMAIN Student_ID AS INTEGER
  • CCREATE DOMAIN Student_ID AS INTEGER;
  • DCREATE TABLE ENTERPRISE (

How the community answered

(53 responses)
  • A
    81% (43)
  • B
    11% (6)
  • C
    6% (3)
  • D
    2% (1)

Community Discussion

No community discussion yet for this question.

Full 1D0-441 Practice