Lesson 11 Flashcards
1
Q
View
A
A virtual table consisting of rows and columns that does not store the data.
2
Q
Base Table
A
The underlying table, that stores, the data and a database.
3
Q
Temporary (Temp) Table
A
A table that is available only temporarily, for a certain time.
4
Q
Database Security
A
Measures taken to protect and secure a database and the data from unauthorized users.
5
Q
Database Access
A
Users that are authorized will be given permission to have access to certain parts of the database.
6
Q
CREATE VIEW
A
SQL statement used to create a
View.
7
Q
CREATE OR ALTER VIEW
A
SQL statement used to update a view.
8
Q
DROP VIEW
A
SQL statement used to delete a view.
