easy5 pts · first answer countssql

Row order without ORDER BY

A report always showed rows in insert order, but after a VACUUM and an index change the order changed. What is true?

A.The database is corrupted and must be restoredB.Without ORDER BY, SQL does not guarantee any row orderC.Rows are always returned by primary key unless VACUUM runsD.Indexes control the default display order of a table

← UNION vs UNION ALL Why add a read replica →