MySQL interview questions part 57
MySQL interview questions part 57
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. What will be the output of the following PHP code ?
Correct Answer is : All columns but only those rows which contain ‘HEAD TELLER’ as a “title” OR start_date are greater than 2013-01-24
2. What will be the output of the following PHP code ?
Correct Answer is : Columns mention with “SELECT” clause and only those rows which contain ‘HEAD TELLER’ as a “title”
3. What will be the output of the following PHP code ?
Correct Answer is : Columns mention with “SELECT” clause and only those rows which contain ‘HEAD TELLER’ as a “title” and start_date as 2008-11-24
4. What will be the output of the following PHP code ?
Correct Answer is : Columns mention with “SELECT” clause and only those rows which contain ‘HEAD TELLER’ as a “title” and start_date>2008-11-23
5. What will be the output of the following PHP code ?
Correct Answer is : TRUE
6. What will be the output of the following PHP code ?
Correct Answer is : CREATE TRIGGER
7. What will be the output of the following PHP code ?
Correct Answer is : views
8. What will be the output of the following PHP code ?
Correct Answer is : DROP
9. What will be the output of the following PHP code ?
Correct Answer is : SUPER
10. What will be the output of the following PHP code ?
Correct Answer is : TRUE
11. What will be the output of the following PHP code ?
Correct Answer is : trigger name
12. What will be the output of the following PHP code ?
Correct Answer is : table name
13. What will be the output of the following PHP code ?
Correct Answer is : trigger statement
14. What will be the output of the following PHP code ?
Correct Answer is : condition value
15. What will be the output of the following PHP code ? ($j - $k));?>
Correct Answer is : sql_mode
16. What will be the output of the following PHP code ? ! ($j - $k));?>
Correct Answer is : delayed_queue_size
17. What will be the output of the following PHP code ?
Correct Answer is : 1GB
18. What will be the output of the following PHP code ?
Correct Answer is : table_cache
19. What will be the output of the following PHP code ?
Correct Answer is : TRUE
20. What will be the output of the following PHP code ?
Correct Answer is : DISTINCT
