ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 98-364 All Questions

View all questions & answers for the 98-364 exam
Go to Exam

Exam 98-364 topic 1 question 218 discussion

Actual exam question from Microsoft's 98-364
Question #: 218
Topic #: 1
[All 98-364 Questions]

John works as a Database Administrator in www.company.com Inc.
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?

  • A. CREATE TABLE employees (id INTEGER PRIMARY KEY, firstname CHAR(50)NULL, lastname CHAR (75)NOT NULL, dateofbirth DATE NULL);
  • B. CREATE TABLE employees (id INTEGER PRIMARY KEY, firstname CHAR(50)NULL, lastname CHAR (75), dateofbirth NULL);
  • C. CREATE TABLE employees (id INTEGER PRIMARY KEY, firstname CHAR(50)NULL, lastname CHAR (75) NOT NULL);
  • D. CREATE TABLE employees (id INTEGER PRIMARY KEY, firstname CHAR(50)NULL, lastname CHAR (75), dateofbirth DATE NULL);
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by designtshirt at April 4, 2025, 6:31 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Currently there are no comments in this discussion, be the first to comment!
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago