gs gs113 Query Optimization - Choosing Data Types for Efficient Queries - 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 Query Optimization. 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 2: To convert an int to string, the function is _________________
INET_ATON()
INET_NTOA()
INET_ITOS()
INET_STOI()
Question 3: To convert a string to an int, the function is _________________
INET_ATON()
INET_NTOA()
INET_ITOS()
INET_STOI()
Question 4: To maintain performance of tables having variable length rows, which statement is used?
MAINTAIN TABLE
BALANCE TABLE
ADJUST TABLE
OPTIMIZE TABLE
Question 5: Which of these columns are faster?
Variable length, Fixed length
same
variable length
fixed length
indeterminate
Question 6: Which of these take more space?
Variable length columns, Fixed length columns
variable length
same
fixed length
indeterminate
Question 7: To minimize disk I/O, which of these should be chosen?
CHAR, VARCHAR
CHAR
VARCHAR
CHAR & VARCHAR
Either CHAR or VARCHAR
Question 9: Which of these can be used to generate hash values?
MS5()
MA5()
MF5()
MD5()
Question 10: IP numbers can be represented as _________________
both integers and a string
a string but not integers
integers but not a string
neither a string nor integers
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
