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

May be interested

  • Test of database security P10Test of database security P10
    database is a data collection organized in a structured way related to each other and stored in a computer. the database is designed and built to allow users to store data, retrieve information or update data. here, please read more about this topic through our quiz below.
  • Test of database security P9Test of database security P9
    please read your knowledge and multiple choice questions about the database that the network administrator has edited below. certainly with this useful knowledge will help you work more effectively.
  • [QUIZ] Test your understanding of SQL - Part 5[QUIZ] Test your understanding of SQL - Part 5
    multiple-choice questions on sql help you familiarize and review useful knowledge for work and learning sql language.
  • Test on database security P7Test on database security P7
    please read your knowledge of the database through the multiple choice questions below. hope with these interesting questions will give you lots of useful information.
  • Test about database security P13Test about database security P13
    please read your knowledge of the database through the multiple choice questions below. hope with these interesting questions will give you lots of useful information.
  • A serious vulnerability on phpMyAdmin allows an attacker to destroy the databaseA serious vulnerability on phpMyAdmin allows an attacker to destroy the database
    a serious security vulnerability on phpmyadmin - one of the most popular mysql database management software will harm the database when the tricked administrator clicks on the link.
  • Database security (common usage guidelines)Database security (common usage guidelines)
    recently, the database security issue has spread widely on the mass media and internet news network. the first is the slammer worm and most recently the illegal access to more than 8 million credit card numbers. many people put
  • [QUIZ] Test your understanding of SQL - Part 7[QUIZ] Test your understanding of SQL - Part 7
    part 7 of the sql quiz goes into the sql practice exercises that follow the previous period.
  • Test about database security P5Test about database security P5
    in the quiz below, join the network administrator to find out more about this topic through extremely interesting multiple choice questions.
  • Test on database security P4Test on database security P4
    today network administrator will give you reading multiple choice questions around the topic of databases, with certain questions below you will have more useful knowledge.

Quiz technology