--Course ID: CS540 (B) --Student ID: 16020 --Student Name: Jaydutt Pathak --Homework#: 02
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).
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