One thing is not clear. In question 1 one of correct answers is “Heap tables last in memory till you restart your database.”.
What does it mean, heap tables, as said on one of lessons in Educative, are just the tables which don’t have a clustered index in them, why shouldn’t they last after the restart?
Thanks!
Course: https://www.educative.io/collection/5352985413550080/6335716377231360
Lesson: https://www.educative.io/collection/page/5352985413550080/6335716377231360/4565491877150720
Course: https://www.educative.io/collection/5352985413550080/6335716377231360
Lesson: https://www.educative.io/collection/page/5352985413550080/6335716377231360/4565491877150720