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

  data

  client

  server

  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

  FALSE

  TRUE

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

  physical modem device

  music streaming device

  internet browser

  network routing 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

  client

  modem

 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. Accessibility 3. Adaptability

  1. Scalability 2. Backup 3. Security

  1. Centralisation 2. Backup 3. Accessibility

  1. Accessbility 2. Centralisation 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. Scalability 2. Backup 3. Security

  1. Centralisation 2. Accessibility 3. Adaptability

  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. Network overload 2. Maintenance

  1. Network overload 2. Cost

  1. Robustness 2. Maintenance

  1. Robustness 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. Network overload 4. Maintenance

  3. Network overload 4. Cost

  3. Robustness 4. Cost

  3. Robustness 4. Maintenance

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

  FALSE

  TRUE

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

  similar access

  concurrent access

  bi-streamable access

  multiple access

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

  packet clashing

  an update being lost between changes

  nothing being lost, as the system remains secure

  client virus escalation

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

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

  All of these answers are valid

  Timestamp ordering (this is a non-lock method)

  Record locking

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

  TRUE

  FALSE