gs gs113 Database Maintenance, Backups and Replication - Performing Database Maintenance with the Server Running - 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 Database Maintenance, Backups and Replication. 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: To perform consistency checks on a MyISAM table the statement is _____________
CHECK TABLE
REPAIR TABLE
ANALYZE TABLE
OPTIMIZE TABLE
Question 2: The statement that performs key distribution analysis and stores the distribution for the named tables is _____________
CHECK TABLE
ANALYZE TABLE
CHECKSUM TABLE
OPTIMIZE TABLE
Question 3: The column not returned by ‘OPTIMIZE TABLE’ is _____________
Table
Msg_txt
Op
Msg_type
Question 4: For which table does ‘REPAIR TABLE’ not work?
MyISAM
ARCHIVE
CSV
InnoDB
Question 5: What is the Perl DBI?
database inheritance
database integrity
database interface
database isolation
Question 6: What is the default path to Perl in Unix?
/usr/bin/perl
/usr/bin
/usr/perl
/usr/perl/bin
Question 7: How is the output from PHP generated?
statically generated
dynamically generated
not generated
no output
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
