Sunday 8 February 2015

20 TOP Database Architecture Interview Questions and Answers

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

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

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

3. What are Oracle Schema Objects?
Schema objects are the logical structures that directly refer to the databases data. Schema objects include tables, views, sequences, synonyms, indexes, clusters, database triggers, procedures, functions packages and database links.

4. What is an Oracle Data Block?
ORACLE database's data is stored in data blocks. One data block corresponds to a specific number of bytes of physical database space on disk.
Oracle database consists of logical storage place which is called as blocks and the bytes in a block is set through DB_BLOCK parameter in parameter file

5. Can objects of the same Schema reside in different tablespaces?
Yes objects of the same Schema reside in different tablespaces
More Questions & Answers :-
Part1  Part2  Part3  Part4

No comments:

Post a Comment