top 10 oracle dba questions

 Gathering Top 10 oracle dba questions according to my estimation and so far experience from dba tasks

1.What is the most important component of oracle database?

Answer:Init file

2.What is an index?

An index is a database structure that provides quick lookup of data in a column or columns of a table.

3.what is the scope of the index?

Indexes are used in Oracle to provide quick access to rows in a table. 

Indexes provide faster access to data for operations that return a small portion of a table's rows. 

Although Oracle allows an unlimited number of indexes on a table, the indexes only help if they are used to speed up queries.

4.what is PMON?

https://docs.oracle.com/cd/B19306_01/server.102/b14220/process.htm#i24686

5.where can I see oracle database diagnostics

6.What are the physical components of Oracle Database?

7. What are datafiles?

8.What does ACID mean in Database Systems?

9.The main function(s) of the redo log is?

10. What are the contents of the control file?