Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is the difference between column level constraints and
table level constraints?

Answer Posted / rahulnayan007@gmail.com

clc = column level constraints
tlc = table level constraints

a) tlc do not support null constraint but clc do.
b) tlc can be used to construct composite keys but clc can't.
c) tlc and clc,using both we can assign names to consraints . being applied to any column.
d)

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference between substr and instr function in oracle?

1076


Respected sir, Please send me technical questions related to oracle apps..

1808


What are the arithmetic operations?

1076


When do we use group by clause in a sql query?

1031


What are advantages of dateset in datastage?

2257


Explain cascading triggers.

1066


What privilege is needed for a user to create tables in oracle?

946


What is an oracle transaction?

1126


Explain an integrity constrains?

1137


Explain an index segment?

1102


What are the different types of synonyms?

1130


How to drop a stored procedure in oracle?

1048


How can I create database in oracle?

1006


Explain the use of consistent option in exp command.

1056


What is a data dictionary and how can it be created?

1136