Test on Database Security P6

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

Understanding Test on Database Security P6

• Question 1. Types of data included
  • File of data files
  • Audio, voice, writing, text, graphics, still images or animations. in binary form.
  • Audio, voice, writing, text, graphics, still images, animations.
  • Audio, voice, writing, text, graphics, still images or animations. stored in memory in File formats.
• Question 2. Data inconsistency in storage.
  • Cannot modify, supplement, update data
  • Can search implementations
  • Making data lose its integrity
  • There are no conflicting information
• Question 3. External model is
  • Information content of the entire database.
  • Information content of a database part
  • Information content of the entire database under the view of the user.
  • The information content of a piece of data is viewed by the user.
• Question 4. The objective of the database is:
  • Do not change the data storage structure
  • Do not change the database access strategy.
  • Ensure data independence
  • Data is only represented, described in a unique way.
• Question 5. Data binding:
  • Rules for representing data structures
  • Definitions, axioms, theorems
  • Relationship between data entities
  • Rules and regulations
• Question 6. Analytical binding:
  • The relationship between attributes is represented by mathematical expressions.
  • Relational algebra operations
  • Describe the properties of attributes when creating databases.
  • Rules for representing data structures
• Question 7. Logical constraints:
  • The relationship between attributes is represented by functional dependencies.
  • Relational operations
  • Comparisons
  • The relationship between attributes is represented by mathematical expressions.
• Question 8. Client-Sserver database model:
  • The client executes the application, it sends a request to the server connected to the database, the server processes and returns the results to the client.
  • Clients share the processing burden of the central server.
  • Servers and machines participate in the process.
  • The client requires the server to provide these types of services.
• Question 9. In the network database, when deleting the records:
  • Loss of information
  • Ensure consistency and integrity of data
  • Information conflicts will appear
  • No data integrity
• Question 10. When performing storage operations on relations:
  • Information anomaly, does not guarantee data integrity.
  • No information anomalies, ensuring data integrity.
  • Information anomaly, does not guarantee data integrity.