Test of database security P9
- Question 1. The key school is the school:
- Single Key
- Unique Key
- First Key
- Primary Key
-
- Question 2. Which of the following statements is incorrect when talking about the client-server database?
- In the client-server architecture, the components (of the QSSDL) interact with each other to create the system consisting of the resource request component and the resource allocation component.
- Two components require resources and the resource component must be installed on the same computer
- The resource level component is usually installed at a server on the network (local).
- Components that require resources can be installed on many other machines (clients) on the network
-
- Question 3. Choose the correct option. Two tables in a relational database linked together through:
- Address of tables
- School's name
- Properties of the selected fields (not necessarily the keys)
- Key attribute
-
- Question 4. Which of the following statements is incorrect when talking about personal database?
- Users act as database administrators
- The safety of the personal database system is very high
- Personal database system is stored on 1 machine
- Database system only allows 1 user at a time
-
- Question 5. Which of the following criteria is often used to select a primary key?
- The key has the least properties
- Does not contain attributes that change over time
- Any lock
- Only the key has an attribute
-
- Question 6. What is a relational database?
- The database is built on the relational data model
- Database used to create, update and exploit relational databases
- The database is built based on relational data model and relational database exploitation
- Database used to create, update and exploit relational databases based on relational data model
-
- Question 7. Links between tables are based on:
- Key attribute
- Properties that match each other between tables
- The intention of the database system administrator
- The intention to join tables into a table has more properties
-
- Question 8. Which of the following statements is incorrect when talking about the advantages of a client-server database?
- Cost for communication decreased
- Adding a client is easy
- Developing and using client-server database systems is quite simple and easy
- Enhance the ability to ensure consistency of data
-
- Question 9. Which of the following statements about relational databases is correct?
- Set of data tables
- Database created from QTCSDL Access system
- Database that is interrelated between data
- The database is built on the relational data model
-
- Question 10. Which of the following statements is incorrect?
- Each table has at least one key
- Should choose the primary key is the key with the least attribute
- There can be multiple primary keys in a table
- Determining the key depends on the logical relationship of the data, not on the value of the data
-
4 ★ | 2 Vote