Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / abitha
Control files of a database store the status of the
physical structure of the database. The control file is
absolutely crucial to database operation.
Control file contains:
Database information
Archive log history
Redo threads
database name
Current archive log mode
Database's creation date etc.,
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain about the analyze command in oracle?
What do you mean by cdb and pdb in oracle 12c?
What is system tablespace?
What are the differences between primary key and unique key?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
Explain mutating triggers.
What is the maximum number of triggers that can be applied to a single table?
What are the roles of dba?
How to assign query results to variables?
How to display employee records who gets more salary than the average salary in the department?
Explain an extent?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
What is Redo Log Buffer in Oracle?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
How to export data with a field delimiter?
