gs gs113 Data Types - Choosing Data Types - 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: The AUTO_INCREMENT column attribute is best used with which type?
FLOAT
INT
CHARACTER
DOUBLE
Question 2: Which datatype is best suited to store currency values?
INT
FLOAT
DOUBLE
DECIMAL
Question 4: If a column is expected to store values up to 2 million, the best datatype for it is _____________
SMALLINT
TINYINT
MEDIUMINT
BIGINT
Question 5: Which of these types store the longest length of strings?
CHAR
VARCHAR
TINYTEXT
TEXT
Question 8: If an integer column is used for the values in range 1 to 99999, the best suitable datatype is ____________
MEDIUMINT SIGNED
MEDIUMINT UNSIGNED
SMALLINT SIGNED
SMALLINT UNSIGNED
Question 9: INT2 maps to MySQL type _____________
TINYINT
SMALLINT
MEDIUMINT
BIGINT
Question 10: INT3 maps to MySQL type _____________
TINYINT
SMALLINT
MEDIUMINT
BIGINT
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
