HomeTech infoQuiz technologyTest on database security P7

Test on database security P7

  1. Sentence 1. Basic entity-relationship model consists of object classes:
    1. Environment and environmental boundaries
    2. Entities, relationships and attributes
    3. Entities and properties
    4. Relationships
  2. Question 2. Which assertion is function dependent:
    1. Full name - Home phone number
    2. ID number - Full name
    3. Full name - Address
    4. Full name - ID card number
  3. Question 3. The 3NF relationship is acceptable during the search process, because:
    1. The dependency closure is too large
    2. Ensure data integrity
    3. Perform updates
    4. Do not appear to move information when performing storage operations
  4. Question 4. The process of transferring 1NF relations to 3NF is the process:
    1. Eliminating information anomalies and not losing information
    2. Eliminate information anomalies
    3. Eliminate information anomalies and loss of information
    4. No loss of information
  5. Question 5. The results of data manipulation operations are:
    1. Data series
    2. Data file
    3. Database
    4. relationship
  6. Question 6. In SQL, the data definition language includes functions:
    1. Security and access rights
    2. Create, edit and delete relationship structures. Add columns, edit columns and delete columns
    3. Create, edit and delete relationships. Security and access rights
    4. Create, edit and delete relationship structures. Security and access rights
  7. Question 7. Please select the corresponding word / phrase to complete the following assertion: A user can . and these rights can refer to the access rights of other users.
    1. Grant some access to the database
    2. Grant the right to search for data
    3. Grant all database access rights
    4. Grant the read and write permissions
  8. Question 8. Select the corresponding word / phrase to complete the following assertion: Data integrity means .
    1. Can implement data access strategies
    2. Searchable at all times
    3. Ensure data independence at all times
    4. Data in the database is always accurate at all times
  9. Question 9. Select the corresponding word / phrase to complete the following assertion: Equation E1 is equivalent to E2, if they represent the same mapping, ie . the same in the expression, then the result the same.
    1. Properties
    2. Relationships
    3. Records
    4. Operands
  10. Question 10. Select the corresponding word / phrase to complete the following assertion: In the expression of relation the operands are .
    1. Function dependencies
    2. Properties
    3. Elements
    4. Relationships in a database
4 ★ | 1 Vote
quizzesdatabasestechnology testsinformationcomputer networkscomputer databasessoftwaredatabase management systems

You should read it

May be interested

Quiz technology