Test Your SQL Skills with CREATE TABLE Quizzes

Progress

True / False

In Microsoft SQL Server, the CREATE TABLE statement can include a PRIMARY KEY constraint to enforce uniqueness and non-nullability on specified columns.

True False

A PRIMARY KEY constraint in SQL Server ensures that the specified columns contain unique and non-null values.

True / False

In SQL Server, you cannot define a PRIMARY KEY constraint on a table during its creation using the CREATE TABLE statement.

True False

A PRIMARY KEY constraint can be defined during table creation using the CREATE TABLE statement in SQL Server.

True / False

The CREATE TABLE statement in SQL Server allows defining default values for columns, ensuring that a specified value is used if no value is provided during insertion.

True False

Default values can be specified for columns in SQL Server using the CREATE TABLE statement.

True / False

In SQL Server, the CREATE TABLE statement cannot be used to define foreign key constraints.

True False

The CREATE TABLE statement in SQL Server can include foreign key constraints to enforce referential integrity between tables.

True / False

The CREATE TABLE statement in SQL Server can specify both column-level and table-level constraints, such as UNIQUE, PRIMARY KEY, and CHECK constraints.

True False

SQL Server allows specifying column-level and table-level constraints in the CREATE TABLE statement to enforce data integrity rules.

True / False

In SQL Server, you can create a table with the CREATE TABLE statement that references tables in an ORACLE database using a linked server.

True False

SQL Server supports linked servers to reference tables in other databases, including ORACLE, during table creation.

True / False

The CREATE TABLE statement in SQL Server allows for the creation of computed columns, which are virtual columns defined by an expression.

True False

Computed columns can be defined in SQL Server using the CREATE TABLE statement, where their values are derived from an expression.

True / False

In SQL Server, a table created with the CREATE TABLE statement can only have one PRIMARY KEY constraint.

True False

A table in SQL Server can have only one PRIMARY KEY constraint, which can consist of one or more columns (composite key).

True / False

The CREATE TABLE statement in SQL Server cannot define a primary key constraint if the key involves more than one column.

True False

SQL Server supports composite primary keys involving multiple columns, which can be defined using the CREATE TABLE statement.

Q10

True / False

In SQL Server, the CREATE TABLE statement can include a CHECK constraint to enforce a condition on values in a column.

True False

CHECK constraints can be defined in SQL Server using the CREATE TABLE statement to enforce conditions on column values.

Q11

True / False

The CREATE TABLE statement in SQL Server can be used to create a table with an identity column, which automatically generates unique values.

True False

Identity columns in SQL Server automatically generate unique values and can be defined using the CREATE TABLE statement.

Q12

True / False

In SQL Server, the CREATE TABLE statement allows you to define the collation for character data, which controls the sorting and comparison rules.

True False

Collation settings can be specified for character columns in SQL Server using the CREATE TABLE statement to control sorting and comparison.

Q13

True / False

The CREATE TABLE statement in SQL Server can be used to define a table with partitioning, which helps manage large tables by dividing them into smaller pieces.

True False

Table partitioning can be defined in SQL Server using the CREATE TABLE statement to manage large tables by splitting them into smaller, manageable pieces.

Q14

True / False

In SQL Server, a table created with the CREATE TABLE statement cannot have columns with the same names as columns in a table from an ORACLE database linked via a linked server.

True False

SQL Server allows creating tables with columns that have the same names as columns in tables from other databases, including ORACLE, when using linked servers.

Q15

True / False

The CREATE TABLE statement in SQL Server supports creating temporary tables that are automatically dropped when the session ends.

True False

Temporary tables can be created in SQL Server using the CREATE TABLE statement, and they are automatically dropped when the session that created them ends.

Q16

Single Choice

Which keyword is used to create a new table in SQL Server?

CREATE TABLE NEW TABLE ADD TABLEINSERT TABLE

The CREATE TABLE statement is used to create a new table in SQL Server.

Q17

Single Choice

What is the purpose of the PRIMARY KEY constraint in a CREATE TABLE statement?

To allow null values To enforce unique and non-null values To create an indexTo create a foreign key

The PRIMARY KEY constraint ensures that the specified columns contain unique and non-null values.

Q18

Single Choice

In SQL Server, which clause is used to define a default value for a column in a CREATE TABLE statement?

DEFAULT SET DEFAULT WITH DEFAULTVALUE

The DEFAULT clause is used to define a default value for a column in a CREATE TABLE statement.

Q19

Single Choice

Which of the following is a valid data type for a column in a CREATE TABLE statement in SQL Server?

STRING TEXT VARCHARCHARACTER

VARCHAR is a valid data type for a column in a CREATE TABLE statement in SQL Server.

Q20

Single Choice

How do you specify a column as a primary key in a CREATE TABLE statement?

KEY PRIMARY PRIMARY PRIMARY KEYKEY

To specify a column as a primary key, you use the PRIMARY KEY constraint in the CREATE TABLE statement.

Q21

Single Choice

Which keyword is used to specify a column that automatically increments its value in a CREATE TABLE statement?

AUTO_INCREMENT SERIAL IDENTITYINCREMENT

The IDENTITY keyword is used to specify a column that automatically increments its value.

Q22

Single Choice

In SQL Server, which statement is true about creating a table with a foreign key constraint?

A table can only have one foreign key. Foreign key constraints cannot be defined during table creation. A foreign key constraint enforces referential integrity.A foreign key column must be the primary key in the referenced table.

A table can be created with a foreign key constraint to enforce referential integrity with another table.

Q23

Single Choice

What happens if you try to create a table with a primary key column that allows null values?

The table is created successfully. The primary key constraint is ignored. SQL Server returns an error.The column is automatically set to NOT NULL.

A primary key column cannot allow null values, and SQL Server will return an error if you try to create such a table.

Q24

Single Choice

Which keyword is used to define a table-level constraint in a CREATE TABLE statement?

TABLE_CONSTRAINT CONSTRAINT KEY_CONSTRAINTTABLE_LEVEL

The CONSTRAINT keyword is used to define table-level constraints such as PRIMARY KEY, UNIQUE, and FOREIGN KEY.

Q25

Single Choice

How can you ensure that a column in a new table only contains unique values?

Use UNIQUE constraint Use DISTINCT keyword Use CHECK constraintUse UNIQUE KEY

To ensure a column contains unique values, you can use the UNIQUE constraint in the CREATE TABLE statement.

Q26

Single Choice

In SQL Server, which data type should you use for a column storing date and time values?

DATE TIME DATETIMETIMESTAMP

The DATETIME data type is used in SQL Server to store date and time values.

Q27

Single Choice

Which keyword is used to specify that a column must contain a value in a CREATE TABLE statement?

NOT NULL REQUIRED NO NULLMUST HAVE

The NOT NULL constraint ensures that a column must contain a value and cannot be left blank.

Q28

Single Choice

What is the purpose of a CHECK constraint in a CREATE TABLE statement?

To limit the range of values To ensure unique values To enforce referential integrityTo provide default values

A CHECK constraint is used to enforce a condition on the values in a column.

Q29

Single Choice

In SQL Server, which clause is used to specify the collation for a character column in a CREATE TABLE statement?

COLLATION COLLATE CHARACTER SETSORTING

The COLLATE clause is used to specify the collation for a character column in SQL Server.

Q30

Single Choice

Which statement is true about creating a table with a computed column in SQL Server?

A computed column can store data permanently. A computed column's value is derived from an expression. A computed column must be indexed.A computed column can reference other tables.

A computed column in SQL Server is a virtual column whose value is derived from an expression.

Q31

Multiple Choice

Which of the following can be specified in a CREATE TABLE statement in SQL Server?

Column definitions Data types ConstraintsIndex creation

The CREATE TABLE statement in SQL Server can include column definitions, constraints, and data types.

Q32

Multiple Choice

Which of the following are valid constraints in a CREATE TABLE statement in SQL Server?

PRIMARY KEY FOREIGN KEY UNIQUEINDEX

Valid constraints in a CREATE TABLE statement include PRIMARY KEY, FOREIGN KEY, UNIQUE, and CHECK.

Q33

Multiple Choice

Which of the following are data types supported in SQL Server for a column in a CREATE TABLE statement?

INT VARCHAR DATETIMESTRING

SQL Server supports data types such as INT, VARCHAR, DATETIME, and FLOAT for columns.

Q34

Multiple Choice

In SQL Server, which of the following can be defined using the CREATE TABLE statement?

Column data types Default values Computed columnsTable relationships

The CREATE TABLE statement can define column data types, constraints, default values, and computed columns.

Q35

Multiple Choice

Which of the following are valid uses of the CREATE TABLE statement in SQL Server?

Create a table with a PRIMARY KEY constraint Define default values for columns Specify foreign key relationshipsSet up user permissions

The CREATE TABLE statement can be used to create tables with various constraints and default settings, and to define column properties.

Q36

Multiple Choice

Which of the following statements are true about using the CREATE TABLE statement in SQL Server?

You can define multiple primary keys. You can set default values for columns. You can include computed columns.You can specify collation settings for character data.

The CREATE TABLE statement can include various constraints, data types, and column specifications.

Q37

Multiple Choice

Which constraints can be defined at the column level in SQL Server using the CREATE TABLE statement?

PRIMARY KEY UNIQUE FOREIGN KEYCHECK

Constraints such as PRIMARY KEY, UNIQUE, and CHECK can be defined at the column level in SQL Server.

Q38

Multiple Choice

In SQL Server, which of the following can be specified as part of a column definition in a CREATE TABLE statement?

Data type Size Default valueIndex

Column definitions can include data type, size, and constraints.

Q39

Multiple Choice

Which of the following are valid data types for columns in a CREATE TABLE statement in SQL Server?

INT FLOAT CHARTEXT

SQL Server supports various data types such as INT, FLOAT, CHAR, and TEXT.

Q40

Multiple Choice

Which of the following statements are true about the IDENTITY property in SQL Server?

It generates unique values automatically. It is used to create auto-incrementing columns. It can be used for primary key columns.It must be used with a UNIQUE constraint.

The IDENTITY property automatically generates unique values for a column, and it can be used in the CREATE TABLE statement.

Q41

Multiple Choice

Which of the following are valid constraints that can be defined in the CREATE TABLE statement in SQL Server?

PRIMARY KEY FOREIGN KEY UNIQUENULL

Constraints such as PRIMARY KEY, FOREIGN KEY, UNIQUE, and CHECK can be used in the CREATE TABLE statement.

Q42

Multiple Choice

In SQL Server, which of the following statements about computed columns is true?

Computed columns are physically stored in the table. Computed columns are calculated from expressions. Computed columns can be indexed.Computed columns can be used in constraints.

Computed columns are virtual columns that are calculated based on an expression and are not physically stored in the table.

Q43

Multiple Choice

Which of the following are valid collation settings for character columns in SQL Server?

Case sensitivity Accent sensitivity Sort orderData type

Collation settings in SQL Server control the sorting and comparison of character data and include options such as case sensitivity and accent sensitivity.

Q44

Multiple Choice

Which of the following are valid options for specifying default values in a CREATE TABLE statement in SQL Server?

Static value Expression FunctionForeign key reference

Default values can be specified for columns to ensure they have a predefined value when no other value is provided during insertion.

Q45

Multiple Choice

In SQL Server, which of the following features can be used to partition large tables created with the CREATE TABLE statement?

Partition schemes Partition functions FilegroupsIndexes

Partitioning large tables can help manage data efficiently and is supported in SQL Server using partition schemes and functions.

Microsoft SQL Server Database Quiz Questions