Q61.

Explain database sharding.

Q62.

What is database replication?

Q63.

What is database clustering?

Q64.

What is partition pruning?

Q65.

What is CTE (Common Table Expression)?

Q66.

What is recursive CTE?

Q67.

What is difference between CTE and subquery?

Q68.

How does indexing impact write performance?

Q69.

What is composite primary key?

Q70.

What is foreign key cascade delete?