MS SQL Server - 22 - IDENTITY and SEQUENCE MCQ

22 – IDENTITY and SEQUENCE MCQ

Best of luck!

1 / 10

1. What is the purpose of the IDENTITY property in SQL Server?

It automatically generates incremental values for a column.

It allows you to set a column as the primary key.

It generates random numbers for a column.

It enforces unique constraints on a column.

2 / 10

2. Which data types can be used with the IDENTITY property in SQL Server?

FLOAT and REAL

DATE and TIME

VARCHAR and CHAR

INT, BIGINT, and SMALLINT

3 / 10

3. What is the default seed value for an IDENTITY column in SQL Server?

-1

1000

4 / 10

4. When inserting data into a table with an IDENTITY column, what should you omit in the INSERT statement?

The VALUES keyword

The SET keyword

The WHERE clause

The column names

5 / 10

5. In SQL Server, can you update the value of an IDENTITY column after the initial insert?

Yes, using the UPDATE statement

No, it's not possible to change the value

Only if the column is marked as NULL

Yes, using the IDENTITY_INSERT option

6 / 10

6. What is the primary purpose of the CREATE SEQUENCE statement in SQL Server?

To create a new table

To generate a sequence of numeric values

To define a new stored procedure

To add a new column to an existing table

7 / 10

7. Which SQL Server version introduced the CREATE SEQUENCE statement?

SQL Server 2016

SQL Server 2019

SQL Server 2012

SQL Server 2008

8 / 10

8. Which of the following statements is used to increment a sequence’s value by a specified amount?

INCREMENT BY

UPDATE SEQUENCE

ALTER SEQUENCE

NEXT VALUE FOR

9 / 10

9. In a sequence created with the CREATE SEQUENCE statement, what does the CYCLE option do?

Allows the sequence to restart from the beginning

Reorders the sequence values randomly

Generates an error if the sequence reaches its maximum value

Resets the sequence to its starting value

10 / 10

10. What is the maximum and default value for the CACHE option in the CREATE SEQUENCE statement?

Maximum: 10, Default: 1000

Maximum: 100, Default: 1

Maximum: 1, Default: 100

Maximum: 1000, Default: 10

Your score is

MS SQL Server – 22 – IDENTITY and SEQUENCE MCQ