50 TOP MySQL Multiple Choice Questions and Answers pdf

Most Recently Asked MySQL Multiple Choice Questions and Answers pdf for freshers and experienced
1. Which of the following optimizations could be made based on data collected in the slow query log?
2. What kind of replication is supported by the MySQL server?
3. When performing diagnostic functions on a server should excessive start and stop messages be looked for in the error log, and why?
4. For which of the following objects can privileges be specified?
5. How can stored routines be used to check for constraints or legality of incoming data?
6. Which of the following is/are valid reasons to consider using --skip-networking?
7. Assuming that the user account 'joe'@'example.com' exists, executing DROP USER 'joe'@'example.com' has the following consequences:
8. Does max_connections have an affect on the number of slaves that may connect to a master?
9. Consider the following EXPLAIN output.
10. The type of file system you chose may affect MySQL use and/or performance with regard to...
11. Which of the following statements are true regarding the structure of grant tables in new distributions?
12. Can multi-column FULLTEXT indexes be used? If so, when?
13. Which of the following statements are true regarding wildcards in the host name of an account specification?
14. Which of the following best describes why InnoDB tables should always have primary keys and why they should be short?
15. Which of the following best describes what the master.info file contains and how it is used?
16. Which of the following best describes what MASTER_LOG_FILE and MASTER_LOG_POS provides?
17. Which of the following best describe the effects on performance for the dynamic-row format for MyISAM has?
18. Is it possible to tell the MySQL server to throw an error on division-by-zero rather than converting it to NULL and a warning?
19. Which of the following would be considered a good candidate table for compression?
20. The stored function year_to_date is created by the 'root'@'localhost' account as follows:
21. Can multi-column FULLTEXT indexes be used? If so, when?
22. When performing diagnostic functions on a server should excessive start and stop messages be looked for in the error log, and why?
23. Which of the following best describe the effects on performance for the dynamic-row format for MyISAM has?
24. Which of the following optimizations could be made based on data collected in the slow query log?
25. What kind of replication is supported by the MySQL server?
26. The main MySQL program that does all the data handling is called 
27. To use MySQL on your computer, you'll need 
28. MySQL comes with as standard with client libraries for: 
29. MySQL is available 
30. Internally information is held in tables. Which of these is NOT a valid format: 
31. Commands passed to the MySQL daemon are written in 
32. MySQL supports the complete SQL99 standard 
33. Which of these is not a valid name for a column 
34. In a LIKE clause, you can could ask for any value ending in "ton" by writing 
35. Which of the following can add a row to a table? 
36. Which of these commands will delete a table called XXX if you have appropriate authority: 
37. The USE command 
38. In a LIKE clause, you can ask for any 6 letter value by writing: 
39. MySQL runs on which operating systems? 
40. MySQL Access security is controlled through 
41. Which one of the following statements can be used to start MySQL 5.0 manually from the command line on windows?
42. Which of the following statements correctly describes the way to enable and use shared memory connections to the MySQL database server?
43. Which of the following is true of a MySQL client and server?
44. Which of the following is true for how the InnoDB storage engine uses diskspace?
45. When making connections to a MySQL server on a Unix platform, which of the following is true?
46. Which of the following best describes the processing model for how the MySQL server handles queries?
47. Of the following mechanisms available to connect a MySQL client to a MySQL database server, which types of connections are only available on Windows based systems?
48. MySQL is a multi-threaded database server. Every connection to the database server is handled by it's own thread.
49. Which of the following APIs/connectors are included in a MySQL distribution?
50. Another user has issued LOCK TABLES pets READ You can...

0 comments: