N

Neelam Mittal • 4.57K Points
Extraordinary 

Q. Which statement issues a lock on tables?

  • (A) ISSUE LOCK
  • (B) LOCK ISSUE
  • (C) LOCK TABLES
  • (D) ISSUE LOCKS
  • Correct Answer - Option(C)
  • Views: 20
  • Filed under category MySQL
Explanation by: Neelam Mittal 
This question is about how you control access to data in a MySQL database. Think of it like a library - you need to check out a book before you can read it. In MySQL, you need to "lock" a table before you can make changes to it.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.

Related MCQs on MySQL

Q. Which status indicator assesses how effective the table cache is?

Q. What 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.name

Q. The operators that are used when a subquery returns multiple rows to be evaluated in comparison to the outer query are . . . . . . . .

Q. What does 'abc' || 'xyz' result in if the PIPES_AS_CONCAT is disabled?

Q. Which of these is the metadata log?

Q. Which of the following is SQL Server Date and Time Data Type?

Q. What does UTF stand for int utf8?

Q. What will be the output of the following MySQL statement "false AND Null"?

Q. What is the TLS protocol?

Q. Which character set variable indicates the character set used for storing identifiers?

Learn All MySQL MCQs

Question analytics