Which keyword is used in SQL Server to implement the auto increment? - SQL Server MCQs

Home / Programming MCQs / SQL Server MCQs / Question

S

Shivam • 8.86K Points
Tutor III

Q. Which keyword is used in SQL Server to implement the auto increment?

(A) UNIQUE

(B) IDENTITY

(C) INCREMENT

(D) ADD

Correct answer: Option(B)

SQL Server Share

Explanation by: Shivam

IDENTITY keyword is used in SQL Server to implement the auto-increment.

You must be Logged in to update hint/solution

Previous MCQ Next MCQ

Discusssion

Login to discuss.

Related MCQs on SQL Server

Point out the wrong statement.

Every database has one primary data file. We can give any extension for the primary data file but the recommended extension is?

With SQL, how can you return the number of not null records in the "Persons table ?

In which database state, the database is in single-user mode and may be repaired or restored.

What is the syntax for creating new login on the SQL sevrer?

Full form of MS-DTC.

Why type of user is the default in sql server?

DecryptByKeyAutoCert is ________________ type function.

Syntax for creating views is __________

Learn All SQL Server MCQs