SQL Chapter 6 & 7

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

➢ 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


Set pelajaran terkait

Chapter 13-14 Test - AP American Gov

View Set

Starting out with Python Chapter 2 checkpoints

View Set

Business Statistics Ch 1 (Week 1)

View Set

6246 Ch.10 Sample readiness questions

View Set

AP Computer Science Principles Programming (Khan Academy)

View Set

Chapter 7: Interest rates and Bond Valuation

View Set

PrepU Chapter 19: Postop Care (Exam 1)

View Set