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)- A81% (43)
- B11% (6)
- C6% (3)
- D2% (1)
Community Discussion
No community discussion yet for this question.