Set - 1

Question 41 :

How are the index updates?

Answer :

Indexes are automatically maintained and used by Oracle. Changes to table data are automatically incorporated into all relevant indexes.


Question 42 :

What is a Tablespace?

Answer :

A database is divided into Logical Storage Unit called tablespace. A tablespace is used to grouped related logical structures together


Question 43 :

What is Rollback Segment ?

Answer :

A Database contains one or more Rollback Segments to temporarily store "undo" information.


Question 44 :

What are the Characteristics of Data Files ?

Answer :

A data file can be associated with only one database. Once created a data file can't change size. One or more data files form a logical unit of database storage called a tablespace.


Question 45 :

How to define Data Block size ?

Answer :

A data block size is specified for each ORACLE database when the database is created. A database users and allocated free database space in ORACLE data blocks. Block size is specified in INIT.ORA file and can't be changed latter.