Answer Posted / mohan
A view with Clustred Index is known as Indexed view.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What command must you use to include the not null constraint after a table has already been created?
What is a dbms wizard?
How can you hide the sql server instances?
Explain features of analysis services?
How to change parameter value inside the report?
How can we rewrite sub-queries into simple select statements or with joins?
Explain full-text indexing?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
What are the differences between local and global temporary tables?
How can you append an identity column to a temporary table?
What is the default order of an order by clause?
Determine when an index is appropriate?
What are the advantages of sql stored procedure?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
what is create database syntax? : Sql server database administration