The Oracle Database Administrator is responsible for the installation and up gradation of the Oracle server. He monitors the database and does the modifications according to the need of application users. The performance and optimization of the database is in the hands of the Oracle Database Administrator. A sound technical knowledge of the field is the prerequisite for the job. There are various organizations which provide certification courses in the field of Oracle. If you have good command over your Oracle concepts then this career option has a lot to offer you in terms of knowledge and money as well.

I am here providing you some important and frequently asked questions that are asked by an employer:

1. What is the role of a database administrator?
A database administrator provides the physical and logical schema of the database. He gives authorization right to the eligible users. A database administrator also takes the backup of the database periodically. He also assigns various methods for storing and retrieving the data. The installation of the Oracle Server and ensuring its compliance with the license agreement is the duty of a DBA.

2. What are the utilities available for database administration?
The basic utilities available are SQL* DBA, SQL * Loader, Export and Import. SQL * DBA helps the administrator in monitoring an ORACLE database. SQL * Loader is useful for transferring data from flat files such as standard operating system files to Oracle database tables. Export and Import Utilities moves the data to and from the Oracle database in the Oracle format.

3. What is snapshot error?
This is snapshot too old error- oerr ora 01555. The main possible reason for this error is the small size of rollback segments. Basic remedy is to increase the size of all rollback segments. We can also add more roll back segments and increase the optimal size of the roll back segment.

4. What are materialized views?
Materialized views are objects that are reduced sets of information from base tables. They are grouped and summarized from base tables. This is used in decision support system and data warehouse.

5. What happens if we set GLOBAL_NAMES to TRUE status?
By setting GLOBAL_NAMES, we dictate the way we connect to a database. If we set its status to TRUE then it forces database links to have the same name as the remote database links to which they are establishing connection.

These are the few important interview questions that are generally asked by an employer for the job of an Oracle Database Administrator.