Home Tech info Quiz technology

Test on database security P7

Please read your knowledge of the database through the multiple choice questions below. Hope with these interesting questions will give you lots of useful information.

  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
technology tests computer networks computer databases database management systems
4 ★ | 1 Vote
« PREV : What test you know...
Test on database... : NEXT »
Read More
Maybe you are interested