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

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

Question Posted / itlumeeprasad

3 Answers
12681 Views
CTS, Wipro, I also Faced
E-Mail Answers

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

13 No

Post New Answer

More Oracle General Interview Questions

How to call a stored function in oracle?

0 Answers

What is varray?

0 Answers

What are the differences between interval year to month and interval day to second?

0 Answers

create or replace procedure show_tab_rec ( P_tab VARCHAR2 ) IS cmd varchar2(50); begin cmd := 'select * from '|| P_tab; for int in ( execute immediate cmd ) loop dbms_output.put_line ( int.ename||' '||int.deptno); end loop; end; when i m compling this procedure i m getting this error PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the following: . ( ) , * @ % & | = - + < / > at in is mod remainder not range rem => .. <an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_ between || multiset member SUBMULTISET_ PLZ solve this error give this question answer asap Thanks advance.......

1 Answers HCL,

What is flashback in Oracle?

0 Answers MCN Solutions,

What do you understand by a database object?

0 Answers

how to find out largest value in a table

2 Answers

How to transfer database(500 gb) of oracle enterprise edition to standard edition downtime is only 1 hour not using exp/imp option ?

3 Answers Digital Group,

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

0 Answers Goldman Sachs,

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

0 Answers

Can anyone give me information about oracle certification

1 Answers

How to define Data Block size ?

2 Answers

For more Oracle General Interview Questions Click Here