HomeTech infoQuiz technology

Test about database security P11

  1. Question 1. Value of the components of the specified key:
    1. Can get null values
    2. Cannot get null values ​​or unknown values
    3. Can get null values ​​or unknown values
    4. Cannot get null value but can get unknown values
  2. Question 2. Key attributes are:
    1. Properties are not contained in the key
    2. Key properties
    3. Non-locked attributes
    4. Elements of the key
  3. Question 3. The goal of the database is:
    1. Integrity of data
    2. Reflect honestly the real world data
    3. The independence of the data
    4. Data dependency
  4. Question 4. The separation process does not cause loss of information in the sense of:
    1. The original relationship is restored from projection relations by natural connection magic
    2. The original relationship is restored correctly from projection relationships
    3. The original relationship is restored from projection relationships by connection magic
    4. The original relationship is restored from the relations projected by projection and selected
  5. Question 5. φ [Ω1, Ω2 ., Ωp] is the separation - the natural connection of the relational schema if:
    1. Naturally connecting projection relationships
    2. φ [Ω1, Ω2, ., Ωp] is a separation and connection of projection relationships
    3. φ [Ω1, Ω2, ., Ωp] is a separation and natural connection of projection relations
    4. Connection of projection relations
  6. Question 6. φ [Ω1, Ω2, ., Ωp] is a separation without loss of information, if:
    1. The result of natural connection of projection relationships containing the original relationship.
    2. The result of the natural connection of the main relationships is the original relationship.
    3. The result of natural connection of projection relationships is contained in the original relationship.
    4. The result of connecting relationships is shown on some properties of the original relationship.
  7. Question 7. The objective of separating the relational schema is:
    1. To make storage easy
    2. In order to optimize queries
    3. In order to eliminate information anomalies when performing storage operations
    4. To perform searches
  8. Question 8. It is necessary to standardize data because:
    1. Key value receives null value or unknown value
    2. When performing storage operations on non-standardized relations, information anomalies often appear
    3. When performing separation - connect the relationships automatically
    4. When performing searches, there are information anomalies
  9. Question 9. Information anomaly is the cause:
    1. Obstructing updating and supplementing information
    2. Obstructing the separation of information loss
    3. Obstructing the search and inquiry
    4. Obstructing the implementation of archives
  10. Question 10. The objective of data normalization is:
    1. Ensure data consistency
    2. Highest level of possibility of occurrence of information anomalies
    3. Ensure data security
    4. Guaranteed for data storage
4.5 ★ | 2 Vote
quizzesdatabasestechnology testsinformationcomputer networkscomputer databasessoftwaredatabase management systems

You should read it

Quiz technology