Timedora
Free Online Flashcard Deck

Database Administration and Recovery Free Online Flashcards

Study Database Administration and Recovery with 12 free online flashcards. Review key terms, definitions, and concepts with this interactive flashcard deck.

12 cards
01
Front

What should routine database health monitoring cover?

Back

Monitor service health, connections, storage growth, and resource use; investigate unusual errors or performance changes.

02
Front

How can administrators investigate database query performance?

Back

Review slow queries and their execution plans to identify performance issues.

03
Front

What should guide decisions to add, change, or remove indexes?

Back

Add, change, or remove indexes based on measured workloads.

04
Front

What are key benefits and costs of database indexes?

Back

Indexes can accelerate reads and enforce uniqueness, but they also add storage and write overhead.

05
Front

What can updates and deletes leave behind in some database systems?

Back

In some database systems, updates and deletes can leave obsolete row versions.

06
Front

How do query planners use database statistics?

Back

Query planners use statistics to choose execution plans.

07
Front

What does PostgreSQL VACUUM do?

Back

In PostgreSQL, VACUUM reclaims or reuses space.

08
Front

What does PostgreSQL ANALYZE do?

Back

In PostgreSQL, ANALYZE refreshes planner statistics.

09
Front

What can PostgreSQL autovacuum automate?

Back

PostgreSQL autovacuum can automate much of the routine work associated with VACUUM and ANALYZE.

10
Front

What should administrators verify about database backups?

Back

Confirm scheduled backup jobs succeed, storage is available, copies are protected, and restore tests remain current.

11
Front

Why should database backups be tested by restoring them?

Back

Regular restore tests help verify that backups can support recovery.

12
Front

What should guide database backup design and testing?

Back

Design backups around acceptable data loss and downtime, then regularly test them by restoring.