What is the use of Redo Log Information ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / orawhiz
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
Is This Answer Correct ? | 0 Yes | 1 No |
why can't we assign not null constraint as table level constraint
What is a Public Synonyms ?
How to define an anonymous block?
How to get execution statistics reports on query statements?
17. Display the order number and average item cost for each order.
Explain user account with reference to oracle.
Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
Define Normalization with example?
What do you understand by database schema and what does it hold?
How can you use check constraints for self referential integrity?
Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.