A Guide to SQL - Microsoft Access Containing Questions and Answers

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 ___. select specific data - Correct Answer>To query a view, merge query that created view with query to ___.