Q941
Open questionWhat are CROSS JOIN and JOIN are similar to?
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
48/60
Page
Pick an option on a question to see the right answer and solution.
Q942
Open questionUsage of aggregates in WHERE clause is disallowed.
Select an option to see the answer and solution.
Q943
Open questionIn the database directory of the database each view and trigger object is associated with how many files?
Select an option to see the answer and solution.
Q944
Open questionWhich option prints output in table-format when MySQL is run interactively?
Select an option to see the answer and solution.
Q945
Open questionWhat will be the output of the following MySQL statement "true AND Null"?
Select an option to see the answer and solution.
Q946
Open questionIn which join all the rows from the left table appear in the output irrespective of the content of the other table?
Select an option to see the answer and solution.
Q947
Open questionThe query 'SELECT NOW()' shows the current . . . . . . . .
Select an option to see the answer and solution.
Q948
Open questionWhich program converts binary log files to statements in text form?
Select an option to see the answer and solution.
Q949
Open questionWhich statement is used to select a default database?
Select an option to see the answer and solution.
Q950
Open questionmany of these languages have interfaces to bind to the C API of MySQL?
Perl, PHP, PythonSelect an option to see the answer and solution.
Q951
Open questionWhat is the size of the BIT type?
Select an option to see the answer and solution.
Q952
Open questionWithout LOCAL, LOAD DATA is . . . . . . . .
Select an option to see the answer and solution.
Q953
Open questionThe variable used to set table alias names as non case sensitive is . . . . . . . .
Select an option to see the answer and solution.
Q954
Open questionMySQL Enterprise Backup records details of each backup in . . . . . . . .
Select an option to see the answer and solution.
Q955
Open questionWhich data type is best suited to store currency values?
Select an option to see the answer and solution.
Q956
Open questionThe maximum size in bytes of a row in MySQL is . . . . . . . .
Select an option to see the answer and solution.
Q957
Open questionForeign keys cannot handle deletes and updates.
Select an option to see the answer and solution.
Q958
Open questionWhich of the following commands sets the SQL mode as TRADITIONAL?
Select an option to see the answer and solution.
Q959
Open questionIs there any error in the following MySQL statement?
SELECT e.emp_id, e.fname,e.lname,d.name
FROM employee AS e INNER JOIN department AS d
ON e.dept_id=e.dept_id;Select an option to see the answer and solution.
Q960
Open questionWhat will be the output of the following MySQL command?
SELECT *
FROM employee
WHERE (title=’HEAD TELLER’) AND (start_date>2013-01-24);Select an option to see the answer and solution.