MS SQL Server - 17 - Create Table MCQ

17 – Create Table MCQ

Best of luck!

1 / 25

1. What SQL statement is used to create a new table in a SQL Server database?

CREATE TABLE

CREATE INDEX

CREATE SCHEMA

CREATE DATABASE

2 / 25

2. In SQL Server, which keyword is used to specify the name of the table to be created?

TABLE

TABLENAME

NAME

3 / 25

3. When creating a table in SQL Server, which clause is used to define the columns and their data types?

VALUES

COLUMN

COLUMNS

DATATYPES

4 / 25

4. In SQL Server, which of the following is an example of a valid data type for a column?

INSERT

INTEGER

MY_COLUMN

CREATE

5 / 25

5. Which SQL statement is used to specify a primary key constraint for a column when creating a table?

UNIQUE

FOREIGN KEY

PRIMARY KEY

CONSTRAINT

6 / 25

6. In SQL Server, what is the purpose of the “NOT NULL” constraint when creating a table?

It defines a default value for the column.

It enforces that the column must have a value.

It allows NULL values in the column.

It specifies a unique constraint.

7 / 25

7. What is the role of the “DEFAULT” keyword in a SQL Server table creation statement?

It sets the primary key for the table.

It assigns a default value to a column when no value is provided during an insert operation.

It specifies the default schema for the table.

It defines the table's data type.

8 / 25

8. In SQL Server, which clause is used to add a check constraint when creating a table?

CHECK

ADD

CREATE

CONSTRAINT

9 / 25

9. What is the purpose of the “FOREIGN KEY” constraint when creating a table in SQL Server?

It allows NULL values in the column.

It specifies a unique constraint.

It defines the primary key for the table.

It enforces referential integrity between the table and another table.

10 / 25

10. In SQL Server, what is the role of the “REFERENCES” keyword in a foreign key constraint?

It sets the data type for the foreign key column.

It defines the column being referenced.

It assigns a default value to the foreign key column.

It specifies the default schema for the foreign key.

11 / 25

11. When creating a table, which SQL clause is used to specify a default value for a column?

SET DEFAULT

SET VALUE

DEFAULT VALUE

DEFAULT

12 / 25

12. In SQL Server, which keyword is used to specify the name of the column when defining a primary key constraint?

COLUMN

KEY

NAME

PRIMARY

13 / 25

13. What is the purpose of the “UNIQUE” constraint when creating a table in SQL Server?

It enforces that all values in the column are unique.

It defines a default value for the column.

It specifies a primary key for the table.

It allows duplicate values in the column.

14 / 25

14. In SQL Server, what does the “IDENTITY” property do when applied to a column?

It allows NULL values in the column.

It generates sequential values for the column automatically.

It assigns a unique constraint to the column.

It sets the column as a primary key.

15 / 25

15. When creating a table in SQL Server, which clause is used to add a unique constraint to a column?

UNIQUE

ADD

CONSTRAINT

PRIMARY KEY

16 / 25

16. In SQL Server, what is the purpose of the “CLUSTERED” keyword when defining a primary key constraint?

It specifies that the column can be NULL.

It sets the column as the primary key.

It determines the sort order of the data in the table.

It defines the data type of the column.

17 / 25

17. What is the primary purpose of a “PRIMARY KEY” constraint in SQL Server?

To define a default value for the column.

To specify that the column can be NULL.

To enforce that all values in the column are unique.

To allow duplicate values in the column.

18 / 25

18. In SQL Server, what is the primary function of a “CHECK” constraint when creating a table?

To define a default value for the column.

To set the column as the primary key.

To enforce a condition on the column's values.

To specify that the column can be NULL.

19 / 25

19. Which SQL clause is used to specify a condition for a “CHECK” constraint when creating a table in SQL Server?

CHECK

RULE

CONDITION

CONSTRAINT

20 / 25

20. In SQL Server, what is the primary function of the “DEFAULT” constraint when creating a table?

To specify that the column can be NULL.

To define a default value for the column.

To set the column as the primary key.

To enforce a condition on the column's values.

21 / 25

21. Which SQL clause is used to specify a default value for a column when creating a table?

DEFAULT VALUE

SET DEFAULT

SET VALUE

DEFAULT

22 / 25

22. What does the “CHECK” constraint do when applied to a column in SQL Server?

Sets the column as the primary key.

Enforces a condition on the column's values.

Defines a default value for the column.

Allows NULL values in the column.

23 / 25

23. In SQL Server, which SQL clause is used to specify a unique constraint for a column when creating a table?

UNIQUE

ADD

PRIMARY KEY

CONSTRAINT

24 / 25

24. What is the role of the “CONSTRAINT” clause when creating a table in SQL Server?

To name a constraint for the table

To enforce referential integrity with another table

To define the column's data type

To specify the primary key of the table

25 / 25

25. In SQL Server, what is the primary purpose of the “AS” keyword when creating a table?

To set the table's primary key

To specify the default schema for the table

To assign a default value to a column

To define the columns based on a query or another table

Your score is

MS SQL Server – 17 – Create Table MCQ