gs gs113 Nulls and Conditions and Miscellaneous - Database Copies - 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 7 multiple choice questions (MCQs) to prepare and belongs to topic Nulls and Conditions and Miscellaneous. 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 program that copies the databases from one server to another is ____________
mysqldbcopy
mysqlcopydb
mysqlflushdb
mysqldbflush
Question 2: Which privileges are required on the source server to use mysqldbcopy?
CREATE
INSERT
UPDATE
SELECT
Question 3: Which option is used in mysqldump to make all tables in the destination databases to use a different storage engine?
–next-storage-engine
–new-storage-engine
–clear-storage-engine
–get-storage-engine
Question 4: The function that returns reference to hash of row values is ____________
fetchrow_array()
fetchrow_arrayref()
fetch()
fetchrow_hashref()
Question 5: The best datatype for a column that is expected to store values up to 2 million is _________
SMALLINT
TINYINT
MEDIUMINT
BIGINT
Question 6: Which type stores the longest length of strings?
CHAR
VARCHAR
TINYTEXT
TEXT
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
