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




Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / senthil

not null constraint applied on table level constraint but table must be empty otherwise not possible .

Is This Answer Correct ?    0 Yes 3 No

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

Answer / newton_dba

A NOT NULL CONSTRAINT IS USAUALLY APPLIED ON COLUMN LEVEL
BUT IT CAN BE APPLIED ON THE TABLE LEVEL BY USING ALTER
TABLE STATMENT

ALTER TABLE EMP
MODIFY (ENAME CONSTRAINT EMP_ENAME_NN NOT NULL);

Is This Answer Correct ?    7 Yes 12 No



Post New Answer



More Oracle General Interview Questions

write sql query following source are EmpID, Salary 101 1000 102 2000 103 3000 I want the output format like following empid,sal,composite_sal 101 1000 1000 102 2000 3000 103 3000 6000

4 Answers   TCS,


There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

0 Answers  


what are the mandortary parameters required for cuncurrent program definition in oracle apps R12?

1 Answers   Arrow Electronics,


What are Clusters ?

5 Answers   Infosys, Amdocs,


what is exact difference between drop and truncate table.

3 Answers  






hai, when to use char and varchar2....?

2 Answers  


What is materialized view in Oracle?

0 Answers   MCN Solutions,


how many types of index?

2 Answers   TCS, Cap Gemini,


An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

0 Answers  


I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

0 Answers   IBM,


Can a formula column referred to columns in higher group ?

0 Answers   Oracle,


In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

1 Answers  






Categories