ORACLE INTERVIEW QUESTIONS & ANSWERS
| 21. |
What is the difference between DBMS and RDBMS? |
| |
A database management system (DBMS) consists of a collection of interrelated data and a set of programs to access that data.
A Relational Database Management System(RDBMS) is a DBMS that is relational in name. This means that the internal workings access data in a relational manner. Oracle is
an RDBMS. |
| 22. |
What are the different Oracle database objects? |
| |
There are different types of Oracle database objects are : - Tables
- Views
- Indexes
- Synonyms
- Sequences
- Tablespaces
|
| 23. |
What is SQL*Plus? |
| |
SQL*Plus is the ad-hoc user interface tool for the Oracle RDBMS. With SQL*Plus, you can connect into the RDBMS and run SQL commands and PL SQL programs. This is the primary nonapplication
interface into the Oracle RDBMS. |
| 24. |
What is the most important duty of an Oracle DBA? |
| |
The most important duty of an Oracle DBA is to maintain the integrity and reliability of the user's data. This means keeping the system running and properly backed up. |
| 25. |
Name three Oracle utilities? |
| |
Oracle utilities include the SQL*Loader, the Export utility and the Import utility.
|
