MySQL Interview Questions - 56 | Snaprecruit.com
MySQL Interview Questions - 56 | Snaprecruit.com
JOBSEEKERS
Login
Sign Up
Jobseeker
Employer
Staffing
Enterprises
MySQL interview questions part 56
MySQL interview questions part 56
Back
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 ? ($y != $y++)){ echo $y;}?>
A. YES
B. NO
C. DEPENDS
D. None of the mentioned
Show Correct Answer
Correct Answer is :
NO
2. What will be the output of the following PHP code ?
A. No Error
B. No table mentioned
C. Depends
D. None of the mentioned
Show Correct Answer
Correct Answer is :
No table mentioned
3. What will be the output of the following PHP code ? ";}?>
A. Show all columns but only those rows which belongs to person_id=1
B. Show all columns and rows
C. Shows only columns person_id
D. None of the mentioned
Show Correct Answer
Correct Answer is :
Show all columns but only those rows which belongs to person_id=1
4. What will be the output of the following PHP code ?
A. Show only columns(person_id, fname, lname) but only those rows which belongs to person_id=1
B. Show all columns and rows
C. Shows only columns person_id
D. None of the mentioned
Show Correct Answer
Correct Answer is :
Show only columns(person_id, fname, lname) but only those rows which belongs to person_id=1
5. What will be the output of the following PHP code ?
A. FROM
B. WHERE
C. Both FROM and WHERE
D. None of the mentioned
Show Correct Answer
Correct Answer is :
FROM
6. What will be the output of the following PHP code ? 0){ $i++; print $i; print "hello";}?>
A. Literals
B. Expressions
C. User defined functions
D. All of the mentioned
Show Correct Answer
Correct Answer is :
All of the mentioned
7. What will be the output of the following PHP code ? 0 && ++$i){ print $i;}?>
A. Yes
B. NO
C. Depends on condition
D. None of the mentioned
Show Correct Answer
Correct Answer is :
NO
8. What will be the output of the following PHP code ? 0 || ++$i){ print $i;}?>
A. Yes, “FROM” is not used
B. No
C. Depends
D. None of the mentioned
Show Correct Answer
Correct Answer is :
No
9. What will be the output of the following PHP code ?
A. To assign a new label to the column in result set
B. To overwrite the existing column name in result set
C. To modify the column name while using literals, Expression, built_in functions with “SELECT clause
D. All of the mentioned
Show Correct Answer
Correct Answer is :
All of the mentioned
10. What will be the output of the following PHP code ?
A. emp_id, ACTIVE, emp_id * 314, UPPER(lname)
B. emp_id, Status, emp_pi, last_name
C. Error
D. None of the mentioned
Show Correct Answer
Correct Answer is :
emp_id, Status, emp_pi, last_name
11. What will be the output of the following PHP code ? ++$i) - 1){ print $i;}?>
A. emp_id, ACTIVE, emp_id * 314, UPPER(lname)
B. emp_id, Status, emp_pi, last_name
C. Error
D. None of the mentioned
Show Correct Answer
Correct Answer is :
emp_id, Status, emp_pi, last_name
12. What will be the output of the following PHP code ? 0) print $i;}?>
A. DISTINCTS
B. MODIFY
C. DISTINCT
D. All of the mentioned
Show Correct Answer
Correct Answer is :
DISTINCTS
13. What will be the output of the following PHP code ? 0) print $i;}?>
A. {1, 2, 2, 3, 3, 5, 6, 7, 8, 8}
B. {1, 2, 3, 5, 6, 7, 8}
C. { }
D. None of the mentioned
Show Correct Answer
Correct Answer is :
{1, 2, 3, 5, 6, 7, 8}
14. What will be the output of the following PHP code ?
A. {1,2,2,3,3,5,6,7,8,8}
B. {1,2,3,5,6,7,8}
C. { }
D. None of the mentioned
Show Correct Answer
Correct Answer is :
{1,2,3,5,6,7,8}
15. What will be the output of the following PHP code ?
A. DISTINICTS
B. ALL
C. AS
D. Both AS and ALL
Show Correct Answer
Correct Answer is :
Both AS and ALL
16. What will be the output of the following PHP code ?
A. Filtering out unwanted rows from result set
B. Filtering out unwanted columns from result set
C. Filtering out unwanted rows and columns from result set
D. None of the mentioned
Show Correct Answer
Correct Answer is :
Filtering out unwanted rows from result set
17. What will be the output of the following PHP code ?
A. All columns and rows belong to table employee
B. All columns but only those rows which contain ‘HEAD TELLER’ as a “title”
C. All columns don’t belong to table employee
D. None of the mentioned
Show Correct Answer
Correct Answer is :
All columns but only those rows which contain ‘HEAD TELLER’ as a “title”
18. What will be the output of the following PHP code ?
A. All columns and rows belong to table employee
B. All columns but only those rows which contain ‘HEAD TELLER’ as a “title” and 2013-01-24 as a “start_date”
C. All rows belong to table employee
D. None of the mentioned
Show Correct Answer
Correct Answer is :
All columns but only those rows which contain ‘HEAD TELLER’ as a “title” and 2013-01-24 as a “start_date”
19. What will be the output of the following PHP code ?
A. All columns and rows belong to table employee
B. All columns but only those rows which contain ‘HEAD TELLER’ as a “title” or 2013-01-24 as a “start_date”
C. All rows belong to table employee
D. None of the mentioned
Show Correct Answer
Correct Answer is :
All columns but only those rows which contain ‘HEAD TELLER’ as a “title” or 2013-01-24 as a “start_date”
20. What will be the output of the following PHP code ?
A. All columns and rows belong to table employee
B. All columns but only those rows which contain ‘HEAD TELLER’ as a “title” and start_date are greater than 2013-01-24
C. All rows belong to table employee
D. None of the mentioned
Show Correct Answer
Correct Answer is :
All columns but only those rows which contain ‘HEAD TELLER’ as a “title” and start_date are greater than 2013-01-24
Similar Interview Questions
Search for latest jobs
Find Jobs