Q. What does the COMMIT Statement do?

  • (A) The data specified in this table or view is reported in this SQL statement.
  • (B) Changes made in the SQL database transaction are permanently saved using this SQL statement.
  • (C) Specify the columns of the table in this SQL statement to return distinct values.
  • (D) By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.
💬 Discuss
✅ Correct Answer: (B) Changes made in the SQL database transaction are permanently saved using this SQL statement.
Explanation: Changes made in the SQL database transaction are permanently saved using COMMIT SQL statement.

Published by Tina Singh ⭐ 14.41K Points at 13-Feb-2023 07:44 am in MySQL

Explanation by: Tina Singh
Changes made in the SQL database transaction are permanently saved using COMMIT SQL statement.

💬 Discussion

📊 Question Analytics

👁️
365
Total Visits
📽️
4 y ago
Published
🎖️
Tina Singh
Publisher
📈
89%
Success Rate