JOBSEEKERS
Login
Sign Up
Jobseeker
Employer
Staffing Firm
Direct Client
MySQL interview questions part 42
MySQL interview questions part 42
Back
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. How many methods are available for the exception class?
A. Numeric
B. String
C. ENUM
D. TIME
Show Correct Answer
Correct Answer is :
TIME
2. Which version added the method getPrevious()?
A. AUTO_INCREMENT
B. UNSIGNED
C. IDENTIFY
D. DESCRIBE
Show Correct Answer
Correct Answer is :
AUTO_INCREMENT
3. Which of the following statements invoke the exception class?
A. $a[1].
B. $a[0].
C. $a.1
D. $a.0
Show Correct Answer
Correct Answer is :
$a[0].
4. Which one of the following is the right description for the method getMessage() ?
A. TRUE
B. FALSE
C.
D.
Show Correct Answer
Correct Answer is :
FALSE
5. You can extend the exception base class, but you cannot override any of the preceding methods because the are declared as__________
A. .
B. *
C. ->
D. @
Show Correct Answer
Correct Answer is :
->
6. What does SPL stand for?
A. TRUE
B. FALSE
C.
D.
Show Correct Answer
Correct Answer is :
TRUE
7. How many predefined exceptions does SPL provide access to?
A. cgi-inc
B. cgi-bin
C. cgi-usr
D. cgi-perl
Show Correct Answer
Correct Answer is :
cgi-bin
8. Which of the following is/are not an exception? i) BadFunctionCallException ii) BadMethodCallException iii) LogicException iv) DomainException
A. Trigger
B. Event
C. Stored function
D. Stored procedure
Show Correct Answer
Correct Answer is :
Event
9. Which of the following is/are an exception? i) OutOfBoundException ii) OutOfRangeException iii) OverflowException iv) UnderflowException
A. event_scheduler = ON
B. eventscheduler = ON
C. event_scheduler_ON
D. events_scheduler_ON
Show Correct Answer
Correct Answer is :
event_scheduler = ON
10. The filesize() function returns the file size in ___________
A. Trigger
B. Event
C. View
D. Table
Show Correct Answer
Correct Answer is :
View
11. Which one of the following PHP function is used to determine a file’s last access time?
A. bad
B. good
C. illegal
D. fare
Show Correct Answer
Correct Answer is :
good
12. Which one of the following function is capable of reading a file into an array?
A. 0
B. 1
C. 2
D. more than 1
Show Correct Answer
Correct Answer is :
more than 1
13. Which one of the following function is capable of reading a file into a string variable?
A. FROM
B. SELECT
C. ORDER By
D. WHERE
Show Correct Answer
Correct Answer is :
FROM
14. Which one of the following function is capable of reading a specific number of characters from a file?
A. FROM
B. WHERE
C. SELECT
D. ORDER BY
Show Correct Answer
Correct Answer is :
WHERE
15. Which one of the following function operates similarly to fgets(), except that it also strips any HTML and PHP tags form the input?
A. SELECT
B. GROUP BY
C. FROM
D. WHERE
Show Correct Answer
Correct Answer is :
GROUP BY
16. Which one of the following function outputs the contents of a string variable to the specified resource?
A. HAVING
B. FROM
C. WHERE
D. SELECT
Show Correct Answer
Correct Answer is :
HAVING
17. Which function sets the file filename last-modified and last-accessed times?
A. HAVING
B. ORDER BY
C. WHERE
D. FROM
Show Correct Answer
Correct Answer is :
ORDER BY
18. Which function is useful when you want to output the executed command result?
A. ALTER
B. FROM
C. SELECT
D. MODIFY
Show Correct Answer
Correct Answer is :
ALTER
19. Which one of the following function reads a directory into an Array?
A. WHERE
B. MODIFY
C. ALTER
D. FROM
Show Correct Answer
Correct Answer is :
WHERE
20. What will be the output of the following PHP code ?
A. ALTER
B. FROM
C. WHERE
D. ORDER BY
Show Correct Answer
Correct Answer is :
ALTER
Similar Interview Questions
Search for latest jobs
Find Jobs