Monday, 9 February 2015

Experienced Oracle Developer Interview Questions and Answers (Page 5)

Below are some important Oracle Developer interview questions which are asked in most MNC company interviews for beginners or professionals.

41. Explain a Data Segment?
Each Non-clustered table has a data segment. All of the tables data is stored in the extents of its data segment. Each cluster has a data segment. The data of every table in the cluster is

42. Explain an Index Segment?
Each Index has an Index segment that stores all of its data.

43. What is Rollback Segment?
A Database contains one or more Rollback Segments to temporarily store "undo" information.

44. Explain What are the uses of Rollback Segment?
Rollback Segments are used : To generate read-consistent database information during database recovery to rollback uncommitted transactions for users.

45. What is a Temporary Segment?
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.

46. What is Data File?
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 database.

47. Explain What are the Characteristics of Data Files?
A data file can be associated with only one database.Once created a data file cant change size.

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

49. What is the function of Redo Log?
The Primary function of the redo log is to record all changes made to data.

50. What is the use of Redo Log Information?
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.
More Questions & Answers :-
Page1  Page2  Page3  Page4  Page5  Page6

No comments:

Post a Comment