(Continued from previous part...)

420. What is the use of FILE option in IMP command?

The name of the file from which import should be performed.

421. What is a Shared SQL pool?

The data dictionary cache is stored in an area in SGA called the Shared SQL Pool. This will allow sharing of parsed SQL statements among concurrent users.

422. What is hot backup and how it can be taken?

Taking backup of archive log files when database is open. For this the ARCHIVELOG mode should be enabled. The following files need to be backed up. All data files. All Archive log, redo log files. All control files.

423. List the Optional Flexible Architecture (OFA) of Oracle database? How can we organize the tablespaces in Oracle database to have maximum performance?

1. SYSTEM - Data dictionary tables.
2. DATA - Standard operational tables.
3. DATA2- Static tables used for standard operations
4. INDEXES - Indexes for Standard operational tables.
5. INDEXES1 - Indexes of static tables used for standard operations.
6. TOOLS - Tools table.
7. TOOLS1 - Indexes for tools table.
8. RBS - Standard Operations Rollback Segments,
9. RBS1,RBS2 - Additional/Special Rollback segments.
10. TEMP - Temporary purpose tablespace
11. TEMP_USER - Temporary tablespace for users.
12. USERS - User tablespace.

424. How to implement the multiple control files for an existing database?

1. Shutdown the database
2. Copy one of the existing control file to new location
3. Edit Config ora file by adding new control filename
4. Restart the database.

425. What is advantage of having disk shadowing/ Mirroring?

Shadow set of disks save as a backup in the event of disk failure. In most Operating System if any disk failure occurs it automatically switches over to a working disk. Improved performance because most OS support volume shadowing can direct file I/O request to use the shadow set of files instead of the main set of files. This reduces I/O load on the main set of disks.

426. How will you force database to use particular rollback segment?

SET TRANSACTION USE ROLLBACK S

(Continued on next part...)