It's very beneficial for a potential database developer to know the types of triggers available, and how to implement them.
A trigger is a specialize ...
Search results for database
A primary key is the field(s) in a table that uniquely defines the row in the table; the values in the primary key are always unique. A foreign key is ...
What does NULL mean?
Posted by Interview Answers
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 ...
What is an index? What types of indexes are available in SQL Server 2000?
Posted by Interview Answers
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 Interview Answers
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 are the constraints ?
Posted by Interview Answers
Table Constraints define rules regarding the values allowed in columns and are the standard mechanism for enforcing integrity. SQL Server 2000 support ...
Sort all people on Earth
Posted by Microsoft-Interview
"Suppose there is a database of all people on Earth where one of the fields is age (the amount of full years). Provide linear time and constant memory ...
In order to fetch test data from Database we have to create a adobdb connection object to connect with data base. the syntax is .... >CreateObject("Ad ...
