PRIMARY KEY constraint defaults to __________ index.
Correct Answer: Clustered
Explanation:
Note: This Question is unanswered, help us to find answer for this one
Microsoft SQL Server Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More Microsoft SQL Server MCQ Questions
Which of the following is a valid code to change the index created on a column of a table to page compression?
Which of the following features of SQL Server 2008 enables you to limit the memory used by incoming application requests?
Analyze the following command: -o 'C:\Folder\' Which of the following statements is true if a file with the file name specified in the above command already exists?
Multiple CHECK constraints can be applied to a single column and a single CHECK constraint can be applied to multiple columns in SQL Server 2008.
Which of the following is the default authentication mode for sqlcmd in SQL Server 2008?
Which of the following is not a relational operation?
What does DBCC stand for?
SQL Server will create a unique nonclustered index, by default, when a primary key is created.
Backup and restore history is stored in which database?
Which data extents are backed up by a differential database backup?