Test About Database Security P11

This article presents Test About Database Security P11 in a clear, structured format. It helps readers review key concepts, test their understanding, and learn from the material.

Understanding Test About Database Security P11

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