Computer Science - Database Systems - Discussion

Discussion Forum : Database Systems - Section 1 (Q.No. 9)
9.
In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction?
ZIP
PACK
COMMIT
SAVE
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Discussion:
6 comments Page 1 of 1.

Ravi said:   1 decade ago
The COMMIT statement in SQL marks the final step in the processing of a database transaction. The alternative is to utilize the ROLLBACK command to cancel the proposed database changes.

Ankit Vyas said:   1 decade ago
Commit is used for the save the work in the SQL like as save command in ms word or any other software same as commit is worked for the save the data base file to the secondary device.

Manoj kumar said:   8 years ago
Zonal improvement plan (zip) is used to compress the data and pack is used to clear the space after item deleted from the database.

David said:   4 years ago
COMMIT in SQL.

It's a transaction control language that is used for permanent changes in the transaction in tables/databases.

Asha said:   1 decade ago
Thanks Ankit for explaining the answer. Can you tell me why ZIP and PACK command are used?

Hussain said:   1 decade ago
Explan this question please.

Post your comments here:

Your comments will be displayed after verification.