Answer Posted / shrikant kalwade
Index means we create unique id to record in to the table.
primary key is example of index; using proper index we
search perticular record from database fast and accurate.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
Explain the third normal form(3nf)?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
What is a data collection table?
Working with TLogs
How to find the source of a table in sql server?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
How to create a view using data from another view?
Explain triggers in sql?
Mention the different authentication modes in sql server.
What is filter index?
How to check if a table is being used in sql server?
Explain query editor regions
How can you insert values in multiple rows using one Insert statement?
What is the difference between dbcc indexdefrag and dbcc reindex?
How to identify current user in ssrs report?
