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
value.
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
NULL values.

Answer / surya

Constraints are used to provide the scope to table data...
they are..
Primary key
unique key
not null
check
foriegn key
default..

Answer / anand

primary constraint
check constraint
notnull constraint
foreign key constraint

Explain what are the different index configurations a table can have?

0 Answers  

---

What are the two types of concurrency?

4 Answers  

---

i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?

5 Answers   Aptech,

---

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

0 Answers   IntraLogic, Oracle,

---

What is a View ? Can we insert, Update and delete a view?

0 Answers   Arigo Infotech,

---

---

About types of indexes in SQL server ?

2 Answers   Cognizant,

---

How to get a list all databases on the sql server?

0 Answers  

---

Diff between Composite key, Alternate Key, Candidate Key, Primary Key, Unique Key, Super Key, Foreign Key

1 Answers  

---

How to loop through returning rows?

0 Answers  

---

Explain what is raid and what are different types of raid levels?

0 Answers  

---

What is meant by referential integrity?

0 Answers   Blue Star,

---

How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?

2 Answers   Genpact,

---