why can't we assign not null constraint as table level
constraint

Answer Posted / lokanath

Because its a Column Level constraint.
Not Null is a Constraint which will ensure the Column
should not be null.

Is This Answer Correct ?    10 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a relational database management system?

873


Explain self joins in oracle?

763


State the various uses of dbcc command?

793


What are the restrictions in a oracle read only transaction?

773


HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2207


nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

1956


Explain about the analyze command in oracle?

787


How to login to the server without an instance?

813


How to create a stored procedure in oracle?

801


Can we create database in oracle using command line ?

808


How to create a server parameter file?

805


State some uses of redo log files?

764


how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2326


Explain the types of exception?

865


What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

1743