Test your skills through the online practice test: MySQL Quiz Online Practice Test

Related differences

Ques 26. What Is BDB (BerkeleyDB)?

BDB (BerkeleyDB) is transaction safe storage engine originally developed at U.C. Berkeley. It is now developed by Sleepycat Software, Inc. (an Oracle company now).

Is it helpful? Add Comment View Comments
 

Ques 27. What Is CSV?

CSV (Comma Separated Values) is a file format used to store database table contents, where one table row is stored as one line in the file, and each data field is separated with comma.

Is it helpful? Add Comment View Comments
 

Ques 28. What Is Transaction?

A transaction is a logical unit of work requested by a user to be applied to the database objects. MySQL server introduces the transaction concept to allow users to group one or more SQL statements into a single transaction, so that the effects of all the SQL statements in a transaction can be either all committed (applied to the database) or all rolled back (undone from the database).

Is it helpful? Add Comment View Comments
 

Ques 29. What Is Commit?

Commit is a way to terminate a transaction with all database changes to be saved permanently to the database server.

Is it helpful? Add Comment View Comments
 

Ques 30. What Is Rollback?

Rollback is a way to terminate a transaction with all database changes not saving to the database server.

Is it helpful? Add Comment View Comments
 

Most helpful rated by users: