What is a constraint. Types of constraints ?

Answer Posted / samuvel

Constraint is a restriction on table

Types:

1)Column Constraints:applicable for column level
i)unique ii) not null

2)Table constraints:applicable for table level
1)primary key ii) foreign key d. check

Is This Answer Correct ?    8 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does select count (*) mean in sql?

556


Name some usages of database trigger?

566


What does 0 mean in sql?

532


What is the need of merge statement?

559


What is the default isolation level in sql server? : Transact sql

572






What are inner and outer joins examples of both?

501


Why do we use joins in sql?

507


Can a trigger call a stored procedure?

542


What is the purpose of normalization?

541


how can I make a script that can be bi-language (supports english, german)? : Sql dba

542


What is clustered index sql?

508


What is the difference between subquery and correlated query?

536


In pl/sql, what is bulk binding, and when/how would it help performance?

539


What are the parameter modes supported by pl/sql?

536


How does sql developer connect to oracle database?

528