nerdexam
CIW

1D0-441 · Question #56

Consider the following information that describes a database: domain s_id: integer domain grd: fixed length character string length 1 STUDENT_GRADE( Student_Number: s_id NOT NULL Grade: grd )…

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

Question

Consider the following information that describes a database: domain s_id: integer domain grd: fixed length character string length 1 STUDENT_GRADE( Student_Number: s_id NOT NULL Grade: grd ) Primary Key Student_Number Which SQL statements would build the relation?

Options

  • ACREATE TABLE STUDENT_GRADE (
  • BCREATE DOMAIN s_id AS INTEGER;
  • CCREATE DOMAIN s_id AS INTEGER;
  • DCREATE SCHEMA STUDENT_GRADE;

How the community answered

(36 responses)
  • A
    6% (2)
  • B
    81% (29)
  • C
    11% (4)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 1D0-441 Practice