Test about database security P8

Database (database) is a complex and very difficult field to complete, because in addition to understanding the structure, computer system, to complete a database of database designers, there must be thinking. , ability to analyze and recognize good issues. The following test on database will be helpful to test your knowledge.
  1. Question 1. For the board of banks (MANV, TENNV, LCB). Want to check if all employees' salaries in the case of a basic salary increase of 10%, which of the following statements would we use?
    1. Select MANV, TENNV, LCB * .10 from NHANVIEN
    2. Select MANV, TENNV, LCB + LCB * .01 from NHANVIEN
    3. Select MANV, TENNV, LCB + LCB * .10 from NHANVIEN
    4. Select MANV, TENNV, LCB + 10 from NHANVIEN
  2. Question 2. To select all columns and list all rows from the VATTU table with LOAIVT attribute (number type) is 1, which of the following statements is most correct?
    1. SELECT * FROM VATTU WHERE LOAIVT = 1
    2. SELECT * FROM VATTU WHERE GroupID = "1"
    3. SELECT LOAIVT FROM VATTU WHERE LOAIVT = 1
    4. SELECT LOAIVT FROM VATTU WHERE LOAIVT = "1"
  3. Question 3. Which statement is used to calculate the total number of lines in the NHANVIEN table?
    1. Select rowcount from NHANVIEN
    2. Select sum (*) from NHANVIEN
    3. Select count (*) from NHANVIEN
    4. Select count_rows from NHANVIEN
  4. Question 4. Equally connecting relationships by attributes is:
    1. Perform the Subject and selection
    2. Perform the Subject and projection
    3. Perform projection and division
    4. Perform the Subject and division
  5. Question 5. Delete is an operation
    1. Delete an attribute or delete a group of attributes
    2. Delete a set or delete a set of sets
    3. Delete a relationship in the database
    4. Delete a column or multiple columns
  6. Question 6. Why does the primary key not allow NULL?
    1. Difficult to determine the uniqueness of rows
    2. Difficult to determine the uniqueness of columns
    3. Difficult to connect tables
    4. Foreign key is difficult to identify
  7. Question 7. Please select the corresponding word / phrase to complete the following statement: From a given group of super keys, it is possible .
    1. Specify a primary key in it
    2. Cannot identify a primary key in it
    3. Define a group of attributes
    4. Determine any attribute
  8. Question 8. The link between the two tables is based on:
    1. Primary key and foreign key
    2. Properties that match each other between tables
    3. The intention of the database administrator
    4. The intention to join tables into a table has more properties
  9. Question 9. The main components in the combined entity model include:
    1. Table numbers, entities and relationships
    2. Entity, association and number table
    3. Entity, relationship, binding
    4. Binding entities, associations and number tables
  10. Question 10. What are the steps in building a database?
    1. Design
    2. Survey
    3. Test
    4. Contract
4 ★ | 2 Vote