Database MCQS - QUESTION DETAILS
In SQL Server, what is the purpose of the IDENTITY property?
A. Establish a link between two tables
B. Automatically increments the value of a column
C. Enforce a unique constraint
D. Limit the number of rows returned

IDENTITY automatically increments the value of a column in SQL Server.

Similar Questions

Which MySQL clause is used to add an index to an existing table?





In Oracle, what is the purpose of the INSTR() function?





In SQL Server, what is the purpose of the MERGE statement?





What is the default storage engine in MySQL?





Which Oracle statement is used to grant execute permissions on a stored procedure?





Which SQL statement is used to remove a table from a database?





In MySQL, what is the purpose of the DESC keyword in an ORDER BY clause?





What is the purpose of the Oracle DBMS_SCHEDULER package?





What is the purpose of the SQL Server LIMIT clause?





In SQL Server, what is the purpose of the SQL Server VARBINARY data type?