MySQL Interview Questions - 4 | Snaprecruit.com

MySQL Interview Questions - 4 | Snaprecruit.com

MySQL interview questions part 4

MySQL interview questions part 4

Take as many assements as you can to improve your validate your skill rating

Total Questions: 20

1. If all the classes use private inheritance in multilevel inheritance then ______________

Correct Answer is : lower

2. Multilevel inheritance allows _________________ in the program.

Correct Answer is : TRUE

3. What is minimum number of levels for a implementing multilevel inheritance?

Correct Answer is : Logfile group names

4. In multilevel inheritance one class inherits _______________

Correct Answer is : COLLATION

5. All the classes must have all the members declared private to implement multilevel inheritance.

Correct Answer is : Accent Insensitive

6. Can abstract classes be used in multilevel inheritance?

Correct Answer is : more than 1

7. How many abstract classes can be used in multilevel inheritance?

Correct Answer is : TRUE

8. If all the classes used parameterized constructors and no default constructor then, ___________

Correct Answer is : COLLATE

9. In multilevel inheritance, which is the most significant feature of OOP used?

Correct Answer is : SHOW CHARACTER SET

10. Does following code show multiple inheritance?   class A { int a; }; class B { int b; }; class C:public A, public B { int c; }; class D:public C { int d; };

Correct Answer is : names beginning with utf8

11. Is it compulsory for all the classes in multilevel inheritance to have constructors defined explicitly if only last derived class object is created?

Correct Answer is : SHOW VARIABLES

12. Multiple inheritance is ____________________

Correct Answer is : Unicode Transformation Format

13. Which problem arises due to multiple inheritance, if hierarchical inheritance is used previously for its base classes?

Correct Answer is : 3 bytes

14. How many classes should a program contain to implement the multiple inheritance?

Correct Answer is : 4 bytes

15. Which programming language restricts the use of multiple inheritance?

Correct Answer is : CHARSET

16. Is it possible to have all the abstract classes as base classes of a derived class from those?

Correct Answer is : 3

17. If class A inherits class B and class C as “class A: public class B, public class C {// class body ;}; ”, which class constructor will be called first?

Correct Answer is : 3

18. Why does diamond problem arise due to multiple inheritance?

Correct Answer is : key_buffer_size

19. How many base classes can a derived class have which is implementing multiple inheritance?

Correct Answer is : –new-storage-engine

20. How to overcome diamond problem ?

Correct Answer is : mysqld

Similar Interview Questions

    Search for latest jobs

    Icon
    Icon