Lesson 11: SQL Views

Question 1

View

Answer 1

A virtual table consisting of rows and columns. A view does not store the data and will display selected data from the underlying base table(s).

Question 2

Virtual Table

Answer 2

A table with columns and rows that does not store data.

Question 3

Base Table

Answer 3

The underlying table that stores the data in a database.

Question 4

Temporary (Temp) Table

Answer 4

A table that is available only temporarily for a certain time. It then goes away as if it never existed.

Question 5

Database Security

Answer 5

The measures taken to protect and secure a database and the data from unauthorized users.

Question 6

Database Access

Answer 6

The users that are authorized will be given permission to have access to certain parts of the database. Each user may have a different access depending on their data needs and responsibility in the organization.

Question 7

CREATE VIEW

Answer 7

The SQL statement used to create a view.

Question 8

CREATE OR ALTER VIEW

Answer 8

The SQL statement used to update a view.

Question 9

DROP VIEW

Answer 9

The SQL statement used to delete a view