Tuesday, July 30, 2019

Oracle DB Interview Questions

Hi All,
I am posting some Oracle database related interview questions. They are not meant for Oracle DBAs but for Oracle PL/SQL developers.
1. What is the difference between Oracle 8i,9i and 10g ?
Ans: 1.Tablespace.
Earlier to 8i , the only tablespace which was locally managed was TEMP.In 8i, all the tablespaces except SYSTEM are locally managed. In 9i, all the tablespaces including SYSTEM are locally managed. In 10g, we can define DEFAULT tablespace for each database objects. In 9i and prior versions, the default tablespace for all the database objects was SYSTEM and the DBAs had to move them into corresponding tablespaces.
2. Buffer cache.
In 8i, there was a single buffer cache. The newly created tables are allowed to sit in the buffer pool until they get free buffer cache. 


2 comments: