- Home
- Interview Questions
- Oracle
26.
What does a Control file Contain ?
- A Control file records the physical structure of the database. It contains the following information.
- Database Name
- Names and locations of a database's files and redo log files.
- Time stamp of database creation.
27.
How to define Data Block size ?
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.
28.
What are the Characteristics of Data Files ?
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.
29.
What is Rollback Segment ?
A Database contains one or more Rollback Segments to temporarily store "undo" information.
30.
What is a timer?
Timer is an "internal time clock" that you can programmatically create to perform an action each time the times.
|
|
||||||||||||||||||||||||||||
