A Guide to SQL - Microsoft Access Containing
Questions and Answers
Database administrator - Correct Answer>The person or persons charged
with managing the database.
Database administration - Correct Answer>The process of managing a
database.
view - Correct Answer>A Program or individual user's picture of the
database.
Base tables - Correct Answer>Existing, permanent tables in a relational
database.
base table - Correct Answer>A view is derived table because data in it is
retrieved from the ___.
defining query - Correct Answer>A view is defined by creating a ___, which
indicates the rows and columns to include in the view.
Access - Correct Answer>Does not support CREATE VIEW command.
omitting sensitive information - Correct Answer>Views provide a measure of
security by ___.
CREATE VIEW AS - Correct Answer>To create a view, use the ___ command,
followed by the name of the view, the word ___, and then a query.
temporary table - Correct Answer>A view is NOT a ___.
Questions and Answers
Database administrator - Correct Answer>The person or persons charged
with managing the database.
Database administration - Correct Answer>The process of managing a
database.
view - Correct Answer>A Program or individual user's picture of the
database.
Base tables - Correct Answer>Existing, permanent tables in a relational
database.
base table - Correct Answer>A view is derived table because data in it is
retrieved from the ___.
defining query - Correct Answer>A view is defined by creating a ___, which
indicates the rows and columns to include in the view.
Access - Correct Answer>Does not support CREATE VIEW command.
omitting sensitive information - Correct Answer>Views provide a measure of
security by ___.
CREATE VIEW AS - Correct Answer>To create a view, use the ___ command,
followed by the name of the view, the word ___, and then a query.
temporary table - Correct Answer>A view is NOT a ___.
