Will the data from Oracle Database be lost after formatting the system in which it is installed?

So Someone asked me a question, Will the data from Oracle Database be lost after formatting the system in which it is installed?

Since the oracle database stores the data in the data files in the physical disk, formatting the system will delete the data files, log files, and oracle software. By losing these files, you will be losing the oracle database data. 

What can be done is, take the export of the data required and put the export file into your pen drive or some other storage, then format the disk, install the oracle software, create the required users and then import the data. 

Employee who work on concepts of Oracle is called

In software industry , mostly the employees who work on oracle concepts can be classified into two roles. They are Oracle database developers, oracle database administrators. 

Developers use the programming concepts such as SQL , PLSQL and write the programs to process the business logic. They develop the applications to store , retrieve, manipulate the data.   

Administrators use the database administration concepts to manage the database such as user accounts creation, giving roles/privilege's , backups , recovery, export and import of data, fine tuning the database for performances, patching the database with the latest versions, upgradations, migrations etc. 

Query to find the third highest salary

Normally this question is asked check the analytical skills . This is the most commonly asked question the interviews. 

select * from( select ename, sal, dense_rank() over(order by sal desc)r from Employee) where r=3;