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

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1078


Differentiate between function and procedure in oracle.

1083


State some uses of redo log files?

1012


Define oracle database

1047


What is oracle datasource?

993


How to create a stored program unit?

1234


What is set operator oracle?

983


How to rebuild an index in oracle?

1028


What is an oracle and why it is used?

1153


What is enter substitution variable in oracle?

1053


What do you know about normalization? Explain in detail?

951


What is an oracle user account?

994


How to use windows user to connect to the server?

990


What will be the syntax to find current date and time in format "yyyy-mm-dd"?

1011


Write a syntax for update query in oracle?

1036