PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

Which of the following queries will he use to accomplish the task?

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?