DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
date
|
|
|
alphanumeric
|
|
|
float
|
|
|
boolean
|
Detailed explanation-1: -BOOLEAN can be used as a data type when defining a column in a table or a variable in a database procedure. Support for the BOOLEAN data type helps migrations from other database products. Boolean columns accept as input the SQL literals FALSE and TRUE.
Detailed explanation-2: -The BOOLEAN data type is a 1-byte data type. The legal values for Boolean are true (’t’), false (’f’), or NULL. The values are not case sensitive.
Detailed explanation-3: -The BOOLEAN data type stores TRUE or FALSE data values as a single byte. The following table shows internal and literal representations of the BOOLEAN data type. You can compare two BOOLEAN values to test for equality or inequality. You can also compare a BOOLEAN value to the Boolean literals ‘ t ‘ and ‘ f ‘.
Detailed explanation-4: -Boolean operators form the basis of mathematical sets and database logic. They connect your search words together to either narrow or broaden your set of results. The three basic boolean operators are: AND, OR, and NOT.