gs gs113 Data Types - MySQL Datatypes - Quiz No.2
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: What will happen if the data being loaded into a text column exceeds the maximum size of that type?
Extra memory will be allocated
Process terminate
Data will be truncated
Depend on the system
Question 2: Which data type is more suitable for storing “small notes” in Mysql?
Char
Varchar
Mediumtext
Longtext
Question 3: Which data type is more suitable for storing “documents” in Mysql?
Varchar
Longtext
Mediumtext
Either Varchar or Longtext
Question 4: “Numeric Data” is used to store ____________
Whole numbers
Natural numbers
Rational numbers
Both Whole and Natural numbers
Question 5: Which Numeric Data type has the largest range?
Mediumint
Smallint
Int
Tinyint
Question 6: What will be the storage pattern for “float(4,2)” in Mysql?
Total of four digits, two to the left of decimal and two to the right of decimal
Total of six digits
Total of four digits, not distributed uniformly
None of the mentioned
Question 7: Which among the following are the correct representation of “float(4,2)”?
24.33
124.4
12.123
Both 24.33 and 124.4
Question 8: Which among the following is the correct representation of “float(5,0)”?
12345.123
12345.1
12345
123.123
Question 9: Which among the following is the correct representation of “float(1,1)”?
Total of 1 digit
Total of 2 digit
Total of 2 digit, one digit at right of the decimal, one digit at left of the decimal
None of the mentioned
Question 10: Which data type is used to store data and time in Mysql?
Numeric data type
Text data type
Temporal data type
Char/Varchar
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
