NULL is
A. the same as 0 for integer
B. the same as blank for character
C. the same as 0 for integer and blank for character
D. not a value
Answer: Option D
Solution(By Examveda Team)
NULL in SQL is used to represent missing or unknown data. It is not the same as 0 for integer or blank for character. In fact, NULL is not a specific value, but rather an absence of a value or a placeholder for missing data.So, the correct answer is Option D: not a value.
Join The Discussion
Comments ( 1 )
Related Questions on Sql Miscellaneous
A. Structured Query Language
B. Structured Query List
C. Simple Query Language
D. None of these
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
A. Data Definition Language(DDL)
B. Data Manipulation Language(DML)
C. Both of above
D. None
Which operator performs pattern matching?
A. BETWEEN operator
B. LIKE operator
C. EXISTS operator
D. None of these
What operator tests column for the absence of data?
A. EXISTS operator
B. NOT operator
C. IS NULL operator
D. None of these
Null is a value that is unavailable, unassigned, unknown or inapplicable. Null is not same as zero or a blank space.
Oracle Database Fundamentals I, Volume I, Page 1-14