Prelim Advance Information Management

Identify whether each command is DDL, DML, DCL, or TCL:

Undoes changes made in the current transaction

Identify whether each command is DDL, DML, DCL, or TCL:

Adds new rows to a table

Identify whether each command is DDL, DML, DCL, or TCL:

Creates a new database object (table, view, index, etc.)

Identify whether each command is DDL, DML, DCL, or TCL:

Permanently saves all changes made during the current transaction

Identify whether each command is DDL, DML, DCL, or TCL:

Gives privileges to database users

Identify whether each command is DDL, DML, DCL, or TCL:

Retrieves data from one or more tables

Identify whether each command is DDL, DML, DCL, or TCL:

Changes the structure of an existing database object

Identify whether each command is DDL, DML, DCL, or TCL:

Removes rows from a table based on a condition

Identify whether each command is DDL, DML, DCL, or TCL:

Removes all records from a table but keeps the table structure

Identify whether each command is DDL, DML, DCL, or TCL:

Removes privileges from database users