HomeTech infoQuiz technologyTest about database security P8

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

  • The Linux Network Administration test has the answer P5Photo of The Linux Network Administration test has the answer P5
    the following linux operating system quiz of network administrator will give you lots of useful information around this topic. please try your best.
  • Test on maintenance of P3 systemPhoto of Test on maintenance of P3 system
    the multiple choice questions on system maintenance will give you lots of useful information around this topic. let's try our questions below.
  • Microsoft Excel P12 testPhoto of Microsoft Excel P12 test
    the quiz on excel with many interesting questions will give you useful knowledge around this topic. the question set consists of 10 questions with 4 answers to choose from.
  • PowerPoint informatics test P7Photo of PowerPoint informatics test P7
    powerpoint is an important application in the microsoft office software suite produced by the big microsoft that creates presentation files. in the quiz below, network administrator will send you very interesting questions revolving around this topic for you to learn.
  • PowerPoint P8 informatics testPhoto of PowerPoint P8 informatics test
    please read your knowledge with questions around the powerpoint topic. the questions that the network editor below will give you some useful knowledge. let's start.
  • Test on C programming P6Photo of Test on C programming P6
    are you a fan of c programming language and want to learn about this programming language? the quiz below the network administrator has edited and sent you questions about this topic, invite you to experience.

Quiz technology