Chapter 4: databae objects

1. A table is a database object that holds your data.

Information about every is stored in the data dictionary; with this information, Oracle allows you to maintain data residing in your table.

2. A view allows you to see a customized selecction of one or more talbes, and it uses a SQL query that is stored in the database.

3. An index is a minicopy of a table. Index enttires for a table allow Oracle raqid access to the data in your datas.

4. A synonym is an altrenate name for an object in the database.

Think of a synonym as a nickname for an object --- somewhat like calling a woman named Margaret by the name Maggie instead.

5. Grants are privileges given out by owners of objects, allowing other users work with their data.

6. The data dictinary is maintained by Oracle and contains information relevant to the tables that reside in the database.

7. A role is a group of privilenges that are collected together and granted to users.

8. A remote databaes is an oracle install that runs on a computer diffenent that the one you may currently be logged.

9. A snapshot is a read-only copy of data stored in one or more tables.

Using Oracle scheduling features, the DBA instructs Oracle to regularly refresh a snapshot on a remote database from the contents of the data in the tables that server as the inputs to the snapshot.

10. contention occurs when two or more databases users are waiting for data or a resource required to perform a sort or CPU time to perform some calculation. closely hooked to Contention are situations that cause users to wait for another to complete their activity before they can take their turn using the resource in question.