gs gs113 Query Optimization - Loading Data Efficiently - 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 3: Which is more efficient?
LOAD DATA, INSERT
LOAD DATA
INSERT
Same
Indeterminate
Question 4: Without LOCAL, LOAD DATA is _________________
more efficient
less efficient
same speed
arbitrary
Question 5: Which option turns on the –extended-insert?
–opt
–opti
–op
–optimize
Question 6: Which table option for MyISAM tables reduces index flushing?
DELAY_KEY_WRITE
DELAY_WRITE_KEY
KEY_WRITE_DELAY
WRITE_KEY_DELAY
Question 7: Which option repairs MyISAM tables automatically after they open?
–myisam-recover=FORCE
–myisam-recover=STOP
–recover-myisam=FORCE
–recover-myisam=STOP
Question 8: The option which delays index flushing for slave server is _________________
–delay-write-key=ALL
–delay-key-write=ALL
–key-write-delay=NONE
–key-delay-write=NONE
Question 9: TO enable the compressed client/server protocol the option is _________________
–enable
–compress
–reduce
–restrict
Question 10: To reactivate indexes the command used is _________________
DISABLE KEYS
DISABLE INDEXES
ENABLE KEYS
ENABLE INDEXES
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
