Which routine best supports workload-based database performance and index maintenance?
Database Administration: Performance, Security, and Recovery Online Quiz Questions
Use this free practice quiz with 20 questions to review Database Administration: Performance, Security, and Recovery, test your knowledge, and prepare for your next test or exam.
Select all practices that help manage database changes safely.
- A
Test schema changes and maintenance operations before production use.
- B
Schedule disruptive work appropriately.
- C
Apply changes directly in production without testing.
- D
Retain a rollback or recovery plan.
Authentication establishes who or what is connecting, while authorization determines which actions that identity may perform.
- A
True
- B
False
A recovery point objective (RPO) states how much recent data an organization can afford to .
Explain the difference between authentication and authorization in database access control. Then describe how least privilege and task-specific roles, reviewed periodically, can reduce unnecessary access.
In PostgreSQL, which command refreshes the statistics that the query planner uses to choose execution plans?
- A
Use ANALYZE to reclaim or reuse space.
- B
Use ANALYZE to refresh planner statistics.
- C
Use VACUUM to refresh planner statistics.
- D
Use autovacuum to audit privileged access.
Select all practices that support a reliable database backup and recovery strategy.
- A
Set an RPO for acceptable data loss and an RTO for acceptable service downtime.
- B
Keep protected backup copies separate from the production system.
- C
Assume a successful backup job proves that restoration will work.
- D
Test restores, verify recovered data, and check whether recovery meets RPO and RTO targets.
- E
Restrict access to backup files and encrypt them when appropriate.
Database indexes require no maintenance when rows are inserted, updated, or deleted.
- A
True
- B
False
What should be done to a schema change before it is used in production?
Indexes can speed up reads, but they also consume and must be maintained when rows change.
A database administrator plans a schema change that could disrupt service. Which approach best manages the change safely?
- A
Apply the change directly in production, then prepare a rollback plan if problems occur.
- B
Test the change before production use and retain a rollback or recovery plan.
- C
Avoid testing if the change is scheduled during a low-traffic period.
- D
Make the change without a recovery plan if it is expected to be brief.
If a scheduled database backup job succeeds, the backup is proven usable for recovery, so restore testing is unnecessary.
- A
True
- B
False
What security principle means granting a person or application only the database access needed for its duties?
In PostgreSQL, which command refreshes planner statistics?
- A
VACUUM
- B
autovacuum
- C
ANALYZE
- D
SELECT
Which PostgreSQL command reclaims or reuses space after database changes?
Which access-control function establishes who or what is connecting to a database?
- A
Authentication
- B
Authorization
- C
Least privilege
- D
Role membership
What is the expanded name of RPO in database backup planning?
Which practice best reduces risk when managing a database change?
- A
Make changes in production first and test only if users report a problem.
- B
Skip a recovery plan when the change is expected to be small.
- C
Test changes before production use and retain a rollback or recovery plan.
- D
Avoid scheduling disruptive work because the timing does not affect operations.
A database team is considering an index to support a frequent query. Which approach best balances query performance with the costs of maintaining indexes?
- A
Add indexes to every column that might appear in a query, then leave them in place regardless of observed performance.
- B
Consider an index for frequent queries or constraints, then assess its benefit using query plans and observed performance while accounting for storage and write costs.
- C
Avoid indexes on frequently queried columns because indexes slow reads as well as writes.
- D
Use a composite index whenever a table has multiple columns, even if common queries do not use those columns together.
An organization is designing database recovery targets and wants to verify that its backups can meet them. Which plan correctly uses RPO and RTO?
- A
Set an RPO for the maximum acceptable recovery downtime and an RTO for the maximum amount of recent data loss.
- B
Choose backup frequency and retention, but do not test restores if scheduled backup jobs report success.
- C
Define RPO in terms of acceptable recent data loss and RTO in terms of acceptable recovery downtime, then test restores and verify recovery against both targets.
- D
Use a logical export as the entire recovery strategy, since it necessarily includes all database and cluster-wide objects.
Related study packs and tools
02 — Information and Representation
A progressive guide to how computers encode numbers, text, images, and sound as binary data, including the trade-offs and limits of digital representation.
2 Digital Logic
A 14-question medium-difficulty quiz on Boolean algebra, logic gates, truth tables, and combinational circuits.
03 — Python Programming Fundamentals
A focused set of flashcards covering Python variables, data types, expressions, control flow, functions, input, output, and common programming practices.
6 Computer Memory
Learn how computer memory stores and addresses information, how RAM and ROM differ, and how caches and the memory hierarchy balance speed, capacity, and cost.
07 Trees and Binary Search Trees
A progressive guide to tree structure, binary-tree traversals, binary search tree operations, deletion, balancing, and the way tree height determines time and space costs.
10 — Data, Systems, and Applications
A progression through how data is organized, searched, exposed through software interfaces, and managed through abstraction layers in modern computer systems.
Interrupts
Reviews how interrupts support event handling and multitasking, and how Linux system calls use the RISC-V `ecall` instruction and register conventions.
OS Processes
This quiz covers process management, context switching and scheduling, multitasking, traps and interrupts, and RISC-V privilege transitions.
Systemcalls
A quiz on operating-system system calls, including privileged-operation requests, process creation and execution with fork, exec, and waitpid, and signal handling.