MySQL interview questions part 3
MySQL interview questions part 3
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. Which operator among the following must be overloaded using the friend function?
Correct Answer is : CREATE
2. What does memory allocation for objects mean?
Correct Answer is : db.opt
3. Where is the memory allocated for the objects?
Correct Answer is : MyISAM
4. When is the memory allocated for an object?
Correct Answer is : my_tbl.frm
5. Using new is type safe as _______________________
Correct Answer is : TRUE
6. Which of the following function can be used for dynamic memory allocation of objects?
Correct Answer is : Relational
7. How much memory will be allocated for an object of class given below? class Test { int mark1; int mark2; float avg; char name[10]; };
Correct Answer is : Tables
8. Which keyword among the following can be used to declare an array of objects in java?
Correct Answer is : TRUE
9. When is the memory allocated for an object gets free?
Correct Answer is : Column
10. Which among the following keyword can be used to free the allocated memory for an object?
Correct Answer is : Row
11. Which function is called whenever an object goes out of scope?
Correct Answer is : SQL
12. Which operator can be used to check the size of an object?
Correct Answer is : A column
13. The memory allocated for an object ____________________
Correct Answer is : MySQL server
14. If an object is declared in a user defined function __________________
Correct Answer is : mysqld
15. In java, ____________________ takes care of managing memory for objects dynamically.
Correct Answer is : Schema
16. Which operator can be used to free the memory allocated for an object in C++?
Correct Answer is : FALSE
17. Which among the following best defines multilevel inheritance?
Correct Answer is : display contents of table_1
18. If there are 5 classes, E is derived from D, D from C, C from B and B from A. Which class constructor will be called first if the object of E or D is created?
Correct Answer is : Operating system of machine
19. If there are 3 classes. Class C is derived from class B and B is derived from A, Which class destructor will be called at last if object of C is destroyed.
Correct Answer is : Trigger name
20. Which Class is having highest degree of abstraction in multilevel inheritance of 5 levels?
Correct Answer is : lower_case_table_names
