Database Test - Part 2

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

Understanding Database Test

• Sentence 1. The operands in the operations are:

  • Expressions

  • Relationships

  • Properties

  • Value sets

• Question 2. Modification is an operation:

  • Modify the value of some properties.

  • Modify the description of attributes.

  • Modify the value of a relationship or a group of relationships.

  • Modify the value of a set or a set of sets.

• Question 3. The correct order in the SELECT statement.

  • SELECT, FROM, WHERE, GROUP BY HAVING, ORDER BY.

  • SELECT, FROM, GROUP BY HAVING, ORDER BY

  • SELECT, FROM, GROUP BY HAVING, ORDER BY

  • SELECT, FROM, GROUP BY HAVING, WHERE, ORDER BY.

• Question 4. Collection operations in the WHERE clause include:

  • Relational algebraic operations

  • Arithmetic operations and comparisons

  • Algebra expression

  • Comparisons.

• Question 5. Group operations are used after the clause:

  • SELECT

  • FROM

  • WHERE

  • GROUP BY

• Question 6. Selection is made after any clause in SELECT - FROM - WHERE.

  • GROUP BY HAVING

  • WHERE

  • SELECT

  • FROM

• Question 7. Data Definition Language - DDL (Data Definition Language).

  • Specified by the application program

  • Specified by a part of the database management system.

  • Specified in a data language

  • Specified in a language, part of the database management system.

• Question 8. The two expressions E1 and E2 are equivalent, denoted by E1 E2, if:

  • They represent the same mapping.

  • The same relationships in expressions.

  • The results are the same

  • Relationships in defined domain expressions.

• Question 9. Secure network level.

  • Information protection on transmission lines.

  • Allow remote, controlled access

  • Allow remote access

  • Do not allow remote access

• Sentence 10. Access form in SQL:

  • GRANT ON TO

  • GRANT ON TO

  • GRANT ON TO

  • GRANT READ ON R

• Question 11. Select which of the following statements is most appropriate.

  • Data inconsistencies in storage make data lose integrity.

  • Data integrity ensures data is always correct.

  • Data consistency ensures easy updates and additions.

  • Hosted organization according to database theory, repeatable attributes.

• Question 12. Select which of the following statements is best:

  • Data is represented, describing many different ways.

  • Users working on databases can alter the data storage structure and database access strategy.

  • Storage structure and the above application program systems are independent of each other.

  • The goal of database systems is: the immutability of application systems for changes in storage structure and data access strategy.

• Question 13. Choose which of the following statements is best:

  • Data normalization is the process of separating relations without losing information.

  • The root relationship is contained in the natural connection of projection relations.

  • Data stored in the database reflects data integrity.

  • Data normalization is the process of performing storage operations.

• Question 14. Choose which of the following statements is most correct when talking about goals.

  • Separation of relationships is the implementation of query and search optimization.

  • Relationship separation is intended to ensure data independence.

  • Relational separation is the optimal storage performance, memory saving.

  • Relationship separation is mitigating calculations.

• Question 15. Choosing which of the following statements is best:

  • When performing separation, the original relation is not lost.

  • When performing separation, the original relationship is lost.

  • When performing separation, the root relationship is always lost.

  • When performing separation, the root relationship can be lost.