(Continued from previous part...)

87. Online & Offline TS

A TS can be online (accessible) or offline (not accessible). A TS can be offline to make portion of the db unavailable while allowing normal access for the remainder of the db to make administrative tasks easier.

88. Schema

Schema is a collection of objects. Schema Objects are the logical structures that directly refer to the db??s data. Schema objects includes tables, views, sequences, synonyms, stored procedures, indexes, clusters & db links. No relation between ts & schema. Objects in same schema can be in diff. ts & vice versa.

89. Index Clusters

Index Clusters are group of one or more tables physically stored together because they share common columns & are often used together. The related columns of the tables in a cluster is called cluster key. The data in a cluster key of an index cluster is store only once for multiple tables, so disk access time improves.

90. Index Clusters

Hash Clusters : Also cluster table data in a manner similar to normal cluster. A row is stored in a hash cluster based on the result of applying a hash function to the row??s cluster key value. All rows with the same hash key value are stored together on disk. Hash clusters are better than using indexed table or indexed clusters when a table is queried with equality queries. For such queries, the specified cluster key is hashed. The resulting hash key value points directly to the area on disk that stores the specified rows.

91. Database Links

Database Links is a name object that describes a path from one db to another. DB links are implicitly used when a reference is made to a global object name in a distributed db.

91. Data Blocks

At the finest level of granularity, an ORACLE db??s data is stored in data blocks. One data block corresponds to a specific number of bytes of physical db space on a disk. A data block size is specified when the db is created. A db uses & allocates free db space in ORACLE data blocks.

91. Data Blocks

At the finest level of granularity, an ORACLE db??s data is stored in data blocks. One data block corresponds to a specific number of bytes of physical db space on a disk. A data block size is specified when the db is created. A db uses & allocates free db space in ORACLE data blocks.

Every DBA should know something about the operating system that the database will be running on. The questions here are related to UNIX but you should equally be able to answer questions related to common Windows environments.

92. For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame?

Yes

93. Can a field be used in a report without it appearing in any data group?

Yes

94. The join defined by the default data link is an outer join yes or no?

Yes

(Continued on next part...)