Skip to content
CampusPrep
CY-802 (A) · Database Security/Important Questions

Database Security (CY-802 (A)) - Important Questions

  1. Unit 114 Marks High Priority

    Explain the Database Security Lifecycle and illustrate each phase with examples of controls and metrics.

    Core high-level question covering the full lifecycle of securing a database; synthesizes architecture, operations and controls from Unit 1.

  2. Unit 114 Marks High Priority

    Describe Bell and LaPadula and Biba models. Compare their goals and explain where each is appropriate in database systems.

    Classic mandatory and integrity security models question; essential for exams testing theoretical foundations and comparison skills.

  3. Unit 110 Marks High Priority

    List and explain common internal and external database threats. For each threat propose at least one mitigation technique.

    Practical threat identification and mitigation task frequently asked to test applied understanding of Unit 1 security concepts.

  4. Unit 114 Marks High Priority

    Explain how access control structures (discretionary, mandatory, role-based) are implemented in a relational DBMS and discuss trade-offs.

    Core implementation question testing knowledge of access control models and trade-offs in relational DBMS — repeated emphasis in Unit 1.

  5. Unit 17 Marks Medium Priority

    Perform a simple data risk assessment: identify asset value, likelihood, impact and compute residual risk after applying an encryption control.

    Applied risk assessment problem to test quantitative reasoning about security controls and residual risk in Unit 1.

  6. Unit 110 Marks High Priority

    Explain the concept of database system architecture. Compare centralized, client-server and distributed database architectures with regard to security implications.

    Database architecture comparison with focus on security implications; maps to 'Database system concepts and architecture' topic.

  7. Unit 17 Marks Medium Priority

    What is the principle of least privilege and how is it enforced in DBMS environments? Give examples of mechanisms and policies.

    Fundamental security principle question often used to assess policy and enforcement understanding in DBMS.

  8. Unit 17 Marks Medium Priority

    Explain the role of authentication, authorization and accounting (AAA) in database security. Provide examples of techniques used for each.

    Core AAA concepts (Authentication, Authorization, Accounting) are foundational to database security and often examined.

  9. Unit 17 Marks Medium Priority

    Describe backup, recovery and journaling mechanisms in DBMS and explain how they contribute to security and integrity.

    Availability and integrity mechanisms question assessing knowledge of recovery and integrity-preserving features of DBMS.

  10. Unit 15 Marks Medium Priority

    Define the role of encryption in protecting data at rest and data in transit in database systems. Explain symmetric vs asymmetric encryption briefly and when each is used.

    Encryption basics question addressing data protection in transit and at rest; appropriate for Unit 1 overview of information security.

  11. Unit 17 Marks Medium Priority

    Explain audit trails and logging in databases: what events should be logged, how logs are protected, and how they are used in incident response.

    Auditing and logging are core operational controls for database security; this question tests what to log and how to use logs in incident response.

  12. Unit 17 Marks Medium Priority Asked: 2024

    Explain the concept of a mode of operation in cryptography. Provide an example of a specific mode used with lightweight block ciphers.

    Question extracted verbatim from a past paper (raw data) that relates to cryptographic concepts referenced in Unit 1 (overview of information security).

  13. Unit 15 Marks Medium Priority Asked: 2024

    What is the key difference between symmetric and asymmetric cryptography?

    Short conceptual question on cryptographic key types; present in raw past paper material relevant to Unit 1 overview topics.

Go to where you left off?

Quick Add to Notes

Save questions, your own notes and screenshots into notes filed by unit. It takes a free account.

Create free account

Have an account? Log in