ORACLE INTERVIEW QUESTION & ANSWERS
| 51. |
Which type of table relationship associates more than one record in a given table with more than one record in another table? |
| |
A many–to–many relationship associates more than one record in a table with more than one record in another table. |
| 52. |
What is the Oracle Enterprise Manager? |
| |
The Oracle Enterprise Manager is the new graphical administration tool designed to help the DBA manage one or more Oracle systems. |
| 53. |
What is an SID? |
| |
The SID is the system identifier. This environment variable is used to determine which database to connect to. |
| 54. |
What are the duties of an Oracle DBA? |
| |
Duties of a DBA might include - Software and hardware installation
- Configuration of new hardware and software
- Security, performance tuning
- Backup and recovery
- Routine maintenance
- Troubleshooting
- Failure recovery.
|
| 55. |
What Oracle object is used for read consistency? |
| |
The rollback segments are used for read consistency. |
