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
