Microsoft
70-433 · Question #140
You are given a database design to evaluate. All of the tables in this database should have a clustered index. You need to determine the tables that are missing a clustered index by using the system…
The correct answer is A. SELECT name AS table_name. See the full explanation below for the reasoning.
Question
You are given a database design to evaluate. All of the tables in this database should have a clustered index. You need to determine the tables that are missing a clustered index by using the system catalog views. Which Transact-SQL statement should you use?
Options
- ASELECT name AS table_name
- BSELECT name AS table_name
- CSELECT name AS table_name
- DSELECT name AS table_name
How the community answered
(43 responses)- A77% (33)
- B14% (6)
- C2% (1)
- D7% (3)
Community Discussion
No community discussion yet for this question.