MySQL interview questions part 1
MySQL interview questions part 1
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
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 ___________
Correct Answer is : TRUE
8. Can two different functions have local class with same name?
Correct Answer is : TRUE
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?
Correct Answer is : 3
11. Which among the following is main advantage of using local classes?
Correct Answer is : C
12. Which among the following best describes member functions?
Correct Answer is : C
13. How many types of member functions are generally there in C++?
Correct Answer is : C
14. How can a static member function be called in main function?
Correct Answer is : -lm
15. What are inline member functions?
Correct Answer is : -o
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 __________
Correct Answer is : 8
20. If a virtual member function is defined, ___________
Correct Answer is : innodb_log_buffer_size
