gs gs113 General MySQL Administration - Updating MySQL - 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 General MySQL Administration. 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: Which upgrade involves exporting existing data using mysqldump?
inplace
logical
illogical
system
Question 2: Which upgrade involves shutting down the old MySQL version and replacing the old binaries?
inplace
logical
illogical
system
Question 5: The command to see the warning messages is ______________
DISPLAY WARNINGS
DISP WARNINGS
DISP WARNING
SHOW WARNINGS
Question 6: What is the SQL mode to check for divide by zero error?
STRICT_ALL_TABLES
ERROR_FOR_DIVISION_BY_ZERO
ERROR_DIVIDE_BY_ZERO
ERROR_WHEN_DIVIDE_BY_ZERO
Question 7: The mode used to turn on strict mode and all of the additional restrictions is _____________
STRICT_ALL_TABLES
ERROR_FOR_DIVISION_BY_ZERO
TRADITIONAL
ERROR_WHEN_DIVIDE_BY_ZERO
Question 9: How would a stored function named PI() written in the database ‘sampdb’ be called?
PI()
sampdb.PI()
MySQL.PI()
db.PI()
Question 10: The privilege that must be given to the database to create a stored function or procedure is ____________
CREATE ROUTINE
CREATE METHOD
CREATE FUNCTION
CREATE PROCEDURE
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
