Answer Posted / surya
It is used to avoid invalid and inconsistence data into the
data base table.
For example if you specify like this
sal int Check(sal>=1000)
and trying to insert value below 1000 in the sal
column,they won't accept you.That means it restrict the
data in the database table.
| Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
How many categories of data types?
Explain the use of analyse option in exp command.
What are the differences between interval year to month and interval day to second?
Explain enable novalidate constraint.
Describe an oracle table?
When do I need to use a semicolon vs a slash in oracle sql?
What are the different types of synonyms?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
What is oracle latest version?
Explain the difference between sql and oracle?
What is difference between sid and service name in oracle?
What is a synonym? What are its various types?
What are the system predefined user roles?
When system tablespace is created?