Skip to main content

Posts

Showing posts from February, 2020

INTERVIEW QUESTIONS

ARCHITECTURE What is oracle database? Oracle Database is a relational database management system (RDBMS) which is used to store and retrieve the large amounts of data. Oracle Database has physical and logical structures. Logical structures and physical structures are separated from each other. What is schema? Schema is a logical collection of database objects of a user. For example tables, procedures, pkgs, functions, triggers, database links etc. What is a Tablespace? It is a logical area of storage in a database that directly correspondents to one more physical datafiles. What is a Control File? Control files record control information of the all the files within the database. They used to maintain internal consistency and play a vital role during database recovery. Oracle automatically modifies the control files which users cannot edit. What is a Segment? A segment is a collection of extents which is used for storing a specific data structure and r