Timedora
Free Practice Quiz Question List

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.

20 questions
01
Choose one
1 point

Which routine best supports workload-based database performance and index maintenance?

  1. A

    Add indexes whenever a column might be queried, without checking workload.

  2. B

    Review slow queries and execution plans, then adjust indexes based on measured workloads.

  3. C

    Avoid checking query plans because they cannot inform index choices.

  4. D

    Ignore unusual performance changes unless the database becomes unavailable.

02
Choose all
1 point

Select all practices that help manage database changes safely.

  1. A

    Test schema changes and maintenance operations before production use.

  2. B

    Schedule disruptive work appropriately.

  3. C

    Apply changes directly in production without testing.

  4. D

    Retain a rollback or recovery plan.

03
True or false
1 point

Authentication establishes who or what is connecting, while authorization determines which actions that identity may perform.

  1. A

    True

  2. B

    False

04
Fill in the blank
1 point

A recovery point objective (RPO) states how much recent data an organization can afford to .

05
Open ended
1 point

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.

06
Choose one
1 point

In PostgreSQL, which command refreshes the statistics that the query planner uses to choose execution plans?

  1. A

    Use ANALYZE to reclaim or reuse space.

  2. B

    Use ANALYZE to refresh planner statistics.

  3. C

    Use VACUUM to refresh planner statistics.

  4. D

    Use autovacuum to audit privileged access.

07
Choose all
1 point

Select all practices that support a reliable database backup and recovery strategy.

  1. A

    Set an RPO for acceptable data loss and an RTO for acceptable service downtime.

  2. B

    Keep protected backup copies separate from the production system.

  3. C

    Assume a successful backup job proves that restoration will work.

  4. D

    Test restores, verify recovered data, and check whether recovery meets RPO and RTO targets.

  5. E

    Restrict access to backup files and encrypt them when appropriate.

08
True or false
1 point

Database indexes require no maintenance when rows are inserted, updated, or deleted.

  1. A

    True

  2. B

    False

09
Written response
1 point

What should be done to a schema change before it is used in production?

10
Fill in the blank
1 point

Indexes can speed up reads, but they also consume and must be maintained when rows change.

11
Choose one
1 point

A database administrator plans a schema change that could disrupt service. Which approach best manages the change safely?

  1. A

    Apply the change directly in production, then prepare a rollback plan if problems occur.

  2. B

    Test the change before production use and retain a rollback or recovery plan.

  3. C

    Avoid testing if the change is scheduled during a low-traffic period.

  4. D

    Make the change without a recovery plan if it is expected to be brief.

12
True or false
1 point

If a scheduled database backup job succeeds, the backup is proven usable for recovery, so restore testing is unnecessary.

  1. A

    True

  2. B

    False

13
Written response
1 point

What security principle means granting a person or application only the database access needed for its duties?

14
Choose one
1 point

In PostgreSQL, which command refreshes planner statistics?

  1. A

    VACUUM

  2. B

    autovacuum

  3. C

    ANALYZE

  4. D

    SELECT

15
Written response
1 point

Which PostgreSQL command reclaims or reuses space after database changes?

16
Choose one
1 point

Which access-control function establishes who or what is connecting to a database?

  1. A

    Authentication

  2. B

    Authorization

  3. C

    Least privilege

  4. D

    Role membership

17
Written response
1 point

What is the expanded name of RPO in database backup planning?

18
Choose one
1 point

Which practice best reduces risk when managing a database change?

  1. A

    Make changes in production first and test only if users report a problem.

  2. B

    Skip a recovery plan when the change is expected to be small.

  3. C

    Test changes before production use and retain a rollback or recovery plan.

  4. D

    Avoid scheduling disruptive work because the timing does not affect operations.

19
Choose one
1 point

A database team is considering an index to support a frequent query. Which approach best balances query performance with the costs of maintaining indexes?

  1. A

    Add indexes to every column that might appear in a query, then leave them in place regardless of observed performance.

  2. 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.

  3. C

    Avoid indexes on frequently queried columns because indexes slow reads as well as writes.

  4. D

    Use a composite index whenever a table has multiple columns, even if common queries do not use those columns together.

20
Choose one
1 point

An organization is designing database recovery targets and wants to verify that its backups can meet them. Which plan correctly uses RPO and RTO?

  1. A

    Set an RPO for the maximum acceptable recovery downtime and an RTO for the maximum amount of recent data loss.

  2. B

    Choose backup frequency and retention, but do not test restores if scheduled backup jobs report success.

  3. 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.

  4. D

    Use a logical export as the entire recovery strategy, since it necessarily includes all database and cluster-wide objects.