Sql Interview Question and Answers

86. What is an Data Abtration?
 
    A major purpose of a database system is to provide users with an abstract view of the data.There are three levels of data abstraction
  • Physical level
  • Logical level
  • View level
 
Your Name Your Email-ID
Your Answer
87. What is Transaction Manager?
  It is a program module, which ensures that database, remains in a consistent state despite system failures and concurrent transaction execution proceeds without conflicting.
 
Your Name Your Email-ID
Your Answer
88. What kind of User-Defined Functions can be created?
  There are three types of User-Defined functions in SQL Server 2000 and they are Scalar, Inline Table-Valued and Multi-statement Table-valued.
 
Your Name Your Email-ID
Your Answer
89. What are defaults? Is there a column to which a default can't be bound?
  A default is a value that will be used by a column, if no value is supplied to that column while inserting data. IDENTITY columns and timestamp columns can't have defaults bound to them. See CREATE DEFUALT in books online.
 
Your Name Your Email-ID
Your Answer
90. What is data integrity?
  Data integrity is an important feature in SQL Server. When used properly, it ensures that data is accurate, correct, and valid. It also acts as a trap for otherwise undetectable bugs within applications.
 
Your Name Your Email-ID
Your Answer