Prelim Advance Information Management

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

Undoes changes made in the current transaction

(a)  

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

Adds new rows to a table

(a)  

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

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

(a)  

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

Permanently saves all changes made during the current transaction

(a)  

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

Gives privileges to database users

(a)  

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

Retrieves data from one or more tables

(a)  

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

Changes the structure of an existing database object

(a)  

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

Removes rows from a table based on a condition

(a)  

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

Removes all records from a table but keeps the table structure

(a)  

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

Removes privileges from database users

(a)