Answer Posted / ram kumar
it store the data and information for the databae
redo log support archieve the data any data can be change
the database .it recover of the old data base in formation
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between formal parameters and actual parameters?
Explain how are indexes update?
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.
Explain table?
How to add a new column to an existing table in oracle?
How to define a record variable to store a table row?
State the various uses of dbcc command?
How can we force the database to use the user specified rollback segment?
Explain what are the type of synonyms?
Why does Oracle not permit the use of PCTUSED with indexes?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
How would you change old and new values in an insert, delete and update triggers?
Name the various constraints used in oracle?
What do you mean by a database transaction & what all tcl statements are available in oracle?
How to commit the current transaction in oracle?