gs gs113 General MySQL Administration - Securing a New MySQL Installation - 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 2: Which script initializes the data directory during installation?
mysql_install_db
mysql_install_dbm
mysql_init_db
mysql_init_dbm
Question 3: Anonymous accounts have user name ______________
root
blank
super
prime
Question 5: What does the default case sensitivity of database and table names depend on?
SQL server
Server SQL mode
Operating system of machine
Does not depend on anything
Question 6: The case sensitive among these is ______________
Stored function name
Stored procedure name
Trigger name
Event name
Question 7: The variable used to set table alias names as non case sensitive is ______________
lower_case_table_names
lower_case_all
lower_case_alias
lower_case_aliases
Question 9: The statement used to find out which character sets are available is ______________
SHOW CHARACTER SET
SHOW COLLATION
SHOW CHARACTER SETS
SHOW COLLATIONS
Question 10: The collations this statement lists are ______________
SHOW COLLATION LIKE 'utf8%'
names beginning with utf8
names ending with utf8
names containing utf8% anywhere
names ending in utf8%
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
