WorksheetsDBMS-4
Total questions: 8
Worksheet time: 4mins
........... is a group a set of tasks into a single execution unit.
DATA
DATABASE
TRANSACTION
If any of the tasks fail, the transaction ........
SUCCESS
FAILS
............... can be used to give privileges to user.
REVOKE
SELECT
GRANT
•REVOKE SELECT ON employee FROM user1;
EMPLOYEE : TABLE NAME ,USER1: :ROLE NAME
EMPLOYEE: KEYWORD,USER1 :ROLE NAME
• DCL includes commands such as ......... and ........ which mainly deal with the rights, permissions and other controls of the database system.
SELECT,REVOKE
GRANT,REVOKE
UPDATE ,REVOKE
ACID IS....
ATOMIC,CONSISTENCY,ISOLATION,DURABLE
ATOMIC,CHANGE,ISOLATION,DURABLE
if any of the statements constituting a transaction fails to complete ,the entire transaction fails and the database is left unchanged. THIS STATEMENT IS EXAMPLE OF WHICH PROPERTY?
ISOLATION
DURABILITY
ATOMIC
Any read or write will be not impacted by other read and write of other/separate transaction. ABOVE STATEMENT IS CHARACTERISTICS OF .............
ISOLATION
CONSISTENCY
