Data Modeling with ER Model - Technical MCQs

Q1:

In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) ________ entity.

A parent

B child

C instance

D subtype

ANS:A - parent

Instance:
The combination of the system global area (SGA) and background processes. An instance is associated with one and only one database. In an Oracle Real Application Clusters configuration, multiple instances access a single database simultaneously.

SGA:
System global area. A group of shared memory structures that contain data and control information for one Oracle database instance.

Background process:
A process that consolidates functions that would otherwise be handled by multiple Oracle programs running for each client process. The background processes asynchronously perform I/O and monitor other Oracle processes.