MySQL interview questions part 19
MySQL interview questions part 19
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. If a class have a public member function and is called directly in the main function then ___________________________
Correct Answer is : –sql-mode=IGNORE_SPACE
2. The function main() must always be public.
Correct Answer is : –sql-mode=IGNORE_SPACE
3. All the public member functions ___________________
Correct Answer is : NULLIF()
4. In which of the following way(s) can the object be returned from a function?
Correct Answer is : NULLIF()
5. Whenever an object is returned by value ____________________
Correct Answer is : SOUNDS LIKE
6. Where the temporary objects (created while return by value) are created?
Correct Answer is : SOUNDS LIKE
7. Which is the correct syntax for returning an object by value?
Correct Answer is : INSTR()
8. Which is the correct syntax for defining a function which passes an object by reference?
Correct Answer is : INSTR()
9. If an object is declared inside the function then ____________________ outside the function
Correct Answer is : FALSE
10. How many independent objects can be returned at same time from a function?
Correct Answer is : FALSE
11. Which error will be produced if a local object is returned by reference outside a function?
Correct Answer is : TRUE
12. If object is passed by reference ____________________
Correct Answer is : TRUE
13. Can we return an array of objects?
Correct Answer is : 1
14. If an object is passed by reference to a function then it must be returned by reference.
Correct Answer is : 1
15. If an object is being returned by value then __________________________
Correct Answer is : select_list
16. Why temporary object is not created in return by reference?
Correct Answer is : select_list
17. Which among the following defines single level inheritance?
Correct Answer is : RIGHT JOIN
18. If class A and class B are derived from class C and class D, then ________________
Correct Answer is : RIGHT JOIN
19. If single inheritance is used, program will contain ________________
Correct Answer is : subquerying
20. Single level inheritance supports _____________ inheritance.
Correct Answer is : subquerying
