SQL Quiz

From the given code below, answer the following questions

CREATE TABLE Users (

UserID INT AUTO_INCREMENT PRIMARY KEY,

FirstName VARCHAR(50),

LastName VARCHAR(50),

Email VARCHAR(100) UNIQUE,

DateOfBirth DATE );

What is the name of the table being created in the SQL code?

• Users

• UserID

• FirstName

• LastName

Which column in the "Users" table is designated as the Primary Key?

• FirstName

• LastName

• Email

• UserID

What data type is used for the "UserID" column?

• VARCHAR(50)

• INT

• DATE

• VARCHAR(100)

Which column allows NULL values in the "Users" table?

• UserID

• FirstName

• LastName

• Email

What is the purpose of the AUTO_INCREMENT keyword in the SQL code?

• to automatically increment the value of the "UserID" column.

• to enforce uniqueness in the "Email" column.

• to set a default value for the "DateOfBirth" column.

• to specify the maximum length of the "FirstName" column.

Which column in the "Users" table has a UNIQUE constraint?

• UserID

• FirstName

• LastName

• Unique

What is the maximum length allowed for values in the "FirstName" column?

• 50 characters

• 100 characters

• variable length

• no limit

Which SQL keyword is used to define a new table in the SQL code?

• ADD

• CREATE

• ALTER

• INSERT

Which column in the "Users" table has a data type of DATE?

• UserID

• FirstName

• LastName

• DateOfBirth

What is the purpose of the UNIQUE constraint applied to the "Email" column?

• to enforce data integrity by ensuring each email address is unique.

• to allow NULL values in the "Email" column.

• to specify the maximum length of email addresses.

• to automatically generate values for the "Email" column.