Preview

08 - Client Server Databases

 1. In this diagram, the ______ can be a node on the network, or someone sitting on the other end of the world! The structure still works in the same way.
client_server_databases.png

  server

  client

  data

  processor

 2. In a client-server database, the client ________________from another program (the server)

  duplicates data

  sends data

  creates indexes

  requests data

 3. Data is requested via a server by a connection made over a WAN or a LAN

  TRUE

  FALSE

 4. Once the data request is fulfilled, the connection is terminated. A simple example of this can be seen on any ________________

  music streaming device

  internet browser

  network routing device

  physical modem device

 5. In the example of online banking, the _____ acts as a client to interface the user of the computer with a database that has stored data of the website.

  device itself

  data protection officer

  internet browser

  CPU

 6. In online banking, the browser sends a request for data from the banking _____, and the _____replies with authentication and authorisation steps for identity confirmation.

  server

  model

  modem

  client

 7. Fill in the blanks for 1, 2 and 3 in the following list that describes the advantages of a client-server database model
client_server_databases_advantages.png

  1. Centralisation 2. Backup 3. Accessibility

  1. Accessbility 2. Centralisation 3. Security

  1. Centralisation 2. Accessibility 3. Adaptability

  1. Scalability 2. Backup 3. Security

 8. Fill in the blanks for 4,5 and 6 in the following list that describes the advantages of a client-server database model
client_server_databases_advantages2.png

  1. Centralisation 2. Backup 3. Accessibility

  1. Centralisation 2. Accessibility 3. Adaptability

  1. Scalability 2. Backup 3. Security

  1. Accessbility 2. Centralisation 3. Security

 9. Fill in the blanks for 1 and 2 in the following list that describes the disadvantages of the client-server model.
client_server_databases_disadvantages1.png

  1. Robustness 2. Cost

  1. Network overload 2. Maintenance

  1. Robustness 2. Maintenance

  1. Network overload 2. Cost

 10. Fill in the blanks for 3 and 4 in the following list that describes the disadvantages of the client-server model.
client_server_databases_disadvantages2.png

  3. Robustness 4. Cost

  3. Network overload 4. Cost

  3. Network overload 4. Maintenance

  3. Robustness 4. Maintenance

 11. Generally speaking, the client-server model is cheap and inefficient to run and maintain.

  TRUE

  FALSE

 12. When the server allows clients to simultaneously access the same piece of data at the same time, it is called:

  concurrent access

  multiple access

  similar access

  bi-streamable access

 13. If a server allows simulatenous access, it could result in ____________________

  packet clashing

  client virus escalation

  nothing being lost, as the system remains secure

  an update being lost between changes

 14. Concurrent access is important for reading, but needs monitoring when it comes to updates. It can be controlled by:

  Record locking

  Timestamp ordering (this is a non-lock method)

  Serialisation (creating clones of data items that are stored locally)

  All of these answers are valid

 15. Record locking involves opening a read only file so it cannot be edited by another user while open.

  TRUE

  FALSE