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
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)
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)
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
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)