Directions: Please read the question. Type your answer in the space provided. Add new lines/pages if necessary.

Fantastic news! We've Found the answer you've been seeking!

Question:

Directions: Please read the question. Type your answer in the space provided. Add new lines/pages if necessary. No limit on the number of pages. Preferred file type to submit your answers is PDF.

Words in bold need to be used in your answer as is..

What are log files used for? Write about at least 2 points.

What three measures would you take to keep databases secure?

Write a statement to rename a user named Bobto Robert.(same server). (statement(s) required)

Write a statement to grant update and delete on all tables of testdatabase. (statement(s) required)

Write three benefits of backing up a database. [3 pts] What statement/command is used to backup a database?

What are three common errors/warnings trying to use the insert statement to do data entry?

Create a database named myStore. (statement(s) required)[1 pt] Create a table named managerand another one named departmentswith at least 3 fields each (please use correct datatypes for each).(statement(s) required)[6 pts]Establish a relationship between the manager and departmentstable. (statement(s) required)

Write a statement to add a 500 dollars holiday bonus for all employees who has been with the company since 01/01/2022.(statement(s) required) Add 250holiday bonus for employeeswho joined the company on or after 07/01/2022. (statement(s) required)

Backup a database named vehicles.(statement(s) required). Drop the database (statement(s) required) . Restore the database from the backup. (statement not required. Only steps that you are going to take to restore the database from the backup required.)