TipsMake

Database test - Part 3

Multiple choice questions revolve around database topics for your reference.

★ Test about database security P13
★ Test on database security P7
  • Question 1. Choose which of the following statements is most appropriate:

    • Data structures in 1NF relations allow for additional modifications conveniently.

    • The data structure in 1NF relations hides information anomalies

    • Data structure in 1NF relations makes it difficult to query information.

    • Data structure in simple 1NF relations

  • Question 2. The process of optimizing data query questions is the process:

    • The results of operations are represented solely by a relation.

    • It is necessary to change reasonable questions.

    • Transform the question so that the cost of time and memory usage is the least.

    • The cost of performing the operations is minimal.

  • Question 3. Select the corresponding word / phrase to complete the following assertion: 'Data independence' . of application systems for changes in storage structure and data access strategy .

    • Access method.

    • Access strategies.

    • Infomations.

    • Immutability

  • Question 4. Please select the corresponding word / phrase to complete the following definition: In the tree-shaped structure, when modifying some information in dependent records, you must browse the entire model, by searching in appeared. Leads to the appearance .

    • Data integrity in storage.

    • An data integrity.

    • Information loss.

    • Data inconsistency in storage.

  • Question 5. Select the corresponding word / phrase to complete the following definition: Network data model is a relational entity model, in which the linkages are limited . Does not contain many - many links.

    • Symmetry

    • In type one - one and many - one

    • In the type of a linked record type

    • In the type of an entity record

  • Question 6. Select the corresponding word / phrase to complete the following definition: Data independence in highly relational database systems, showing storage structure and access strategy can . but do not change the concept diagram and vice versa.

    • Change

    • Independent of each other

    • Constant

    • Interdependence

  • Question 7. Please select the corresponding word / phrase to complete the following definition: Value of key components .

    • Receiving multiple values

    • Get the value of 'False'

    • Get the value of monotherapy

    • Get 'True' value

  • Question 8. Select the corresponding word / phrase to complete the following assertion: If the SELECT statement contains GROUP BY, the system will . and perform grouping operations.

    • Partitioning relationships into many separate groups

    • Perform sorting according to the instruction after the ORDER BY clause

    • Make a selection after the WHERE clause

    • Perform a projection after the SELECT clause

  • Question 9. Please select the corresponding word / phrase to complete the following statement: Data integrity means .

    • Can implement data access strategies

    • Data in the database is always accurate at all times

    • Searchable at all times

    • Ensure data independence at all times

  • Question 10. Select the corresponding word / phrase to complete the following assertion: The most common way to identify users is the password .

    • Ensure data integrity

    • Only system and user know

    • Only allowed to access the database

    • And database protection rules

  • Question 11. Data security can be understood as:

    • Easy for data maintenance work

    • Prevent unauthorized access, wrong regulations from inside or outside to .

    • Unifying standards, procedures and data protection and safety measures

    • Consistency and data integrity

  • Question 12. External model is:

    • Information content of the entire database

    • Information content of the entire database under the view of the user

    • Information content of a database part

    • The information content of a piece of data is viewed by the user

  • Question 13. The internal model is:

    • Is one of the database representation models in the form of physical storage

    • The model represents an abstract database at the conceptual level

    • There are many ways to represent databases in physical storage

    • Physical data storage model

  • Question 15. Decentralized database model is model:

    • Data is represented by pointers

    • Data is represented by an entity relationship

    • Data is represented by tables

    • Data is represented by tree structure

Discover more

quizzes databases good questions
Lesley Montoya

Share by

Lesley Montoya
Update 24 May 2019

You should read it