ف الاوراكل اذا ممكن تساعدوني في حل الاسايمنت
Create and maintain a database server
1. You are a Database Adminsitrator Team Leader in the organization. Last week, you and your team upgraded database mangement system with newer veriosn (Oracle 8i to 10g) to fulfills the demand of new database applications. After testing all data and legacy application you feel satisfied with your team work and efforts. You decided to write a report about database administration tasks you have done last week:
Your report includes: (1 x 5 = 5 marks)
1.1 Role and purpose of database administrator
1.2 Different tasks performed by a database adminstrator
1.3 Tools used for monitoring database performance
1.4 You have facilitated team work in developing and upgrading database applications
(The Role of DBA in database application development)
1.5 Complete database architecture (Physical and logical)
We ‘ve installed newer version of Oracle in database lab. Please use the same version for giving different examples.
Manage database instances
2. Perform the following tasks: (2.1, 2.2: 2.5 + 2.3: 2.5 = 5 Marks)
2.1 Create atleast three database instances in same computer followed by OFA rules
2.2 Provide details/ documentation of created databases. (Explore your created
database: Provide Size, total files, configuration option, etc.)
2.3 Create a schedule for monitoring and maintenance of each and every database
Managing Database Storage
3. The organization’s data model should reflect its key business processes and decision-making requirements. Data planning may need to be performed to make sure that the organization data model delivers information effectively for its business processes and enhances organizational performance. Designing a database is an organizational endeavor.
(2.5 x 2= 5 Marks)
3.1 How will you convert a data model into physical database schema? Provide an
example by using Oracle database system. Use all possible storage options before creatign schema for the data model.
3.2 How will you analyze database storage requirement for the organization?
Please write appropriate steps or your own plan.