⟩ Explain Atomicity?
Atomicity: This property of a transaction ensures that a transaction either completely or does not happen at all. E.g. transferring money from one account to another.
Atomicity: This property of a transaction ensures that a transaction either completely or does not happen at all. E.g. transferring money from one account to another.
Explain Indexes disadvantages?
Do you know Clustered and Non-Clustered Index?
Tell me the difference between clustered and non-clustered index?
What is Unique Index?
Explain the purpose of indexes?
determine when an index is appropriate?
Write down the syntax and an example for create, rename and delete index?
Explain the types of indexes?
Can you explain important index characteristics?
Why is the need for data conversion transformations?