If the applicant is able to answer this question correctly, the odds are good that they have some experience working with stored procedures.
A return ...
Search results for sql server
What can be used to ensure that a field in a table only accepts a certain range of values?
Posted by Devin
The answer you want to hear is a Check constraint, which is defined on a database table that limits the values entered into that column. These constra ...
What is a performance consideration of having too many indexes on a production online transaction processing (OLTP)table
Posted by Devin
You are looking for the applicant to make some reference regarding data manipulations. The more indexes on a table, the more time it takes for the dat ...
What does NULL mean?
Posted by Devin
The value NULL is a very tricky subject in the database world, so don't be surprised if several applicants trip up on this question.
The value NULL me ...
Any experienced database developer should be able to answer this question with ease. Some of the less-experienced developers will be able to answer it ...
Can you give me an overview of some of the database objects available for use in SQL Server 2000?
Posted by Devin
You are looking for objects such as: tables, views, user-defined functions, and stored procedures; it's even better if they mention additional objects ...
What is Isolation Level?
Posted by Devin
An isolation level determines the degree of isolation of data between concurrent transactions. The default SQL Server isolation level is Read Committe ...
What is Transaction?
Posted by Devin
A transaction is a sequence of operations performed as a single logical unit of work. A logical unit of work must exhibit four properties, called the ...
« previous1 next »