Database test - Part 2

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.

Sentence 1. The operands in the operations are:
1. Expressions
2. Relationships
3. Properties
4. Value sets
Question 2. Modification is an operation:
1. Modify the value of some properties.
2. Modify the description of attributes.
3. Modify the value of a relationship or a group of relationships
4. Modify the value of a set or a set of sets.
Question 3. The correct order in the SELECT statement
1. SELECT, FROM, WHERE, GROUP BY HAVING, ORDER BY
2. SELECT, FROM, GROUP BY HAVING, ORDER BY
3. SELECT, FROM, GROUP BY HAVING, ORDER BY
4. SELECT, FROM, GROUP BY HAVING, WHERE, ORDER BY
Question 4. Collection operations in the WHERE clause include:
1. Relational algebraic operations
2. Arithmetic operations and comparisons
3. Algebra expression
4. Comparisons.
Question 5. Group operations are used after the clause:
1. SELECT
2. FROM
3. WHERE
4. GROUP BY
Question 6. Selection is made after any clause in SELECT - FROM - WHERE
1. GROUP BY HAVING
2. WHERE
3. SELECT
4. FROM
Question 7. Data Definition Language - DDL (Data Definition Language).
1. Specified by the application program
2. Specified by a part of the database management system.
3. Specified in a data language
4. 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:
1. They represent the same mapping.
2. The same relationships in expressions.
3. The results are the same
4. Relationships in defined domain expressions
Question 9. Secure network level.
1. Information protection on transmission lines
2. Allow remote, controlled access
3. Allow remote access
4. Do not allow remote access
Sentence 10. Access form in SQL:
1. GRANT ON TO
2. GRANT ON TO
3. GRANT ON TO
4. GRANT READ ON R
Question 11. Select which of the following statements is most appropriate
1. Data inconsistencies in storage make data lose integrity
2. Data integrity ensures data is always correct
3. Data consistency ensures easy updates and additions
4. Hosted organization according to database theory, repeatable attributes
Question 12. Select which of the following statements is best:
1. Data is represented, describing many different ways.
2. Users working on databases can alter the data storage structure and database access strategy.
3. Storage structure and the above application program systems are independent of each other.
4. 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:
1. Data normalization is the process of separating relations without losing information.
2. The root relationship is contained in the natural connection of projection relations.
3. Data stored in the database reflects data integrity.
4. Data normalization is the process of performing storage operations
Question 14. Choose which of the following statements is most correct when talking about goals
1. Separation of relationships is the implementation of query and search optimization.
2. Relationship separation is intended to ensure data independence.
3. Relational separation is the optimal storage performance, memory saving.
4. Relationship separation is mitigating calculations.
Question 15. Choosing which of the following statements is best:
1. When performing separation, the original relation is not lost.
2. When performing separation, the original relationship is lost.
3. When performing separation, the root relationship is always lost.
4. When performing separation, the root relationship can be lost.