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.
- 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?
- Select MANV, TENNV, LCB * .10 from NHANVIEN
- Select MANV, TENNV, LCB + LCB * .01 from NHANVIEN
- Select MANV, TENNV, LCB + LCB * .10 from NHANVIEN
- Select MANV, TENNV, LCB + 10 from NHANVIEN
-
- 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?
- SELECT * FROM VATTU WHERE LOAIVT = 1
- SELECT * FROM VATTU WHERE GroupID = "1"
- SELECT LOAIVT FROM VATTU WHERE LOAIVT = 1
- SELECT LOAIVT FROM VATTU WHERE LOAIVT = "1"
-
- Question 3. Which statement is used to calculate the total number of lines in the NHANVIEN table?
- Select rowcount from NHANVIEN
- Select sum (*) from NHANVIEN
- Select count (*) from NHANVIEN
- Select count_rows from NHANVIEN
-
- Question 4. Equally connecting relationships by attributes is:
- Perform the Subject and selection
- Perform the Subject and projection
- Perform projection and division
- Perform the Subject and division
-
- Question 5. Delete is an operation
- Delete an attribute or delete a group of attributes
- Delete a set or delete a set of sets
- Delete a relationship in the database
- Delete a column or multiple columns
-
- Question 6. Why does the primary key not allow NULL?
- Difficult to determine the uniqueness of rows
- Difficult to determine the uniqueness of columns
- Difficult to connect tables
- Foreign key is difficult to identify
-
- Question 7. Please select the corresponding word / phrase to complete the following statement: From a given group of super keys, it is possible .
- Specify a primary key in it
- Cannot identify a primary key in it
- Define a group of attributes
- Determine any attribute
-
- Question 8. The link between the two tables is based on:
- Primary key and foreign key
- Properties that match each other between tables
- The intention of the database administrator
- The intention to join tables into a table has more properties
-
- Question 9. The main components in the combined entity model include:
- Table numbers, entities and relationships
- Entity, association and number table
- Entity, relationship, binding
- Binding entities, associations and number tables
-
- Question 10. What are the steps in building a database?
- Design
- Survey
- Test
- Contract
-
4 ★ | 2 Vote
You should read it
- Test about database security P12
- Test about database security P11
- Test about database security P5
- Test about database security P13
- Test on database security P7
- Test of database security P9
- Test of database security P10
- Test on database security P6
- Database test - Part 2
- Microsoft Access test has the answer P1
- The Microsoft Access test has the answer P5
- The Microsoft Access test has a P3 answer
Maybe you are interested
Tinder integrates a new AI tool to automatically select the most suitable profile photo for users
How to round the corners of a selection in Photoshop is simple and easy
Fix error The selected disk has an MBR partition table when installing Windows, MBR - GPT hard drive error
4 ways to select multiple files on Mac
Solve the Error of No Photos Selected on the Phone
How to Select All on Mac