Database Administration MCQ
Database Administration MCQ
1. Flat, raised, sunken, etched, shadowed, and chiseled are options for the ____ control property.
Answer
Correct Answer:
Special Effect
Note: This Question is unanswered, help us to find answer for this one
2. The ____ establishes the naming conventions for tables, fields, and indexes in the data dictionary.
Note: This Question is unanswered, help us to find answer for this one
3. Unix allows permissions to be assigned to ________.
Answer
Correct Answer:
All of the above
Note: This Question is unanswered, help us to find answer for this one
4. A data administrator is also known as a(n) _____.
Answer
Correct Answer:
Information resource manager
Note: This Question is unanswered, help us to find answer for this one
5. One of the important functions of a dbms is to provide the necessary tools for ________.
Answer
Correct Answer:
Administering the database
Note: This Question is unanswered, help us to find answer for this one
6. Management of classified data includes its storage and _________.
Answer
Correct Answer:
Distribution, portability, and destruction (All of the above)
Note: This Question is unanswered, help us to find answer for this one
7. A ____ is responsible for maintaining a large, multiuser system.
Answer
Correct Answer:
System administrator
Note: This Question is unanswered, help us to find answer for this one
8. _____ are used to control the behavior or interactivity of the field in database objects.
Answer
Correct Answer:
Field properties
Note: This Question is unanswered, help us to find answer for this one
9. A traditional data administrator performs which of the following roles?
Answer
Correct Answer:
Resolve data ownership issues
Note: This Question is unanswered, help us to find answer for this one
10. Performance analysis and tuning is which of the following?
Answer
Correct Answer:
Undertaken as an ongoing part of managing a database
Note: This Question is unanswered, help us to find answer for this one
11. A torn page is where
Answer
Correct Answer:
Part of the page is not written to disk
Note: This Question is unanswered, help us to find answer for this one
12. Which of the following could cause data to be unavailable?
Answer
Correct Answer:
All of these
Note: This Question is unanswered, help us to find answer for this one
13. Failure to control confidentiality may lead to loss of competitiveness.
Note: This Question is unanswered, help us to find answer for this one
14. The ability to do an action on a table is called
Note: This Question is unanswered, help us to find answer for this one
15. Mirrored databases are almost always provided in high-availability systems.
Note: This Question is unanswered, help us to find answer for this one
16. We prevent a user from updating a table by:
Answer
Correct Answer:
Revoking a right
Note: This Question is unanswered, help us to find answer for this one
17. If both data and database administration exist in an organization, the database administrator is responsible for which of the following?
Answer
Correct Answer:
Database design
Note: This Question is unanswered, help us to find answer for this one
18. What does RDBMS stand for?
Answer
Correct Answer:
Relational Database Management System
Note: This Question is unanswered, help us to find answer for this one
19. Poor data administration can lead to which of the following?
Answer
Correct Answer:
Missing data elements
Note: This Question is unanswered, help us to find answer for this one
20. A default object is?
Answer
Correct Answer:
An object assigned to a column which defines a value to be used if nothing is entered
Note: This Question is unanswered, help us to find answer for this one
21. An extent is a block of .... pages
Note: This Question is unanswered, help us to find answer for this one
22. Constraints are
Answer
Correct Answer:
A way of checking that inserted values are within an acceptable range
Note: This Question is unanswered, help us to find answer for this one
23. Which of the following is part of an administrative policy to secure a database?
Answer
Correct Answer:
All of these
Note: This Question is unanswered, help us to find answer for this one
Database MCQs | Topic-wise
