Constraints enforce the data integrity to the database and protect columns of the table from unwanted values. NOT NULL, CHECK, UNIQUE, PRIMARY KEY, FOREIGN KEY are the types of contraints define in SQL Server.
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
What is bit datatype and what's the information that can be stored inside a bit column?
What is denormalization and when would you go for it?
What are the different ways of moving data/databases between servers and databases in SQL Server?
Tell me what are the steps you will take to improve performance of a poor performing query?
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?
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
