SQL Server uses the standard four-part naming convention when referencing database objects. Which of
the following is the correct example of the four-part naming? (5 points)
server_name.schema_name.database_name.object_name
schema_name.object_name.server_name.database_name
object_name.server_name.schema_name.database_name
Correct!
server_name.database_name.schema_name.object_name
Which of the following statements are true in SQL Server? (15 points)
Select ALL that apply:
Filtered indexes require a WHERE clause
Indexes should be created on columns that have a low cardinality
Indexes cannot be compressed
An ALTER INDEX ... REBUILD on a CLUSTERED index cannot defrag the data pages of the table
Page splits cannot occur on HEAP tables during the addition of a row
Indexes are best added to columns referred to by many queries and that are part of a table with many rows
A table can have multiple CLUSTERED indexes
Which of the following is a valid T-SQL Statement that queries the system catalog to display the check constraints associated to the Sales.SpecialOffer table (5 points).
