Solved

Which of the Following Is True About Indexes in SQL

Question 33

Multiple Choice

Which of the following is true about indexes in SQL Server?


A) SQL Server automatically creates indexes for columns appearing in WHERE clauses in queries.
B) SQL Server pads all indexes.
C) SQL Server supports filling up to a limit of 70 percent.
D) SQL Server automatically creates indexes for foreign keys.

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q28: SQL Statements can be submitted to SQL

Q29: SQL Server supports three types of indexes:

Q30: When using SQL Server,developers place explicit locks.

Q31: When viewing the SQL Server list of

Q32: SQL Server user variables and parameters start

Q34: PL/SQL is a programming language for SQL

Q35: Stored procedures and triggers in SQL Server

Q36: In SQL Server,insert and update triggers store

Q37: SQL Server tables can be created and

Q38: SQL Server user variables and parameters start