FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 7: Database Administration

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Multiple Choice

Review LaterAdd Note

Review Later

The system catalog is also called the ____.​

A) system database
B) ​data dictionary
C) master data table
D) ​transaction database

Correct Answer

verified

Show Answer

Question 42

True/False

Review LaterAdd Note

Review Later

You can create and maintain an index for any row in any table.​

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

The types of constraints supported in SQL are ____.​

The GRANT command to indicate that all users can retrieve data using a SELECT command includes the word ____________________ rather than the specific name of a user.​

Explain what happens when you create a query that involves a view.​

In Oracle,the ____ table contains information about the columns within tables.​

Views furnish a certain amount of security;if users are accessing the database through a view,they cannot access any data that is not included in the view.​

The clause WITH GRANT OPTION is meaningful as part of a REVOKE command.​

With a view,the display of data can be customized to meet each user's needs.​

The general form for assigning a foreign key is ADD FOREIGN KEY,the column name(s) of the foreign key,the ____ clause,and then the table name that the foreign key must match.​

A(n)____________________ is an application program's or an individual user's picture of the database.​

In general,views that involve joins of ____________________ tables can cause problems at update.​

When a view is no longer needed,you can remove it using the ____________________ command.​

A view can join two or more tables.​

When you create a query that involves a view,the DBMS changes the query to one that selects data from the table(s)in the database that created the view.​