Database test - Part 3

Multiple choice questions revolve around database topics for your reference.

Question 1. Choose which of the following statements is most appropriate:
1. Data structures in 1NF relations allow for additional modifications conveniently.
2. The data structure in 1NF relations hides information anomalies
3. Data structure in 1NF relations makes it difficult to query information.
4. Data structure in simple 1NF relations
Question 2. The process of optimizing data query questions is the process:
1. The results of operations are represented solely by a relation.
2. It is necessary to change reasonable questions.
3. Transform the question so that the cost of time and memory usage is the least.
4. 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 .
1. Access method.
2. Access strategies.
3. Infomations.
4. 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 .
1. Data integrity in storage.
2. An data integrity.
3. Information loss.
4. 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.
1. Symmetry
2. In type one - one and many - one
3. In the type of a linked record type
4. 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.
1. Change
2. Independent of each other
3. Constant
4. Interdependence
Question 7. Please select the corresponding word / phrase to complete the following definition: Value of key components .
1. Receiving multiple values
2. Get the value of 'False'
3. Get the value of monotherapy
4. 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.
1. Partitioning relationships into many separate groups
2. Perform sorting according to the instruction after the ORDER BY clause
3. Make a selection after the WHERE clause
4. Perform a projection after the SELECT clause
Question 9. Please select the corresponding word / phrase to complete the following statement: Data integrity means .
1. Can implement data access strategies
2. Data in the database is always accurate at all times
3. Searchable at all times
4. 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 .
1. Ensure data integrity
2. Only system and user know
3. Only allowed to access the database
4. And database protection rules
Question 11. Data security can be understood as:
1. Easy for data maintenance work
2. Prevent unauthorized access, wrong regulations from inside or outside to .
3. Unifying standards, procedures and data protection and safety measures
4. Consistency and data integrity
Question 12. External model is:
1. Information content of the entire database
2. Information content of the entire database under the view of the user
3. Information content of a database part
4. The information content of a piece of data is viewed by the user
Question 13. The internal model is:
1. Is one of the database representation models in the form of physical storage
2. The model represents an abstract database at the conceptual level
3. There are many ways to represent databases in physical storage
4. Physical data storage model
Question 15. Decentralized database model is model:
1. Data is represented by pointers
2. Data is represented by an entity relationship
3. Data is represented by tables
4. Data is represented by tree structure