Which data type doesn't allow null data type?

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

More SQL PLSQL Interview Questions

can i create trigger on synonym is it possible or not please help me

4 Answers   CGI,


How many triggers can be applied on a table?

0 Answers  


How do I install sql?

0 Answers  


What are types of joins?

0 Answers  


Is hadoop a nosql?

0 Answers  






What is an Integrity Constraint?

4 Answers  


What is the use of stored procedures?

0 Answers  


What are the rules to be applied to nulls whilst doing comparisons?

0 Answers  


What are the benefits of pl/sql packages?

0 Answers  


how to use in conditions? : Sql dba

0 Answers  


What is data type in sql?

0 Answers  


How do I create an index in word?

0 Answers  


Categories