Term
|
Definition
| Existing, permanent tables in a relational database |
|
|
Term
|
Definition
An individual user's picture of the database
A window
Looks like a table but it is not a table
Different users can view same data differently |
|
|
Term
|
Definition
| Main mechanism for providing access to database |
|
|
Term
|
Definition
| Remove privileges from users |
|
|
Term
|
Definition
Speeds up the searching of tables
Looks like a table and it is a table
Used if you have a very large table and need to see 2 to 4% of the data
First column is the primary key column
Second column is the physical location of that record |
|
|
Term
|
Definition
Occupies Disk Space
DBMS must update index as data is entered |
|
|
Term
|
Definition
Data Dictionary
Contains information about tables in database |
|
|
Term
|
Definition
SHOW TABLES
SHOW COLUMNS
SHOW INDEX
SHOW GRANTS |
|
|
Term
|
Definition
|
|
