MSSQL DAY-2

Which of the following is used to store integer values in SQL Server?

• FLOAT

• VARCHAR

• INT

• DATETIME

What is the difference between CHAR and VARCHAR?

• CHAR stores variable-length; VARCHAR stores fixed-length

• CHAR stores fixed-length; VARCHAR stores variable-length

• No difference

• VARCHAR is obsolete

Which of the following is a character data type in SQL Server?

• BIT

• CHAR

• MONEY

• INT

The DATETIME data type includes both ______ and time.

The BIT data type is used to store ______ values.

The CHAR data type stores ______-length strings.

The BIT data type can store how many different values?

• 1

• 2

• 3

• 256

Which SQL keyword is used to create a new table?

• INSERT

• UPDATE

• CREATE

• ALTER

What command is used to change the structure of an existing table?

• MODIFY

• CHANGE

• ALTER

• UPDATE

Which of the following is a valid way to add a new column to an existing table?

• CREATE COLUMN

• INSERT COLUMN

• ALTER TABLE ADD

• MODIFY TABLE ADD