Q961
Open questionWhich operators test whether a subquery returns any rows?
Select an option to see the answer and solution.
MySQL · all questionsMySQL
MySQL
practice.
Practice every MCQ with options. Use Show answers when you want the correct option and solution.
1,185
Questions
49/60
Page
Pick an option on a question to see the right answer and solution.
Q962
Open questionWhat is the exec_stmt_ssl written in?
Select an option to see the answer and solution.
Q963
Open questionThe SQL mode to check for divide by zero error is . . . . . . . .
Select an option to see the answer and solution.
Q964
Open questionTo execute the contents of a query file 'exec.sql' by feeding it to mysql, which command is used?
Select an option to see the answer and solution.
Q965
Open questionWhich API provides the lowest level interface to the server?
Select an option to see the answer and solution.
Q966
Open questionTransactional processing requires lesser overhead due to CPU cycles and memory.
Select an option to see the answer and solution.
Q967
Open questionWhat will be the output of the following MySQL statement "Null OR Null"?
Select an option to see the answer and solution.
Q968
Open questionThe module that links DBI to the web is . . . . . . . .
Select an option to see the answer and solution.
Q969
Open questionMEMORY tables do not support BLOB and TEXT indexes.
Select an option to see the answer and solution.
Q970
Open questionWhich of the following lines is used to turn on the event scheduler?
Select an option to see the answer and solution.
Q971
Open questionIf $a represents an array with numeric indices in PHP, the first element accessed by . . . . . . . .
Select an option to see the answer and solution.
Q972
Open questionThe variable that checks for availability of SSL support is . . . . . . . .
Select an option to see the answer and solution.
Q973
Open questionWhich option turns on the -extended-insert?
Select an option to see the answer and solution.
Q974
Open questionAn embedded application includes the server side and client side.
Select an option to see the answer and solution.
Q975
Open questionTo reactivate indexes the command used is . . . . . . . .
Select an option to see the answer and solution.
Q976
Open questionWhat will be the order of sorting in the following MySQL statement?
SELECT emp_id, emp_name
FROM person
ORDER BY emp_id, emp_name;Select an option to see the answer and solution.
Q977
Open questionWhich keyword is used to create a table as a temporary copy of itself?
Select an option to see the answer and solution.
Q978
Open questionWhich function returns NULL if expr1 = expr2?
Select an option to see the answer and solution.
Q979
Open questionWhat performs a key distribution analysis and stores the distribution for the named table or tables?
Select an option to see the answer and solution.
Q980
Open questionIn inner join, result is produced by matching rows in one table with rows in another table.
Select an option to see the answer and solution.