Database Test - Part 3

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

Understanding Database Test

• Question 1. Choose which of the following statements is most appropriate:

  • Data structures in 1NF relations allow for additional modifications conveniently.

  • The data structure in 1NF relations hides information anomalies.

  • Data structure in 1NF relations makes it difficult to query information.

  • Data structure in simple 1NF relations

• Question 2. The process of optimizing data query questions is the process:

  • The results of operations are represented solely by a relation.

  • It is necessary to change reasonable questions.

  • Transform the question so that the cost of time and memory usage is the least.

  • The cost of performing the operations is minimal.

• Question 3. Select the corresponding word/phrase to complete the following assertion: 'Data independence'. of application systems for changes in storage structure and data access strategy.

  • Access method.

  • Access strategies.

  • Infomations.

  • Immutability

• Question 4. Please select the corresponding word/phrase to complete the following definition: In the tree-shaped structure, when modifying some information in dependent records, you must browse the entire model, by searching in appeared. Leads to the appearance.

  • Data integrity in storage.

  • An data integrity.

  • Information loss.

  • Data inconsistency in storage.

• Question 5. Select the corresponding word/phrase to complete the following definition: Network data model is a relational entity model, in which the linkages are limited. Does not contain many - many links.

  • Symmetry

  • In type one - one and many - one

  • In the type of a linked record type

  • In the type of an entity record

• Question 6. Select the corresponding word/phrase to complete the following definition: Data independence in highly relational database systems, showing storage structure and access strategy can. but do not change the concept diagram and vice versa.

  • Change

  • Independent of each other

  • Constant

  • Interdependence

• Question 7. Please select the corresponding word/phrase to complete the following definition: Value of key components.

  • Receiving multiple values

  • Get the value of 'False'

  • Get the value of monotherapy

  • Get 'True' value

• Question 8. Select the corresponding word/phrase to complete the following assertion: If the SELECT statement contains GROUP BY, the system will. and perform grouping operations.

  • Partitioning relationships into many separate groups.

  • Perform sorting according to the instruction after the ORDER BY clause.

  • Make a selection after the WHERE clause

  • Perform a projection after the SELECT clause.

• Question 9. Please select the corresponding word/phrase to complete the following statement: Data integrity means.

  • Can implement data access strategies

  • Data in the database is always accurate at all times.

  • Searchable at all times

  • Ensure data independence at all times

• Question 10. Select the corresponding word/phrase to complete the following assertion: The most common way to identify users is the password.

  • Ensure data integrity

  • Only system and user know

  • Only allowed to access the database

  • And database protection rules

• Question 11. Data security can be understood as:

  • Easy for data maintenance work

  • Prevent unauthorized access, wrong regulations from inside or outside to.

  • Unifying standards, procedures and data protection and safety measures.

  • Consistency and data integrity

• Question 12. External model is:

  • Information content of the entire database.

  • Information content of the entire database under the view of the user.

  • Information content of a database part

  • The information content of a piece of data is viewed by the user.

• Question 13. The internal model is:

  • Is one of the database representation models in the form of physical storage.

  • The model represents an abstract database at the conceptual level.

  • There are many ways to represent databases in physical storage.

  • Physical data storage model

• Question 15. Decentralized database model is model:

  • Data is represented by pointers

  • Data is represented by an entity relationship.

  • Data is represented by tables

  • Data is represented by tree structure