Q741
Open questionWhich function returns reference to hash of row values?
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
38/60
Page
Pick an option on a question to see the right answer and solution.
Q742
Open questionWhat is the significance of the statement "GROUP BY d.name" in the following MySQL statement?
SELECT d.name, COUNT (emp_id) emp_no
FROM department d INNER JOIN Employee e
ON d.dept_id=e.emp_id
GROUP BY d.nameSelect an option to see the answer and solution.
Q743
Open questionWhich property determines whether a database object is a case sensitive?
Select an option to see the answer and solution.
Q744
Open questionWhich data directory subdirectory provides the information used to inspect the internal execution of the server at runtime.
Select an option to see the answer and solution.
Q745
Open questionIn MySQL, identifier names can start with a digit.
Select an option to see the answer and solution.
Q746
Open questionWhich of the following statements is/are correct?
Select an option to see the answer and solution.
Q747
Open questionWhich of these is the most general purpose language?
Select an option to see the answer and solution.
Q748
Open questionWhat is x'ffff' in decimal?
Select an option to see the answer and solution.
Q749
Open questionmysql_next_result() does not return.
Select an option to see the answer and solution.
Q750
Open questionReading from a table does not change it.
Select an option to see the answer and solution.
Q751
Open questionWhat is the meaning of "Equality Conditions"?
Select an option to see the answer and solution.
Q752
Open questionAny client in the client/server architecture of MySQL can change how the server behaves in relation to itself without impact on other clients.
Select an option to see the answer and solution.
Q753
Open questionFind the odd one out in terms of scheduling policies.
Select an option to see the answer and solution.
Q754
Open questionWhich statement is used to remove a trigger?
Select an option to see the answer and solution.
Q755
Open questionWhich library file contains various portability macros and definitions?
Select an option to see the answer and solution.
Q756
Open questionWhich clause is used to "Filters out unwanted data"?
Select an option to see the answer and solution.
Q757
Open questionReplication does not enable data from one MySQL database server to be copied to one or more MySQL database servers.
Select an option to see the answer and solution.
Q758
Open questionThe statement used to obtain access privileges to an account is . . . . . . . .
Select an option to see the answer and solution.
Q759
Open questionThe name of the format file for a table named my_tbl is . . . . . . . .
Select an option to see the answer and solution.
Q760
Open questionCompiled programs execute faster than interpreted scripts.
Select an option to see the answer and solution.