What are the type of Indexes? which one is best, why?
Answer Posted / s. sundar
1. Clustered Index
2. Non-Clustered Index
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the advantages of passing name-value pairs as parameters?
what are the important architecture components of SSRS?
Are semicolons required at the end of sql statements in sql server 2005?
Mention the command used to rename the database.
What is the security model used in sql server 2005?
How to create prepared statements using odbc_prepare()?
What is difference between stored procedure and user defined function?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
How to create hyperlink from returned sql query ?
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
How the authentication mode can be changed?
What is the difference between join and inner join?
What are null values in ms sql server?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
What is the difference between functions and stored procedures?