Answer Posted / koti
250 indexes(1 cluster index,249 non-cluster indexes)
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What is an active database?
Can I run multiple instances of sql server 2000 at the same time on one computer?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
What is multilevel indexing?
How to handle error or exception in sql?
What is a user-defined function in the sql server and what is its advantage?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
How can you start sql server in different modes?
Can you explain what is the use of custom fields in report?
Explain throw statement in sql server 2008?
What are pessimistic lock and optimistic lock?
Explain in brief how sql server enhances scalability of the database system?
Can sql servers linked to other servers?
What is 3nf normalization form?
Is sql server is free?
