Exam 7: Database Administration

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

A view is a derived table.

(True/False)
4.9/5
(30)

An index makes certain types of retrieval more efficient.

(True/False)
4.7/5
(41)

You can only specify a primary key when you first create a table.

(True/False)
4.9/5
(29)

The GRANT command to indicate that a user has all privileges includes the FULL privilege.

(True/False)
4.9/5
(27)

To add a primary key after creating a table, you can use the ____________________ clause of the ALTER TABLE command.

(Short Answer)
4.9/5
(41)

You can create and use a(n) ____________________ to speed up the searching process significantly.

(Short Answer)
4.8/5
(42)

To add a row to your view, simply add a row to each underlying derived table.

(True/False)
4.8/5
(31)

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

(True/False)
4.8/5
(41)

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

(True/False)
4.8/5
(36)

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

(Multiple Choice)
4.9/5
(29)

____________________ is the prevention of unauthorized access to a database.

(Short Answer)
4.8/5
(28)

You can add rows to a view that includes calculations.

(True/False)
4.7/5
(40)

The privilege ____ can be granted to change data.

(Multiple Choice)
4.9/5
(28)

To create a view definition, use the ____________________ command.

(Short Answer)
4.8/5
(36)

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.

(Short Answer)
4.9/5
(36)
Showing 61 - 75 of 75
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)