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

View Answer

Answer: Text type

42 Which “text type” has the maximum number of bytes?

A Long text

B Medium text

C Text

D Tiny text

View Answer

Answer: Long text

Article and Schedule Quiz	Start Test!

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

Answer: Either Fixed or Variable length string

ADRE 2.0 FULL LENGTH MOCK TEST

Take Mock Tests

Missiles Mock Test	Start Test!
SSC MTS Mock Test	Start Test
IBPS CLERK MOCK TEST	Start Test
SSC MTS 2022 JULY 26 Shift 1 (ENGLISH)	Start Test!
SSC GD Previous Year Paper 2021 Nov 17 Shift - I (Hindi)	Start Test!
SSC CGL Tier - 1 PYP 2022 April 21 Shift- 1 (ENGLISH)	Start Test!
MPSC PAPER I MOCK TEST 1 (ENGLISH)	Start Test!
IB Security Assistant Mock test 1 (english)	Start Test!
UP POLICE CONSTABLE MOCK TEST 1	Start Test!
DELHI POLICE CONSTABLE MOCK TEST 1 (HINDI)	Start Test!