MySQL Interview Questions - 3 | Snaprecruit.com

MySQL Interview Questions - 3 | Snaprecruit.com

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

Similar Interview Questions

    Search for latest jobs

    Icon
    Icon