HomeTech infoQuiz technologyDatabase test

Database test

  1. Question 1. Advantages of database:

    1. Reduce redundancy, consistency and integrity of data.

    2. Attributes are described in many different data files.

    3. Ability to appear inconsistent and inconsistent data.

    4. Appeared anomalous information.

  2. Question 2. Anomalous information may:

    1. Consistent data and integrity.

    2. There are no conflicting information.

    3. Lack of information in storage.

    4. Reflect the true objective data.

  3. Question 3. Users can access:

    1. The whole database

    2. Limit

    3. Part of the database

    4. Depends on access

  4. Question 4. The DBMS (DataBase Management System) database management system is:

    1. Software system controls access strategies and database storage organizations.

    2. Create data structure corresponding to data model.

    3. Update, insert, remove or modify file level data.

    4. Ensure safety, data security and data integrity.

  5. Question 5. Characteristics of a data model:

    1. Users have access at anytime, anywhere.

    2. Stability, simplicity, need to check for redundancy, symmetry and have a solid theoretical basis.

    3. Simple and unstructured data representation.

    4. Simple data model.

  6. Question 6. When manipulating data manipulation language on hierarchical database:

    1. There is a high probability of information volatility.

    2. Ensure data independence

    3. Ensure data integrity.

    4. Ensure stability

  7. Question 7. The structural characteristics of the network model are:

    1. Contains one - one, one - many and many - many links.

    2. Contains one-to-one and one-to-many links.

    3. Contains multiple links - one and one - many.

  8. Question 8. In the network database, when adding new records:

    1. Ensure consistency and integrity of data.

    2. Excess information.

    3. Consistency and integrity of data is not guaranteed.

    4. Conflict of information.

  9. Question 9. In the relational database model:

    1. The order of the columns is not important.

    2. The order of the rows is not important.

    3. The order of the rows is important.

    4. The order of columns is important.

  10. Question 10. X is a subset of attributes, symbol X Ω, when and only if:

    1. For every attribute of Ω

    2. If A Ω, deduce A X.

    3. For every attribute of Ω, is also the property of X

    4. For every attribute of X is also the attribute of Ω

  11. Question 11. X and Y are any two subsets of Ω. Then XY means:

    1. When the argument is the same, the function has many values.

    2. (r, s R) ((a X) (r (a) = s (a)) deduce (b Y) (r (b) = s (b))).

    3. A value of Y is determined by a value of X.

    4. (r, s R) (r (X) = s (X)) deduce r (Y) = s (Y)

  12. Question 12. Which of the following dependencies is fully dependent:

    1. (Invoice number, customer code) Customer name

    2. (ID card number, employee code) Working process

    3. (Order number, class code) Student's full name.

    4. (Newspaper code, customer code) Price quote

  13. Question 13. Which type of standard, name and address attributes does the relationship contain?

    1. Standard format 2NF

    2. Standard form 1NF, not 2NF

    3. Standard 3NF format

    4. Standard 2NF form, not 3NF

3.5 ★ | 2 Vote
databaseinformation technologycomputer network

You should read it

May be interested

  • Database test - Part 2Photo of 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.
  • 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 ...

Quiz technology