Sql Interview Question and Answers:
102. 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
103. 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
104. 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.
105. 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.
102. 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
103. 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
104. 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.
105. 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.
Art is important in times of savage destruction because it stands for what is uniquely and indestructibly human; it affirms the values of civilization against the brute force of animal aggression; it is an antithesis of barbarism that evinces the highest standards of beauty and order that humanity is capable of. It is a statement of resistance against chaos.
ReplyDeletekizi com
free games online 2019
a10 for free