What is bit datatype?

Bit datatype is used to store boolean information like 1 or 0 (true or false).

Bit datatype can represent a Null state

Define candidate key, alternate key, composite key

Candidate key: A column or a set of columns can be called as candidate key if they i dentify each row of a table uniquely........

Define composite key

A key formed by combining at least two or more columns.......

Define default constraint

Default constraint is used to fill column with default value defined during creation of table if nothing is supplied while inserting data........

Post your comment

Related Content