CS540_B_HW02_16020.pdf - -Course ID CS540(B-Student ID 16020-Student Name Jaydutt Pathak-Homework 02 QUESTION 1 Briefly describe what are database

CS540_B_HW02_16020.pdf - -Course ID CS540(B-Student ID...

This preview shows page 1 - 3 out of 5 pages.

--Course ID: CS540 (B) --Student ID: 16020 --Student Name: Jaydutt Pathak --Homework#: 02
Image of page 1
QUESTION 1: Briefly describe what are database administrator tasks? ANSWER The first thing that DBA should do is keep the database alive. DBA also can create the database and plan it. If somehow database crash and cannot be rolled back than DBA is there to recover the database. Another part of DBA job is to have back up the fully functional database and keep tuning between them. QUESTION 2: Briefly describe what is Oracle instance? ANSWER Oracle instance means to access the database and always opens one and only one database which consists of memory and process structure. A database instance is also a set of memory structure that manage database file. QUESTION 3: Briefly describe what is Oracle database? ANSWER Oracle database is a collection of data that is treated as a unit which consist of three file types Data files, Control files, Redo log files. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management. QUESTION 4: Briefly describe what is Oracle memory structure? ANSWER DBMS’s memory structure mainly consist of two memory areas known as System Global Area (SGA), Program Global Area (PGA).
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 5 pages?

  • Spring '18
  • Oracle Database, Oracle Corporation, Database management system, Database Buffer Cache

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture