Topic : Architecture

What is Oracle table?


Answer :

A table is the basic unit of data storage in an Oracle database.
The tables of a database hold all of the user accessible data.
Table data is stored in rows and columns.

Show Answer Discuss

What are the collection types in oracle?


Answer :

Collection types are objects that contain multiple sets of values. There are two kinds of collection types:
varrays
object-type tables

Show Answer Discuss

What is the difference between a relation and a relationship?


Answer :

The difference between a relation and a relationship is that a relation is another name for a table; whereas a relationship is a way to correlate; or join; two or more tables.

Show Answer Discuss

Name two new features of Oracle8?


Answer :

New features of Oracle8 include partitioned tables; index-only tables; and improved parallelism.

Show Answer Discuss

What is the main component of an Oracle8 server?


Answer :

RDBMS

Show Answer Discuss