interview questions

Oracle Database Questions & Answers 3

61. What constitute an ORACLE Instance ? SGA and ORACLE background processes constitute an ORACLE instance. (or) Combination of memory structure and background process. 62. What is SGA ? The System Global Area (SGA) is a shared memory region allocated by ORACLE that contains data and control information for one ORACLE instance. 63. What are […]

Oracle Database Questions & Answers 2

What is Network Database link ? Network database link is created and managed by a network domain service. A network database link can be used when any user of any database in the network specifies a global object name in a SQL statement or object definition. What is Data Block ? ORACLE database’s data is […]