What is the difference between column level constraints and
table level constraints?
- 14 Answers
- 84781 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / adinarayana
COLUMN LEVEL
1.Column level constraints can be defined along with the
columns.
2.NOT NULL constraints can be defined at this level(to only
one column).
3.Composite keys can't be defined at this level
TABLE LEVEL
1.Table level constraints can be defined after defining the
all columns
2.NOT NULL constraints can't be defined at this level.
3.Composite key can be defined at this level
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What are the predefined tablespaces in a database?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
What are the differences between char and nchar in oracle?
What are the types of trigger in oracle?
Can the query output be sorted by multiple columns in oracle?
How to divide query output into groups in oracle?
What do you mean by a tablespace?
What are the different types of database objects?
Difference between varchar and varchar2 data types?
How to count duplicated values in a column in oracle?
Explain the use of owner option in exp command.
How to pass parameters to procedures in oracle?
Can we write insert statement in function in oracle?
What is the difference between 10g OEM and 11g OEM?
How to write a left outer join with the where clause in oracle?
