Font size
WorksheetsPrelim Advance Information Management
Total questions: 35
Worksheet time: 35mins
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)
Identify whether each command is DDL, DML, DCL, or TCL:
Permanently removes a table and all its data
(a)
Identify whether each command is DDL, DML, DCL, or TCL:
Modifies existing data in a table
(a)
Identify whether each command is DDL, DML, DCL, or TCL:
Sets a point within a transaction to which you can later roll back
(a)
Identify whether each command is DDL, DML, DCL, or TCL:
Displays information about how MySQL executes a statement
(a)
Identify whether each command is DDL, DML, DCL, or TCL:
Creates a savepoint within the current transaction
(a)
Identify whether each command is DDL, DML, DCL, or TCL:
Changes the name of a table
(a)
Identify whether each command is DDL, DML, DCL, or TCL:
Establishes the characteristics of the current transaction
(a)
Identify whether each command is DDL, DML, DCL, or TCL:
Removes an entire database with all its tables
(a)
Identify whether each command is DDL, DML, DCL, or TCL:
Locks tables for the current transaction
(a)
Identify whether each command is DDL, DML, DCL, or TCL:
Executes a stored procedure
(a)
Identify the SQL command being described:
Undoes changes made in the current transaction
(a)
Identify the SQL command being described:
Adds new rows to a table
(a)
Identify the SQL command being described:
Creates a new database object (table, view, index, etc.)
(a)
Identify the SQL command being described:
Permanently saves all changes made during the current transaction
(a)
Identify the SQL command being described:
Gives privileges to database users
(a)
Identify the SQL command being described:
Retrieves data from one or more tables
(a)
Identify the SQL command being described:
Changes the structure of an existing database object
(a)
Identify the SQL command being described:
Removes rows from a table based on a condition
(a)
Identify the SQL command being described:
Removes all records from a table but keeps the table structure
(a)
Identify the SQL command being described:
Removes privileges from database users
(a)
Identify the SQL command being described:
Permanently removes a table and all its data
(a)
Identify the SQL command being described:
Modifies existing data in a table
(a)
Identify the SQL command being described:
Sets a point within a transaction to which you can later roll back
(a)
Identify the SQL command being described:
Changes the name of a table
(a)
Identify the SQL command being described:
Removes an entire database with all its tables
(a)
