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

  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

Update 24 May 2019
databaseinformation technologycomputer network

You should read it

Maybe you are interested

Category

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile