 Related Questions ORACLE database is comprised of three types of files. One or more Data files, two are more Redo Log files, and one or more Control files. Latest Answer : The components of a Physical Structure of a Database are as Follows:1.Control Files2.Redolog Files3.Data Files. ... An Extent is a specific number of contiguous data blocks, obtained in a single allocation, and used to store a specific type of information. Latest Answer : An extent is a logical unit of database storage space allocation made up of a number of contiguous data blocks. One or more extents in turn make up a segment. When the existing space in a segment is completely used, Oracle allocates a new extent for the ... A Database contains one or more Rollback Segments to temporarily store "undo" information. Latest Answer : It stores your uncommited temporart data. ex. If you do any insert/update/delete and you won't commit it is written in rollback segment. ... Rollback Segments are used :To generate read-consistent database information during database recovery to rollback uncommitted transactions for users. Latest Answer : Rollback Segment Stores Undo Information and are used for the following purposes.1. To undo the previous command2. For read consistency and3. For crash recovery. ... The set of Redo Log files for a database is collectively known as the database's redo log. Latest Answer : Oracle maintains logs of all transactions against the databse. These transactions are recorded in files called Online Redo log files.These logs are used to recover the database's transaction in their proper order in the evnt of database crash. The ... The Primary function of the redo log is to record all changes made to data. Latest Answer : Oracle maintains logs of all transactions against the databse. These transactions are recorded in files called Online Redo log files.These logs are used to recover the database's transaction in their proper order in the evnt of database crash. The redo ... The Information in a redo log file is used only to recover the database from a system or media failure prevents database data from being written to a database's data files. Latest Answer : Oracle maintains logs of all transactions against the databse. These transactions are recorded in files called Online Redo log files.These logs are used to recover the database's transaction in their proper order in the evnt of database crash. The redo ... A Control file records the physical structure of the database. It contains the following information.Database NameNames and locations of a database's files and redolog files.Time stamp of database Latest Answer : The controlfile contains :1. Name and Location of Datafiles, Redo Logfiles.2. Timestamp of Database Creation.3. Current log sequence number is recorded when log switches are occur.4. Checkpoint information is recorded as checkpoints are made.5. Database ... When an instance of an ORACLE database is started, its control file is used to identify the database and redo log files that must be opened for database operation to proceed. It is also used in database Latest Answer : Uses of a Controlfile:1.It is used to identify the names and locations of datafiles,redologfiles.2.Redo History is recorded during log switches.3.Checkpoint information is recorded at ckpts are made.4.Timestamp of database creation.5.Database information ... The data dictionary of an ORACLE database is a set of tables and views that are used as a read-only reference about the database.It stores information about both the logical and physical structure of the Latest Answer : Data Dictionary is a read-only set of tables that provides information about the database. in order to avoid the I/O cost, these data dictionary views are used ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 
0