Oracle DBA Interview Questions/FAQs Part2

21. What is a datafile? Every Oracle database has one or more physical datafiles. Datafiles contain all the database data. The data of logical database structures such as tables and indexes is physically stored in the datafiles allocated for a database. 22. What are the contents of control file? Database name, SCN, LSN, datafile locations, … continue reading


Oracle DBA Interview Questions, Oracle FAQ Questions?

Oracle DBA Interview Questions/FAQs Part1 1. What is an instance? SGA + background processes. 2. What is SGA? System/Shared Global Area. 3. What is PGA (or) what is pga_aggregate_target? Programmable Global Area. 4. What are new memory parameters in Oracle 10g? SGA_TARGET PGA_TARGET 5. What are new memory parameters in Oracle 11g? MEMORY_TARGET 6. What … continue reading

Visit Us On FacebookVisit Us On Google PlusVisit Us On Youtube