COMPUTER SCIENCE AND ENGINEERING
DATABASE MANAGEMENT SYSTEM
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Auto number
|
|
|
Date / Time
|
|
|
Numeric
|
|
|
Yes/No
|
Detailed explanation-1: -Names and email addresses are always of the type string, while numbers can be stored as a numerical type or as string since a string is a set of characters including digits.
Detailed explanation-2: -The SMALLINT data type stores small whole numbers that range from –32, 767 to 32, 767. The maximum negative number, –32, 768, is a reserved value and cannot be used. 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-3: -h)The string data type will be used to represent ‘Address of the student’. However, if we have to store the address in a more structured format, we can use dictionary data type as well.
Detailed explanation-4: -The TIMESTAMP data type consists of a date and time, with optional time zone. (Optional) Indicates the number of digits of precision in the fractions of seconds, as an integer value from 0 to 9.