Answer Posted / rajendra biswal
A log switch occurs when one online redo log has been
filled and the next online redo log is going to be filled.
A log switch always triggers a checkpoint.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What are the various types of relationships in database? Define them.
Compare non-clustered and clustered index
What the default privileges which get assigned ?
Explain the components of rdbms?
Explain atomicity and aggregation?
How do databases help businesses?
Give the cobol definition of a varchar field 177 when can an insert of a new primary key value threaten referential integrity?
What do you understand by functional dependency and transitive dependency in dbms?
What is Normalization and its different forms?
Explain what are service-specific middleware?
How to improve query performance using index hunting?
What is the difference between delete and truncate command in dbms?
What do you mean by checkpoints in dbms?
Is a server a database?
What is an optimization and performance tuning and how does it really work in practical projects?