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
- In order to optimize queries
- In order 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
-
4.5 ★ | 2 Vote
You should read it
May be interested
- Test your understanding about hackinghacker is a job that brings a lot of income and is loved by many people. to become a true hacker you need to cultivate a lot of useful knowledge. the network administrator's quiz below will help you gain the knowledge to start your career as a hacker.
- What do you know about P19 software technologyplease read the test questions on software technology that network administrator has compiled and edited below. hope with these questions will give you more useful knowledge.
- What do you know about P20 software technologyplease read the test questions on software technology that network administrator has compiled and edited below. hope with these questions will give you more useful knowledge.
- Multiple choice questions on the Internet P5following the series of articles on the internet topic, in the quiz below, the network administrator will send you interesting questions collected from reliable sources for you to supplement your knowledge.
- What do you know about software technology P21please read the test questions on software technology that network administrator has compiled and edited below. hope with these questions will give you more useful knowledge.
- Test on JAVA test P7a set of multiple-choice questions about java gives you useful knowledge for work and study. the set of questions below includes 10 sentences for you to experience.