Download PDF
Free download in PDF MySQL Short Questions and Answers for competitive exams. These short objective type questions with answers are very important for Board exams as well as competitive exams. These short solved questions or quizzes are provided by Gkseries.
41
Which among the following have the maximum bytes?
[A]
Varchar
[B]
Char
[C]
Text type
[D]
Both Varchar and Char
42
Which “text type” has the maximum number of bytes?
[A]
Long text
[B]
Medium text
[C]
Text
[D]
Tiny text
43
Which one is the correct declaration for choosing the character set other than default?
[A]
Varchar(20) character set utf8;
[B]
Varchar(20);
[C]
Varchar(20) character set;
[D]
None of the mentioned
Answer: Varchar(20) character set utf8;
44
Mysql support different character sets, which command is used to display all character sets?
[A]
SHOW CHARACTER SET;
[B]
SHOW;
[C]
CHARACTER SET;
[D]
None of the mentioned
Answer: SHOW CHARACTER SET;
45
In oracle database variable length column is declared by ____________
[A]
Varchar
[B]
Varchar 3
[C]
Varchar2
[D]
None of the mentioned
46
The maximum length of the varchar columns is ____________
[A]
Upto 65, 535 bytes
[B]
Upto 256 bytes
[C]
Upto 65, 567 bytes
[D]
None of the mentioned
Answer: Upto 65, 535 bytes
47
The maximum length of the char columns is ____________
[A]
255 bytes
[B]
65, 535 bytes
[C]
256 bytes
[D]
None of the mentioned
48
Which declaration doesn’t use the same number of bytes and consumption of bytes depends on the input data?
[A]
Varchar
[B]
Char
[C]
Both Varchar and Char
[D]
None of the mentioned
49
Which declaration represents that “character data will consume the same number of bytes as declared and is right padded”?
[A]
Char
[B]
Varchar
[C]
Both Char and Varchar
[D]
None of the mentioned
50
Character data can be stored as ______________
[A]
Fixed length string
[B]
Variable length string
[C]
Either Fixed or Variable length string
[D]
None of the mentioned
Answer: Either Fixed or Variable length string
Please share this page