HomeTech infoQuiz technologyDatabase test - Part 2

Database test - Part 2

  1. Sentence 1. The operands in the operations are:

    1. Expressions

    2. Relationships

    3. Properties

    4. Value sets

  2. 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.

  3. 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

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

    1. Relational algebraic operations

    2. Arithmetic operations and comparisons

    3. Algebra expression

    4. Comparisons.

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

    1. SELECT

    2. FROM

    3. WHERE

    4. GROUP BY

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

    1. GROUP BY HAVING

    2. WHERE

    3. SELECT

    4. FROM

  7. 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.

  8. 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

  9. 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

  10. Sentence 10. Access form in SQL:

    1. GRANT ON TO

    2. GRANT ON TO

    3. GRANT ON TO

    4. GRANT READ ON R

  11. 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

  12. 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.

  13. 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

  14. 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.

  15. 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.

5 ★ | 2 Vote
Quizzesdatabasescomputerscomputer networks

You should read it

May be interested

  • Database test - Part 3Photo of Database test - Part 3
    multiple choice questions revolve around database topics for your reference.
  • What test do you know about the operating system?Photo of What test do you know about the operating system?
    in the following article, please join the network administrator to learn about the operating system through extremely interesting multiple choice questions. let's start.
  • Test about LANPhoto of Test about LAN
    in this article, join the network administrator to answer multiple choice questions related to lan.
  • Information security test?Photo of Information security test?
    to help readers update more about this topic, the quiz below is a summary of some information security questions for you to learn.
  • Test TCP / IP knowledgePhoto of Test TCP / IP knowledge
    a simple and basic test of knowledge around the tcp / ip protocol. you just need to choose which answer is the best and see the final result we give ...
  • Are you sure you understand the smartphone manufacturers?Photo of Are you sure you understand the smartphone manufacturers?
    in this article, network administrator will send you 10 multiple choice questions related to smartphone manufacturers around the world. try to see how well i understand brands!

Quiz technology