gs gs113 Data Types - MySQL Datatypes - Quiz No.1
gs gs113 MySQL Quiz
This quiz belongs to book/course code gs gs113 MySQL of gs organization. We have 126 quizzes available related to the book/course MySQL. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Data Types. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: Character data can be stored as ______________
Fixed length string
Variable length string
Either Fixed or Variable length string
None of the mentioned
Question 2: Which declaration represents that “character data will consume the same number of bytes as declared and is right padded”?
Char
Varchar
Both Char and Varchar
None of the mentioned
Question 3: Which declaration doesn’t use the same number of bytes and consumption of bytes depends on the input data?
Varchar
Char
Both Varchar and Char
None of the mentioned
Question 4: The maximum length of the char columns is ____________
255 bytes
65, 535 bytes
256 bytes
None of the mentioned
Question 5: The maximum length of the varchar columns is ____________
Upto 65, 535 bytes
Upto 256 bytes
Upto 65, 567 bytes
None of the mentioned
Question 6: In oracle database variable length column is declared by ____________
Varchar
Varchar 3
Varchar2
None of the mentioned
Question 7: Mysql support different character sets, which command is used to display all character sets?
SHOW CHARACTER SET;
SHOW;
CHARACTER SET;
None of the mentioned
Question 8: Which one is the correct declaration for choosing the character set other than default?
Varchar(20) character set utf8;
Varchar(20);
Varchar(20) character set;
None of the mentioned
Question 9: Which “text type” has the maximum number of bytes?
Tiny text
Text
Medium text
Long text
Question 10: Which among the following have the maximum bytes?
Varchar
Char
Text type
Both Varchar and Char
Online Quizzes of gs113 MySQL
MySQL Programs Using C - Using the Embedded Server Library - Quiz No.1
gs gs113
MySQL Online Quizzes
System, Status and User Variables - User-Defined Variables - Quiz No.1
gs gs113
MySQL Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.1
gs gs113
MySQL Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.2
gs gs113
MySQL Online Quizzes
