بتاريخ: 24 أكتوبر 200817 سنة comment_141382 هلا شباب عهندي ه الاسايمنت وما عارفلا شلون احله لاني تخصص شبكات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 administrator1.2 Different tasks performed by a database adminstrator1.3 Tools used for monitoring database performance1.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)Hint: We ‘ve installed newer version of Oracle in database lab. Please use the same version for giving different examples. Manage database instances2. 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 rules2.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 instanceManaging Database Storage3. 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. DBA_Assignemt_1_Fall2008.doc تقديم بلاغ
بتاريخ: 24 أكتوبر 200817 سنة كاتب الموضوع comment_141383 اذا في اي احد حب يساعدني ويتواصل معي ع الاميل [email protected][وسط][/وسط] تقديم بلاغ
انضم إلى المناقشة
يمكنك المشاركة الآن والتسجيل لاحقاً. إذا كان لديك حساب, سجل دخولك الآن لتقوم بالمشاركة من خلال حسابك.