On the execution of _________ statement, every modification done by the related transaction until now is made constant
On the execution of _________ statement, every modification done by the related transaction until now is made constant
________ command deletes the database schema if it does not contain any element or else the command will be terminated.
________ command deletes the database schema if it does not contain any element or else the command will be terminated.
SQL offers the concurrency control for the execution of a transaction via a Data Control Language which can also be called as __________.
SQL offers the concurrency control for the execution of a transaction via a Data Control Language which can also be called as __________.
______ command deletes the complete database schema which contains tables, domains and other elements
______ command deletes the complete database schema which contains tables, domains and other elements
The ________ property provides assurance that all transactions are executed independently.
The ________ property provides assurance that all transactions are executed independently.
_______command is used To select data in rows and columns from one or more tables
_______command is used To select data in rows and columns from one or more tables
.__________ condition arises when a transaction reads data written by a concurrent uncommitted transaction
.__________ condition arises when a transaction reads data written by a concurrent uncommitted transaction
On the execution of ________ statement, every change performed since the preceding COMMIT statement is rejected.
On the execution of ________ statement, every change performed since the preceding COMMIT statement is rejected.
In _________ isolation the transactions are forced to execute sequentially
In _________ isolation the transactions are forced to execute sequentially
The _________ property requires that the database integrity rules must be obeyed properly.
The _________ property requires that the database integrity rules must be obeyed properly.
When a transaction is completed successfully, _______ property makes sure that the changes performed in the database are saved in the physical database
When a transaction is completed successfully, _______ property makes sure that the changes performed in the database are saved in the physical database
.________ condition arises when a transaction executes a query again it had previously executed and gets rows different f rom what it got earlier
.________ condition arises when a transaction executes a query again it had previously executed and gets rows different f rom what it got earlier
________ command adds attributes to an existing relation
________ command adds attributes to an existing relation
_______ condition is caused by a transaction which reads data again and finds that data has been modified by committed write operation of some other transaction.
_______ condition is caused by a transaction which reads data again and finds that data has been modified by committed write operation of some other transaction.
_________ SQL permits to create and submit SQL queries dynamically or run time.
_________ SQL permits to create and submit SQL queries dynamically or run time.