COMPUTER SCIENCE AND ENGINEERING
DATABASE MANAGEMENT SYSTEM
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Numeric
|
|
|
Currency
|
|
|
Short Text
|
|
|
Calculated
|
Detailed explanation-1: -The TEXT data type stores any kind of text data. It can contain both single-byte and multibyte characters that the locale supports.
Detailed explanation-2: -SQL data types can be broadly divided into the following categories. Numeric data types such as: INT, TINYINT, BIGINT, FLOAT, REAL, etc. Date and Time data types such as: DATE, TIME, DATETIME, etc. Character and String data types such as: CHAR, VARCHAR, TEXT, etc.
Detailed explanation-3: -A Boolean represents two possible states: TRUE or FALSE. $x = true; $y = false; Booleans are often used in conditional testing.
Detailed explanation-4: -The %ROWTYPE attribute provides a record type that represents a row in a database table. The record can store an entire row of data selected from the table or fetched from a cursor or cursor variable.