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 clause WITH GRANT OPTION is meaningful as part of a REVOKE command.
(True/False)
4.9/5
(46)
A view is defined by creating a defining ____________________, which indicates the rows and columns to include in the view.
(Short Answer)
4.7/5
(30)
When you specify a foreign key, the table containing the foreign key is the parent.
(True/False)
4.9/5
(38)
The existing, permanent tables in a relational database are called stable tables.
(True/False)
4.8/5
(35)
When the primary key contains more than one column, use commas to separate the column names.
(True/False)
4.9/5
(37)
If the database structure changes, the user cannot access and use the view.
(True/False)
4.8/5
(43)
To ensure the uniqueness of values in a non-primary key column, you can create a unique index by using the ____________________ command.
(Short Answer)
4.8/5
(33)
An integrity ____________________ is a rule for the data in the database.
(Short Answer)
4.9/5
(37)
A view is updatable when it is derived from joining two base tables on the ____ of each table.
(Multiple Choice)
4.9/5
(36)
The correct command to allow user Thompson to delete rows in the CUSTOMER table would be: GRANT ____ ON CUSTOMER TO THOMPSON.
(Multiple Choice)
4.8/5
(42)
To ensure the uniqueness of values in a nonprimary key column, use the ____ command to create an index.
(Multiple Choice)
4.9/5
(34)
The privilege ____ can be granted to change the table structure.
(Multiple Choice)
4.8/5
(30)
Showing 41 - 60 of 75
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)