ORACLE DATABASE INTERVIEW QUESTIONS

What is an Oracle Database Instance?

What are Oracle datafiles?

What is a control file in Oracle?

What are redo logs in Oracle?

What is a tablespace in Oracle?

What is the System Global Area (SGA)?

What is the Program Global Area (PGA)?

Can you name some Oracle background processes?

What is the Oracle alert log?

What is an Oracle Listener?

What is an Oracle parameter file (PFILE)?

What is an Oracle Server Parameter File (SPFILE)?

What is control file multiplexing in Oracle?

What is the Oracle Data Dictionary?

What is an undo tablespace in Oracle?

What are archive logs in Oracle?

What is Oracle Flashback Technology?

What is a block in Oracle?

What is an Oracle schema?

What is Oracle Data Pump?