HomeTech infoQuiz technology

Test about database security P8

  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
quizzesdatabasestechnology testsinformationcomputer networkscomputer databasessoftwaredatabase management systems

You should read it

May be interested

  • Test of database security P10Test of database security P10
    database is a data collection organized in a structured way related to each other and stored in a computer. the database is designed and built to allow users to store data, retrieve information or update data. here, please read more about this topic through our quiz below.
  • Test of database security P9Test of database security P9
    please read your knowledge and multiple choice questions about the database that the network administrator has edited below. certainly with this useful knowledge will help you work more effectively.
  • [QUIZ] Test your understanding of SQL - Part 5[QUIZ] Test your understanding of SQL - Part 5
    multiple-choice questions on sql help you familiarize and review useful knowledge for work and learning sql language.
  • Test on database security P7Test 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.
  • Test about database security P13Test about database security P13
    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.
  • A serious vulnerability on phpMyAdmin allows an attacker to destroy the databaseA serious vulnerability on phpMyAdmin allows an attacker to destroy the database
    a serious security vulnerability on phpmyadmin - one of the most popular mysql database management software will harm the database when the tricked administrator clicks on the link.
  • Database security (common usage guidelines)Database security (common usage guidelines)
    recently, the database security issue has spread widely on the mass media and internet news network. the first is the slammer worm and most recently the illegal access to more than 8 million credit card numbers. many people put
  • [QUIZ] Test your understanding of SQL - Part 7[QUIZ] Test your understanding of SQL - Part 7
    part 7 of the sql quiz goes into the sql practice exercises that follow the previous period.
  • Test about database security P5Test 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.
  • Test on database security P4Test on database security P4
    today network administrator will give you reading multiple choice questions around the topic of databases, with certain questions below you will have more useful knowledge.

Quiz technology