Test about database security P11

Testing of databases will help you gain more useful knowledge about this topic to apply to learning and working. The question set will have 10 sentences to test your knowledge.

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

« PREV POST