What are the limitations of DBMS, and how is NewSQL related to SQL and NoSQL?

From the Islami Bank Engineer March 2025 – Written (BUET) exam, question 1 of 7.