Microsoft
98-364 · Question #51
98-364 Question #51: Real Exam Question with Answer & Explanation
The correct answer is A. CREATE TABLE employees (id INTEGER PRIMARY KEY, firstname. See the full explanation below for the reasoning.
Question
The company has a SQL Server database. John wants to create a table named employees in the database. The table will have the id, firstname, lastname, and dateofbirth columns. John has to ensure that the lastname column does not allow null values. Which of the following queries will he use to accomplish the task?
Options
- ACREATE TABLE employees (id INTEGER PRIMARY KEY, firstname
- BCREATE TABLE employees (id INTEGER PRIMARY KEY, firstname
- CCREATE TABLE employees (id INTEGER PRIMARY KEY, firstname
- DCREATE TABLE employees (id INTEGER PRIMARY KEY, firstname
Community Discussion
No community discussion yet for this question.