MySQL Quiz | MySQL Short Questions and Answers

Sports GK Questions and Answers 2024 (Latest Updated)

Awards & Honours GK Questions 2024 (Latest Updated)

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
Advertisement
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

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

Random GK Questions

Q. A member of the Union Public Service Commission can be removed by the
Q. Directive Principles of State Policy are fundamental for :
Q. Bajada is the formation of
Q. The item Education belongs to the
Q. ISI mark is not given to which of the following products?
Q. Which of the following States was first to adopt the Panchayati Raj?
Assam Direct Recruitment Test Series

Teacher Eligibility Test

Assam Direct Recruitment Test Series