Interested to Buy Any Domain ? << Click Here >> for more details...
what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 89666 Views
- HCL, IBM, NIIT, Wipro, I also Faced
- E-Mail Answers
Answer Posted / bimaleswar patel
Constraints are used to limit the type of data that can go
into a table.
two basic types of constraints are there
1.column level
2.table level
the difference is that column level constraints are apply
only to one column where as table level constraints are
apply to whole table
Constraints are declare at the time of table creation using
CREATE TABLE command
there are 6 constraints used in oracle
1.NOT NULL
2.UNIQUE
3.PRIMARY KEY
4.CHECK
5.DEFAULT
6.REFERENCES
| Is This Answer Correct ? | 96 Yes | 24 No |
Post New Answer View All Answers
What is the distinction amongst delete and truncate?
How is sql server used?
What is store procedure?
Explain what is the difference between union and union all?
Tell me about normalization in DBMS.
What is normalization 1nf 2nf 3nf?
What are the results of running this script?
How to make a column nullable?
What are the types of user defined functions in sql server?
Explain having clause?
What is #temp and @table variable in SQL server?
What does top operator do?
What are horizontal and vertical scaling?
What does sql server mean?
What is multilevel indexing?
