Which of the following command makes the updates performed by the transaction permanent in the database?

Related MCQs

• If several concurrent transactions are executed over the same data set and the second transaction updates the database before the first transaction is finished, the ____ property is violated and the database is no longer consistent.
• Which TCL command undo all the updates performed by the SQL in the transaction?
• If an transaction is performed in a database and committed, the changes are taken to the previous state of transaction by
• Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time.
• Database __________ , which is the logical design of the database, and the database _______,which is a snapshot of the data in the database at a given instant in time.
•                        refers to the ability of the system to recover committed transaction updates if either the system or the storage media fails.
• A lock that prevents the use of any tables in the database from one transaction while another transaction is being processed is called a
• If the complete execution of the transaction(s) takes the database from one consistent state to the other then that property of transaction is called:
• The command                                  such tables are available only within the transaction executing the query and are dropped when the transaction finishes.
• In the                        scheme, a transaction that wants to update the database first creates a complete copy of the database.