📊 MySQL
Q. Mysql command line tool is used to show "how many rows are returned and how long SQL command took to execute".
  • (A) True
  • (B) WHERE
  • (C) Undetermined
  • (D) Depend
💬 Discuss
✅ Correct Answer: (C) Undetermined

Explanation: True: The MySQL command-line tool provides functionality to display the number of rows returned by a query and the execution time of SQL commands. By default, after executing a query, the MySQL command-line tool displays the number of rows affected (for INSERT, UPDATE, DELETE statements) or the number of rows returned (for SELECT statements). Additionally, MySQL provides options like SHOW WARNINGS and SHOW STATUS to display various details including execution time.

Explanation by: Sonali Mishra
True: The MySQL command-line tool provides functionality to display the number of rows returned by a query and the execution time of SQL commands. By default, after executing a query, the MySQL command-line tool displays the number of rows affected (for INSERT, UPDATE, DELETE statements) or the number of rows returned (for SELECT statements). Additionally, MySQL provides options like SHOW WARNINGS and SHOW STATUS to display various details including execution time.

💬 Discussion

📊 Question Analytics

👁️
75
Total Visits
📽️
12 mo ago
Published
🎖️
Sonali Mishra
Publisher
📈
86%
Success Rate