Answers were Sorted based on User's Feedback
Answer / reva ram sahu
constraint is a rule which can not be voilated by end users.
Different types of constraints are available.They are:-
1)default constraint:-which is used to define a default
2)primary key:-the key which does not allows duplication
and null values.
3)foreign key:-the key used to refer primary key defined
field in another table and it allows duplication.
4)null:-which allows NULL values.
5)not null:-which does not allows NULL values.
6)unique key:-which does not allows duplication but allows
|Is This Answer Correct ?||4 Yes||0 No|
Answer / surya
Constraints are used to provide the scope to table data...
|Is This Answer Correct ?||3 Yes||0 No|
Answer / anand
foreign key constraint
|Is This Answer Correct ?||0 Yes||1 No|
What are the type of Indexes? which one is best, why?
can you any body tell me why are go for the rebuild the master database.what is the reason?
your distribution database is full what will u do
How to fetch records from a One to Many relationship table. eg: wanna get details of all orders for a specific customer. (do not want repeatation of master table records for child table records)
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?
How to find 6th highest salary from Employee table ?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
What are the benefits of using stored procedures over sql statements?
How to handle errors in Stored Procedures.
how to write test cases for testing databases,especially for testing and writing test cases for stored procedures.any real time database testers.please answer me.
How to find the last update record in SQL Server?