12 May Scenarios1. (20 points) You are going to make changes to
Scenarios
1. (20 points) You are going to make changes to the Company database and need to create a backup of the database. Create a detailed checklist for backing up the database. Include the specific commands you would use in the operating system and in sqlplus.
2. (20 points) One of the application developers was fired. She had access to several of the tables, but did not have DBA-level privileges. That is, she could work with tables but could not create or delete any tables. What do you have to do to protect the database? What commands would you use?
3. (20 points) A user calls to say that he could not connect to the database and wants to know what is wrong with the database. As a DBA, the “rule” is that everything is a database problem until you prove otherwise. What steps would you take to determine if there is a database problem or a non-database problem? Create a checklist of the specific steps and commands you would use to determine if there is a database problem.
4. (40 points) You have just completed a batch load of the database for a new client. The client said the data had been verified as accurate. As part of the process for a batch load using the SQL loader utility (sqlldr), all primary and foreign key constraints have been disabled. Now you need to recreate the constraints. Create a checklist (or multiple separate checklists) to solve the following problems. Each problem occurs separately; do not assume all the problems occur and are fixed in sequence.
a. After completing the load, you check the number of inserted rows and find that one of the tables does not have as many rows as it should have. How do you find what rows were not inserted? If you are also required to fix the error, what steps do you take to correct the problem?
b. When you rebuild the primary key constraints, you discover that one of the tables receives an error that the primary key could not be created. What are the possible causes of the error? How do you determine what caused the error? What do you do to correct the error?
c. When you rebuild the foreign key constraints, one of the tables receives an error that the foreign key could not be created. You know that all the tables have valid primary keys. What are the possible causes of the error? How do you determine what caused the error? What would you do to correct the error?
5. Extra Credit (maximum of 20 points) You receive an email alert that a table is about to run out of space. How do you give that table more space?
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.