Category Archives: Oracle Developer Interview Questions

What is the use of Redo Log Information? | Oracle Developer Questions

The Information in a redo log file is used only to recover the database from a system or media failure prevents database data from being written to a databases data files.

Posted in Oracle Developer Interview Questions | Leave a comment

What is the function of Redo Log? | Oracle Developer Questions

The Primary function of the redo log is to record all changes made to data.

Posted in Oracle Developer Interview Questions | Leave a comment

What is Redo Log? | Oracle Developer Questions

The set of Redo Log files for a database is collectively known as the databases redo log.

Posted in Oracle Developer Interview Questions | Leave a comment

Explain What are the Characteristics of Data Files? | Oracle Developer Questions

A data file can be associated with only one database.Once created a data file cant change size.

Posted in Oracle Developer Interview Questions | Leave a comment

What is Data File? | Oracle Developer Questions

Every ORACLE database has one or more physical data files. A databases data files contain all the database data. The data of logical database structures such as tables and indexes is physically stored in the data files allocated for a … Continue reading

Posted in Oracle Developer Interview Questions | Leave a comment

What is a Temporary Segment? | Oracle Developer Questions

Temporary segments are created by ORACLE when a SQL statement needs a temporary work area to complete execution. When the statement finishes execution, the temporary segment extents are released to the system for future use.

Posted in Oracle Developer Interview Questions | Leave a comment

Explain What are the uses of Rollback Segment? | Oracle Developer Questions

Rollback Segments are used : To generate read-consistent database information during database recovery to rollback uncommitted transactions for users.

Posted in Oracle Developer Interview Questions | Leave a comment

What is Rollback Segment? | Oracle Developer Questions

A Database contains one or more Rollback Segments to temporarily store “undo” information.

Posted in Oracle Developer Interview Questions | Leave a comment

Explain an Index Segment? | Oracle Developer Questions

Each Index has an Index segment that stores all of its data.

Posted in Oracle Developer Interview Questions | Leave a comment

Explain What does a Control file Contain? | Oracle Developer Questions

A Control file records the physical structure of the database. It contains the following information. Database Name, Names and locations of a databases files and redolog files. ,Time stamp of database creation.

Posted in Oracle Developer Interview Questions | Leave a comment