Chapter 9, Problem 4DE

Which of the following computerized control procedures would be most effective in ensuring that data uploaded from personal computers to a mainframe are complete and that no additional data are added?    () Self-checking digits to ensure that only authorized part numbers are added to the database.  () Passwords that effectively limit access to only those authorized to upload the data to the mainframe computer.  () Batch control totals. including control totals and hash totals.  () Field-level edit controls that test each field for alphanumeric integrity

Which of the following is FALSE regarding a Disk-Oriented DBMSarchitecture? The DBMS has an execution engine that will execute queries. The DBMS has a buffer pool that manages the movement back and forthbetween disk and memory. The database is all on disk, and the data in the database files is organized intopages, and the first page is the directory page.The buffer pool will ask the execution engine for a specific page, and theexecution engine will take care of bringing that page into memory. In order to operate on the data the DBMS needs to bring the data into memory.

In this assignment, you are required to write a bash script, call it mycontainer.sh to do the following tasks:1) Create an LXD container based on ubuntu.2) Install the latest version of mysql on the container created in Step 1. Then, start the database and autostart it during future boots.3) Print the process ID of the running database, then give this process the highest possible priority.4 Inside the container, create a new systemd service to:    Re-execute Step 3 to adjust the priority.    Send a notification message to your AUIS email address(es).    Call this new service ‘email-mysql.service’.5) Adjust systemd to run the ‘email-mysql.service’ automatically once every six hours.6) Lastly, include necessary Bash commands to upload your container to an ssh server with the IP address 192.168.1.1. Assume the username and password are 'auis' and 'pass123', respectively.