MySQL Quiz | MySQL Short Questions and Answers

Questions
41 Which among the following have the maximum bytes?
A Varchar
B Char
C Text type
D Both Varchar and Char

Answer: Text type
42 Which “text type” has the maximum number of bytes?
A Long text
B Medium text
C Text
D Tiny text

Answer: Long 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

Answer: Varchar2
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

Answer: 255 bytes
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

Answer: Varchar
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

Answer: Char
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
junior administrative assistant jaa test series