ORACLE INTERVIEW QUESTION & ANSWERS
| 56. |
Define cluster? |
| |
- A cluster is a set of tables physically stored together as one table that shares a common column.
- If data in two or more tables is frequently retrieved together based on data in the common column, using a clustered table can be quite efficient.
- Tables can be accessed separately even though they are part of a clustered table.
|
| 57. |
What is the main difference between oracle,sql and sql server? |
| |
- Oracle is based on RDBMS(Relational Database Management System).
- SQL is Structured Query Language is a standard command set used to communicate with the relational database management system.
- SQL Server is another tool for RDBMS provided by MicroSoft.
|
| 58. |
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. |
| 59. |
What is the bootstrap instance? |
| |
This is the instance that is created under NT with the NT Instance Manager or with ORADIM80.EXE. This service allows you to start and stop the Oracle instance via the Oracle tools.
|
| 60. |
Which type of relationship associates one row in a given table with one or no rows in another table? |
| |
A one–to–one relationship associates one row in a given table with one or no rows in another table. |
