Test about database security P5

In the quiz below, join the Network Administrator to find out more about this topic through extremely interesting multiple choice questions.

  1. Question 1. Is it possible to insert information about a cable when not installed?

    1. Unable to, because the key value is unknown

    2. Can insert

    3. Impossible, because of information conflicts.

    4. Impossible, because of information anomalies

  2. Question 2. The relation R is called the normal form 3NF, when and only if:

    1. Does not exist X Y F + , X + Ω, YX and Y are non-key attributes

    2. Exist X Y F + , YX, or X is the key or Y is the key attribute

    3. Existing X Y F + , X + Ω, YX and Y are non-key attributes

    4. There is no X Y F + , YX, or X is the key or Y is the key attribute

  3. Question 3. Data manipulation language is:

    1. A set of data representations

    2. A set of operations used to update and supplement on database systems

    3. A set of data representation rules

    4. A set of operations used to manipulate database systems

  4. Question 4. The results of data manipulation operations are:

    1. Data series

    2. Data file

    3. relationship

    4. Database

  5. Question 5. Let Ω = {A, B, C} and F = {A - C, A - B}.

    1. No key attributes exist

    2. The above relationship has a standard form 2NF

    3. There are unlocked properties

    4. {A, C}, {B, E} is the key of the above relationship

  6. Question 6. PROJECT projection is an operation:

    1. Create a new relationship, satisfying a new definition

    2. Create a new relationship, the properties are transformed from the source relationship

    3. Create a new relationship, attributes are source relationship attributes

    4. Create a new relationship, the source relations sets remove duplicates

  7. Question 7. Select which of the following statements is best:

    1. Data structure in simple 1NF relations

    2. The data structure in 1NF relations hides information anomalies

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

    4. Data structure in 1NF relations makes it difficult to query information
  8. Question 8. Please select the corresponding word / phrase to complete the following assertion: There are many ways to view data in the external model, but . showing all the information in the database is unique.
    1. Conceptual model
    2. Conceptual model
    3. Model in
    4. External model
  9. Question 9. Select the corresponding word / phrase to complete the following definition: Relational data language is . manipulating data in relational form. Data is represented in a unique way.

    1. Language describes entities and linkages of entities

    2. The set of operations has relational structures

    3. Set of arithmetic operations

    4. Data representation language

  10. Question 10. Select the corresponding word / phrase to complete the following definition: In relational database, storage operations are insert, modify, and remove operations. When manipulating . and ensuring data consistency and data integrity.

    1. Independent data

    2. Information loss

    3. Information security

    4. No information anomaly
Update 24 May 2019
quizzesdatabasestechnology testsinformationcomputer networkscomputer databasessoftwaredatabase management systems

You should read it

Maybe you are interested

Category

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile