Skip to main content

Posts

QUERIES ORACLE

OBJECT_RELATED ------------------------- select owner,object_name,object_type, status from dba_objects as of timestamp to_date('10/25/2018 00:00:00','mm/dd/yyyy hh24:mi:ss') where object_name = 'TEST'  and OWNER='TEST';

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