HomeTech infoQuiz technology

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

  • eQuiz - Multiple choice test on SQLeQuiz - Multiple choice test on SQL
    this is a small test of the sql database administration system, there will be 10 questions in total with no time for answering each sentence.
  • Test on database security P6Test on database security P6
    database is the most important component in every application system, data such as e-mail, documents, presentations, databases, graphics, audio files and spreadsheets are living resources also of most businesses today, thus ensuring database security is a very important job. the test below is with the network administrator to learn about this topic.
  • Create Active Directory accounts from the Exchange database (Part 1)Create Active Directory accounts from the Exchange database (Part 1)
    what can you do with a mailbox database? in an incident scenario, we lost the domain controller and didn't have any backups, an exchange server database would be very useful in this case and could save a lot of time in the future.
  • Database testDatabase test
    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.
  • Excel computer test - Part 3Excel computer test - Part 3
    after the second part of the excel test, the network administrator will continue to send you the 3rd part of the quiz series on this topic. let's work together to test your knowledge.
  • eQuiz - Multiple choice test on ASPeQuiz - Multiple choice test on ASP
    here is a small test of asp web programming language, a total of 30 questions will be answered with no time to answer each sentence.
  • Test SQL Server with Windows PowerShell - Part 6Test SQL Server with Windows PowerShell - Part 6
    part 6 will show you how to check all existing databases in the sql server instance and query the database properties.
  • eQuiz - Multiple choice test on programming language C - part 1eQuiz - Multiple choice test on programming language C - part 1
    this is part 1 of a series of tests on knowledge of c programming language, in total there will be 15 questions with no time for answering each sentence.
  • Test about database security P11Test about database security P11
    testing of databases will help you gain more useful knowledge about this topic to apply to learning and working. the question set will have 10 sentences to test your knowledge.
  • Test about database security P12Test about database security P12
    testing of databases will help you gain more useful knowledge about this topic to apply to learning and working. the question set will have 10 sentences to test your knowledge

Quiz technology