True

False

False

True

ORDER BY and UNION

GROUP BY and UNION

SORT BY

change the table structure.

delete rows from the table.

change the table data.

add rows to the table.

False

True

A transaction consists of executing COMMIT or ROLLBACK in a database session

A transaction consists of either a collection of DML statements or a DDL or DCL or TCL statement to form a logical unit of work in a database session

A transaction consists of DDL statements executed on the database schema

A transaction consists of collection of DML and DDL statements in different sessions of the database

DELETE can remove data from multiple tables at a time

It is not mandatory or required to write a WHERE clause in a DELETE statement

A DELETE statement must include the WHERE clause

True

False

False

True

True

False

It states that all parts of a transaction should complete or none of them

It states that an incomplete transaction should be invisible to all the other users

It states that the results of a query must be consistent with the state of the DB at the time the query started

It states that once a transaction completes, it must be impossible for the DB to lose it