Sunday 8 February 2015

Technical round 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.

16. What is an oracle database schema?
A schema is collection of database objects of a User.
A schema is collection of database objects of an user and is used synonym of an user.
Schema name = user name

17. What is an Oracle Data Segment?
Each Non-clustered table has a data segment. All of the table's 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 stored in the cluster's data segment.
More Questions & Answers :-
Part1  Part2  Part3  Part4

No comments:

Post a Comment