gs gs113 Data Types - MySQL Datatypes - Quiz No.3
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 is the default format for “Date” data type?
YYYY-MM-DD
MM-YYYY-DD
DD-MM-YYYY
None of the mentioned
Question 2: What is the default format for “Datetime” data type?
YYYY-MM-DD HH:MI:SS
MM-YYYY-DD HH:MI:SS
DD-YYYY-MM MI:HH:SS
None of the mentioned
Question 3: What is the default format for “Timestamp” data type?
YYYY-MM-DD HH:MI:SS
MM-YYYY-DD HH:MI:SS
DD-YYYY-MM MI:HH:SS
None of the mentioned
Question 4: What is the default format for “Year” data type?
YYYY
YYYY-DD-MM
MM-YYYY-DD
None of the mentioned
Question 5: What is the default format for “Time” data type?
HHH:MI:SS
SS:MI:HHH
MI:SS:HHH
None of the mentioned
Question 6: Is “Datetime” and “Timestamp” are same data type?
Yes
No
Depends
None of the mentioned
Question 7: Which value will show an error when stored in float(4,2)?
12.11
13.1
1.12
123.44
Question 8: The datatype for single precision floating point number is ____________
FLOAT
DOUBLE
INT
BIGINT
Question 9: Which datatype is used for a fixed length binary string?
VARCHAR
BINARY
VARBINARY
BLOB
Question 10: Which datatype means a variable length non binary string?
VARCHAR
BINARY
VARBINARY
BLOB
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
