|
Earn Money Trading Forex Online Paramount Airways Free Data Recovery Cargo Job Portal HSBC Investment Management Cheap Web Hosting Make Trip Cheap Air Travel Leisure Hotel Free Air Travel Mutual Fund Informations Cheapest Cellular Plan Free Sexy Indians Call Center Software Hot Indian |
Programming Help |
Homework Help |
Counseling Astrology Advice | Tarot Advice | Parenting Dating Advice | Love Advice | Divorce Advice Legal Advice | Debt Advice | Career Advice A database contains one or more rollback segments to temporarily store "undo" information. 42. Explain the uses of rollback segment? To generate read-consistent database information during database recovery and to rollback uncommitted transactions by the users. 43. Explain a temporary segment? Temporary segments are created by Oracle when a SQL statement needs a temporary work area to complete execution. When the statement finishes execution, the temporary segment extents are released to the system for future use. 44. Explain a datafile? Every Oracle database has one or more physical data files. A database's data files contain all the database data. The data of logical database structures such as tables and indexes is physically stored in the data files allocated for a database. 45. Explain 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. 46. Explain a redo log? The set of redo log files for a database is collectively known as the database redo log. 47. Explain the function of redo log? The primary function of the redo log is to record all changes made to data. 48. Explain the use of redo log information? 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. 49. What does a control file contains? - Database name - Names and locations of a database's files and redolog files. - Time stamp of database creation. 50. Explain the use of control file? 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 recovery. |
Earn Money Trading Forex Online Paramount Airways Free Data Recovery Cargo Job Portal HSBC Investment Management Cheap Web Hosting Make Trip Cheap Air Travel Leisure Hotel Free Air Travel Mutual Fund Informations Cheapest Cellular Plan Free Sexy Indians Call Center Software Hot Indian |