Which two statements complete a transaction? (Choose two) A. DELETE employees; B. DESCRIBE employees; C. ROLLBACK TO SAVEPOINT C; D. GRANT SELECT ON employees TO SCOTT; E. ALTER TABLE employees SET UNUSED COLUMN sal; F. Select MAX(sal) FROM employees WHERE department_id = 20;
According to my knowledge, DDL & DCL stmts have implicit commit & so end the transaction. Also, issuing of ROLLBACK & COMMIT ends a transaction hence answers should be C(ROLLBACK), D(DCL) & E(DDL) & E. Pls confirm.
RE: Which two statements complete a transaction? (Choo...
ROLLBACK TO SAVEPOINT (C) is not be a valid answer since it does not complete the transaction entirely. Take this eg
DELETE employees where name like 'H ';
SAVEPOINT C;
DELETE employees where name like 'R ';
ROLLBACK TO SAVEPOINT C;
In this case the transaction is not completely ended. Still the DELETE employees where name like 'H '; is present in buffer and so transaction incomplete.
b) describe the employees means the transaction can be completed because we can view all the details of the employees.c)finnally we can save the employee details.
RE: Which two statements complete a transaction? (Choo...
If we want to compleate a transaction we have to comiit In the above state ments there is no such state ment which really update any rows in the table.so with out updatewe cannot commit.is it correct
RE: Which two statements complete a transaction? (Choose two)A. DELETE employees;B. DESCRIBE employees;C. ROLLBACK TO SAVEPOINT C;D. GRANT SELECT ON employees TO SCOTT;E. ALTER TABLE employees SET UNUSED COLUMN sal;F. Select MAX(sal) FROM employees
Hello
D and E are the two stmsts which completes a transaction
C is not done properly ---- simple rollback would have done a transaction but it is a rollback to a some point in a transaction.
RE: Which two statements complete a transaction? (Choose two)A. DELETE employees;B. DESCRIBE employees;C. ROLLBACK TO SAVEPOINT C;D. GRANT SELECT ON employees TO SCOTT;E. ALTER TABLE employees SET UNUSED COLUMN sal;F. Select MAX(sal) FROM employees
Hi this is venkat. answer is :-c d because here DDL DCL commands are used. after any transactions when we perform DDL DCL commands that transaction implictly it becomes auto commit so these are answers just i think that please confirm once again..........
RE: Which two statements complete a transaction? (Choose two)A. DELETE employees;B. DESCRIBE employees;C. ROLLBACK TO SAVEPOINT C;D. GRANT SELECT ON employees TO SCOTT;E. ALTER TABLE employees SET UNUSED COLUMN sal;F. Select MAX(sal) FROM employees
RE: Which two statements complete a transaction? (Choose two)A. DELETE employees;B. DESCRIBE employees;C. ROLLBACK TO SAVEPOINT C;D. GRANT SELECT ON employees TO SCOTT;E. ALTER TABLE employees SET UNUSED COLUMN sal;F. Select MAX(sal) FROM employees
