Interested to Buy Any Domain ? << Click Here >> for more details...
What does a Control file Contain ?
- 2 Answers
- 8137 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / orawhiz
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 redolog files.
Time stamp of database creation.
| Is This Answer Correct ? | 9 Yes | 0 No |
The control files of a database store the status of the
physical structure of the database. The control file is
absolutely crucial to database operation. It contains (but
is not limited to) the following types of information:
* Database information (RESETLOGS SCN and their time
stamp)
* Archive log history
* Tablespace and datafile records (filenames, datafile
checkpoints, read/write status, offline or not)
* Redo threads (current online redo log)
* Database's creation date
* database name
* current archive log mode
* Log records (sequence numbers, SCN range in each log)
* RMAN catalog
* Database block corruption information
* Database ID, which is unique to each DB
| Is This Answer Correct ? | 7 Yes | 1 No |
In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?
What is Index and different types of Indexes?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
what is IDE,DMV in sql server?
What is the data type of dual table?
query to find the maximum no persons with same age(age colomn) from emp table
Please explan Why static query is more faster than dynamic query ?
i can create a view with two columns from emp table,, later i need to add one more emp column to existing view.. what is query similarly add one more column to existing primary key constraint.. please give me the solutions
what is mean by prmary key and foreign key and how can we diffrentiate that? Please answer me. Advance thanks.
What are the basic element of Base configuration of an oracle Database ?
A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?
Explain what are the advantages of views?
Oracle General 
