Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

Is sql developer case sensitive?

0 Answers  


mail-id table contains two columns(email_id,userid) it contains different types of mail-ids,and no of users. here username length is differ na,(ex- tamil@yahoo.com,joshua@hotmail.com like) now i want to fetch the email-ids only starting from '@' (ex-@gmail.com,@yahoo.com,@hotmail.com

5 Answers  


how can we submit a form without a submit button? : Sql dba

0 Answers  


define sql

3 Answers   Zensar,


What is the difference between anonymous block and named blocks?

3 Answers  


What is forward declaration in pl sql?

0 Answers  


What is integrity in sql?

0 Answers  


What are pl/sql packages?

0 Answers  


List the ways to get the count of records in a table?

0 Answers  


Do we need to rebuild index after truncate?

0 Answers  


how to create object in plsql

3 Answers   Microsoft,


What are the differences between in and exists clause?

0 Answers  


Categories