DYNAMIC: It reflects changes happened on the table while scrolling through the row.
STATIC: It works on snapshot of record set and disconnects from the server. This kind doesn’t reflects changes happened on the table while scrolling through the row.
KEYSET: In this kind, new record is not reflected, but data modification can be seen
When you create a database how is it stored?
Explain the storage models of OLAP?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table? I create a separate index on each column of a table. What are the advantages and disadvantages of this approach?
CREATE INDEX myIndex ON myTable(myColumn)What type of Index will get created after executing the above statement?
What's the difference between DELETE TABLE and TRUNCATE TABLE commands?
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?
What are defaults? Is there a column to which a default can't be bound?
How do you implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What is database replication? What are the different types of replication you can set up in SQL Server?
What are different types of BACKUPs available in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
