SQL Chapter 6 & 7
➢ transaction
A logical unit of work
➢ integrity constraint
A rule for the data in the database
➢ row-and-column subset view
A view that consists of a subset of the rows and columns in some base table
➢ data dictionary
System catalog or catalog
➢ SHOW COLUMNS
The SQL command to list all the columns in a given table
➢ database administrator
The person or group charged with managing the database
➢ security
The prevention of unauthorized access to a database
➢ database administration
The process of managing a database
➢ defining query
A query which indicates the rows and columns to include in a view
➢ system catalog
An object that stores information about the tables in the database
➢ ROLLBACK
The SQL command used to reverse update changes to a table
➢ REVOKE
The SQL command used to revoke the access privileges of users to data in the database
➢ COMMIT
The SQL command used to save update changes to a table
➢ ADD clause
The clause of the ALTER TABLE command used to add a column to a table
➢ DELETE
The command to delete data from a database
➢ roll back
reverse update changes to a table
➢ catalog
An object that stores information about the tables in the database
➢ foreign key
A column in one table whose values match the primary key of another table
➢ index
A file that relates key values to records that contain those key values; the main mechanism for increasing the efficiency with which data is retrieved from the database
➢ view
An application program's or an individual user's picture of the database
➢ unique index
An index that ensures the uniqueness of values in a non-primary key column
➢ SHOW TABLES
The SQL command to list all the tables in the database
➢ SHOW INDEX
The SQL command to list the indexes associated with a table
➢ SHOW GRANTS
The SQL command to list the privileges granted to a user
➢ UPDATE
The SQL command used to change existing data in a table
➢ CREATE INDEX
The SQL command used to create an index
➢ CREATE VIEW
The SQL command used to define a view
➢ DROP VIEW
The SQL command used to delete a view
➢ DROP INDEX
The SQL command used to delete an index
➢ CREATE UNIQUE INDEX
The SQL command used to ensure that only unique values are allowed in a non-primary key column
➢ GRANT
The SQL command used to give users access privileges to data in the database
➢ MODIFY clause
The clause of the ALTER TABLE command used to change the characteristics of a column
➢ WITH GRANT OPTION
The clause of the GRANT command which grants the indicated privilege to the user and also permits the user to grant the same privileges (or a subset of them) to other users
➢ ALTER TABLE
The command used to change a table's structure
➢ base table
The existing permanent tables in a relational database
➢ integrity support
The process of specifying integrity constraints for a database that the DBMS will enforce
➢ child
The table containing the foreign key
➢ parent
The table referenced by a foreign key
➢ commit
save update changes to a table
