1. How do I find out all databases starting with ‘test‘?
Correct Answer is : SHOW DATABASES LIKE ‘test%’;
2. Which of the following ways are the correct way to get the current date?
Correct Answer is : All of the above
3. How can we get the number of records or rows in a table?
Correct Answer is : Using COUNT
4. When do we use a HAVING clause?
Correct Answer is : To limit the output of a query using an aggregate function only
5. What is a candidate key?
Correct Answer is : Used to uniquely identify a row
6. How many local classes can be defined inside a single function?
Correct Answer is : Access Control Lists
7. All the data members of local class must be ___________
8. Can two different functions have local class with same name?
9. What is the scope of local class?
Correct Answer is : Server administration
10. Can a function, other than the enclosing function of local class, access the class members?
11. Which among the following is main advantage of using local classes?
12. Which among the following best describes member functions?
13. How many types of member functions are generally there in C++?
14. How can a static member function be called in main function?
15. What are inline member functions?
16. What happens if non static members are used in static member function?
Correct Answer is : memory
17. Static member functions _____________
Correct Answer is : table_cache
18. How to access members of the class inside a member function?
Correct Answer is : Opened_tables
19. For overloading “( )”, “[ ]” or “->” operators, a class __________
20. If a virtual member function is defined, ___________
Correct Answer is : innodb_log_buffer_size