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?
Discussion:
6 comments Page 1 of 1.
David said:
3 years ago
COMMIT in SQL.
It's a transaction control language that is used for permanent changes in the transaction in tables/databases.
It's a transaction control language that is used for permanent changes in the transaction in tables/databases.
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.
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.
Asha said:
1 decade ago
Thanks Ankit for explaining the answer. Can you tell me why ZIP and PACK command are used?
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.
Hussain said:
1 decade ago
Explan this question please.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers