What should routine database health monitoring cover?
Monitor service health, connections, storage growth, and resource use; investigate unusual errors or performance changes.
Study Database Administration and Recovery with 12 free online flashcards. Review key terms, definitions, and concepts with this interactive flashcard deck.
What should routine database health monitoring cover?
Monitor service health, connections, storage growth, and resource use; investigate unusual errors or performance changes.
How can administrators investigate database query performance?
Review slow queries and their execution plans to identify performance issues.
What should guide decisions to add, change, or remove indexes?
Add, change, or remove indexes based on measured workloads.
What are key benefits and costs of database indexes?
Indexes can accelerate reads and enforce uniqueness, but they also add storage and write overhead.
What can updates and deletes leave behind in some database systems?
In some database systems, updates and deletes can leave obsolete row versions.
How do query planners use database statistics?
Query planners use statistics to choose execution plans.
What does PostgreSQL VACUUM do?
In PostgreSQL, VACUUM reclaims or reuses space.
What does PostgreSQL ANALYZE do?
In PostgreSQL, ANALYZE refreshes planner statistics.
What can PostgreSQL autovacuum automate?
PostgreSQL autovacuum can automate much of the routine work associated with VACUUM and ANALYZE.
What should administrators verify about database backups?
Confirm scheduled backup jobs succeed, storage is available, copies are protected, and restore tests remain current.
Why should database backups be tested by restoring them?
Regular restore tests help verify that backups can support recovery.
What should guide database backup design and testing?
Design backups around acceptable data loss and downtime, then regularly test them by restoring.
A progressive guide to how computers encode numbers, text, images, and sound as binary data, including the trade-offs and limits of digital representation.
A 14-question medium-difficulty quiz on Boolean algebra, logic gates, truth tables, and combinational circuits.
A focused set of flashcards covering Python variables, data types, expressions, control flow, functions, input, output, and common programming practices.
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.
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.
A progression through how data is organized, searched, exposed through software interfaces, and managed through abstraction layers in modern computer systems.
Reviews how interrupts support event handling and multitasking, and how Linux system calls use the RISC-V `ecall` instruction and register conventions.
This quiz covers process management, context switching and scheduling, multitasking, traps and interrupts, and RISC-V privilege transitions.
A quiz on operating-system system calls, including privileged-operation requests, process creation and execution with fork, exec, and waitpid, and signal handling.