What is the difference between column level constraints and
table level constraints?
- 14 Answers
- 84819 Views
- IBM, TCS, I also Faced
- E-Mail Answers
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
Can group functions be mixed with non-group selection fields?
How to select an oracle system id (sid)?
Explain a synonym?
Can we store pictures in the database and if so, how it can be done?
What happens if recursive calls get out of control?
How view is different from a table?
How does one get the view definition of fixed views/tables?
What do you understand by a database object? Can you list a few of them?
What operating systems are supported by oracle database 10g xe?
What is tns name?
How to do clean up if create database failed?
What do you mean by a database transaction & what all tcl statements are available in oracle?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
What is flashback in Oracle?
How to insert multiple rows with one insert statement in oracle?
