Computer Science - Database Systems - Discussion

9. 

In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction?

[A]. ZIP
[B]. PACK
[C]. COMMIT
[D]. SAVE
[E]. None of the above

Answer: Option C

Explanation:

No answer description available for this question.

Hussain said: (May 21, 2012)  
Explan this question please.

Ankit Vyas said: (Aug 5, 2012)  
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.

Asha said: (Nov 25, 2012)  
Thanks Ankit for explaining the answer. Can you tell me why ZIP and PACK command are used?

Ravi said: (Nov 18, 2013)  
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.

Manoj Kumar said: (May 4, 2017)  
Zonal improvement plan (zip) is used to compress the data and pack is used to clear the space after item deleted from the database.

Post your comments here:

Name *:

Email   : (optional)

» Your comments will be displayed only after manual approval.