Oracle
1Z0-882 · Question #17
As a developer, you inherit this table as part of a project: CREATE TABLE exam ( Exam_id INTEGER UNSIGNED NOT NULL PRIMARY KEY, Examinee_id INTEGER UNSIGNED UNIQUE, Score INTEGER UNSIGNED ) What…
The correct answer is D. A NOT NULL qualifier should be added to examinee_id. See the full explanation below for the reasoning.
Question
As a developer, you inherit this table as part of a project:
CREATE TABLE exam ( Exam_id INTEGER UNSIGNED NOT NULL PRIMARY KEY, Examinee_id INTEGER UNSIGNED UNIQUE, Score INTEGER UNSIGNED ) What change should you make to ensure that examinee_id is an integer value throughout the table?
Options
- AThe examinee_id column should be designated as PRIMARY KEY.
- BA NOT NULL qualifier should be moved from exam-id to examinee-id.
- CThe PRIMARY KEY should be dropped and re-created as PRIMARY KEY (examinee-id,
- DA NOT NULL qualifier should be added to examinee_id.
How the community answered
(49 responses)- A4% (2)
- B8% (4)
- C16% (8)
- D71% (35)
Community Discussion
No community discussion yet for this question.