What do you understand by the term 'system change number (scn)'?
- 1 Answers
- 686 Views
- I also Faced
- E-Mail Answers
Answer / Ms. Vidushi Bhatnagar
System Change Number (SCN) is a unique identifier assigned to each database operation in Oracle. SCNs allow for efficient tracking of data changes and facilitate recovery processes during a rollback or recovery operation.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is oracle dba role?
How can you determine the space left in a file system?
Do you need a commit after ddl statements?
Discuss row chaining, how does it happen? How can you reduce it?
What are the skills required for oracle dba?
How many redo logs should you have and how should they be configured for maximum recoverability?
How do you generate file output from sql?
What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?
Explain the wait events in statspack report 'db sequential real'?
Explain the wait events in statspack report 'db scattered read'?
Is oracle dba in demand?
You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.
Oracle General 
