Exam 7: Database Administration
Exam 1: Introduction to Premiere Products, Henry Books, and Alexamara Marina Group75 Questions
Exam 2: Database Design Fundamentals75 Questions
Exam 3: Creating Tables75 Questions
Exam 4: Single-Table Queries75 Questions
Exam 5: Multiple-Table Queries75 Questions
Exam 6: Updating Data75 Questions
Exam 7: Database Administration75 Questions
Exam 8: SQL Functions and Procedures75 Questions
Select questions type
The process of managing a database is called database ____________________.
(Short Answer)
4.7/5
(36)
The database administrator uses the ____ command to revoke privileges from users.
(Multiple Choice)
4.7/5
(35)
A(n) ____________________ subset view consists of a subset of the rows and columns in some base table.
(Short Answer)
4.9/5
(43)
The database administrator uses the ____________________ command to revoke privileges from users.
(Short Answer)
4.8/5
(34)
The DBMS provides integrity administration, the process of specifying integrity constraints for a database that the DBMS will enforce.
(True/False)
4.9/5
(37)
To create a view in Access, create a query to define the view and then save the query object in the database.
(True/False)
4.8/5
(34)
If two base tables have the same primary key and the primary key is used as the join column, updating the database is a problem.
(True/False)
4.9/5
(32)
Information about tables in the database is kept in the system ____________________.
(Short Answer)
4.8/5
(31)
In general, views that involve joins of ____________________ tables can cause problems at update.
(Short Answer)
4.8/5
(35)
If the user needs to be able to pass the privilege to other users, the GRANT command must include the ____________________ clause.
(Short Answer)
4.9/5
(34)
The DROP VIEW command removes the tables and data on which the view is based.
(True/False)
4.8/5
(34)
A(n) ____________________ is an application program's or an individual user's picture of the database.
(Short Answer)
4.9/5
(36)
In Oracle, the ____ table contains information about the columns within tables.
(Multiple Choice)
4.9/5
(36)
Normally, when the database administrator grants a particular privilege to a user, the user cannot pass that privilege along to other users.
(True/False)
4.9/5
(40)
Showing 21 - 40 of 75
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)