Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between column level constraints and
table level constraints?
- 14 Answers
- 86963 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
How to assign data of the deleted row to variables?
Can we write dml statement in function in oracle?
What are the set operators union, union all, minus & intersect meant to do?
Can a parameter be passed to a cursor?
What are a query and state the different types of queries and their uses?
Can we create trigger on materialized view in oracle?
How many types of cluster table in Oracle?
What is the difference between online and offline backups?
What is an external table?
Can we save images in a database and if yes, how?
Can we insert data in view oracle?
What happens if you use a wrong connect identifier?
What is bind variable in oracle 11g?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Difference between the “verify” and “feedback” command?
