Which data type doesn't allow null data type?

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / nishi.swain

6 Answers
8307 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Which data type doesn't allow null data type?..

Answer / krishna kant kumar

SIMPLE_INTEGER

Is This Answer Correct ?

3 Yes

0 No

Which data type doesn't allow null data type?..

Answer / shailesh

First of all the way this question is asked is totally wrong. The learner may have to ask which data type does not allow null values.

All data types will allow to insert null values unless the Primary Key or Not Null constraint is defined on a column.

Is This Answer Correct ?

2 Yes

0 No

Which data type doesn't allow null data type?..

Answer / anil

not null,Primary key

Is This Answer Correct ?

3 Yes

3 No

Which data type doesn't allow null data type?..

Answer / rajesh

The first answer is wrong, because 'NULL' is string its not null.

If u give null in insert query as second parameter the row will be inserted.

Is This Answer Correct ?

1 Yes

1 No

Which data type doesn't allow null data type?..

Answer / mathivanan

NATURALN,POSITIVEN,SIMPLE_INTEGER

Is This Answer Correct ?

0 Yes

0 No

Which data type doesn't allow null data type?..

Answer / nanne saheb c

Can't insert NULL value in DATE data type. Please find the below practical as example.

CREATE TABLE Example(
name VARCHAR(30),
regist DATE,
PRIMARY KEY(name)
);

INSERT INTO Example VALUES ('anyname','NULL');

ORA-01841: (full) year must be between -4713 and +9999, and not be 0

Is This Answer Correct ?

3 Yes

10 No

Post New Answer