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

  client

  server

  data

  processor

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

  creates indexes

  duplicates data

  sends data

  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 ________________

  music streaming device

  network routing device

  internet browser

  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.

  CPU

  data protection officer

  internet browser

  device itself

 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.

  client

  modem

  server

  model

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

  1. Centralisation 2. Backup 3. Accessibility

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

  1. Centralisation 2. Backup 3. Accessibility

  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. Robustness 2. Maintenance

  1. Robustness 2. Cost

  1. Network overload 2. Cost

  1. Network overload 2. Maintenance

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

  3. Network overload 4. Maintenance

  3. Network overload 4. Cost

 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:

  concurrent access

  similar access

  multiple access

  bi-streamable access

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

  client virus escalation

  an update being lost between changes

  packet clashing

  nothing being lost, as the system remains secure

 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)

  All of these answers are valid

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

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

  TRUE

  FALSE