MySQL Interview Questions - 35 | Snaprecruit.com

MySQL Interview Questions - 35 | Snaprecruit.com

MySQL interview questions part 35

MySQL interview questions part 35

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

Total Questions: 20

1. If one intends to create a model that will be assumed by a number of closely related objects, which class must be used?

Correct Answer is : InnoDB

2. If your object must inherit behavior from a number of sources you must use a/an

Correct Answer is : database interface

3. Which method is used to tweak an object’s cloning behavior?

Correct Answer is : /usr/bin/perl

4. Which feature allows us to call more than one method or function of the class in single instruction?

Correct Answer is : select_list

5. Which magic method is used to implement overloading in PHP?

Correct Answer is : TRUE

6. PHP’s numerically indexed array begin with position ___________

Correct Answer is : TRUE

7. Which of the following are correct ways of creating an array? i) state[0] = “karnataka”; ii) $state[] = array(“karnataka”); iii) $state[0] = “karnataka”; iv) $state = array(“karnataka”);

Correct Answer is : dynamically generated

8. Which function will return true if a variable is an array or false if it is not?

Correct Answer is : TRUE

9. Which in-built function will add a value to the end of an array?

Correct Answer is : CARTESIAN

10. What will be the output of the following PHP code?

Correct Answer is : WHERE

11. What will be the output of the following PHP code?

Correct Answer is : INNER JOIN

12. Which function can be used to move the pointer to the previous array position?

Correct Answer is : TRUE

13. What will be the output of the following PHP code?

Correct Answer is : OUTER JOIN

14. Which function returns an array consisting of associative key/value pairs?

Correct Answer is : SELF

15. hat will be the output of the following PHP code?

Correct Answer is : LEFT JOIN

16. What will be the output of the following PHP code?

Correct Answer is : RIGHT JOIN

17. What will be the output of the following PHP code?

Correct Answer is : subquerying

18. What will be the output of the following PHP code? "red", "b" => "green", "c" => "blue", "d" => "yellow");$a2 = array("e" => "red", "f" => "green", "g" => "blue", "h" => "orange");$a3 = array("i" => "orange");$a4 = array_merge($a2, $a3);$result = array_diff($a1, $a4);print_r($result);?>

Correct Answer is : scalar

19. What will be the output of the following PHP code?

Correct Answer is : FALSE

20. What will be the output of the following PHP code? "india", "b" => "brazil", "c" => "china");echo array_shift($a);echo "
"array_pop($a);print_r($a);?>

Correct Answer is : IN and NOT IN

Similar Interview Questions

    Search for latest jobs

    Icon
    Icon