MySql VS PostGress Day-1F

Which of the following databases is often considered more feature-rich for complex queries?

• MySQL

• PostgreSQL

• MongoDB

• SQLite

Which of the following is true about MySQL’s licensing?

• It is completely open-source.

• It is open-source but with commercial options.

• It is only available under a paid license.

• It is free only for small businesses.

In terms of performance, which database typically performs better with read-heavy workloads?

• PostgreSQL

• MySQL

• Both are equal

• Neither

Which of the following features is supported by MySQL but not by PostgreSQL?

• Full-text search

• JSONB

• Native replication

• InnoDB storage engine

Which of the following is the default storage engine for MySQL?

• MyISAM

• InnoDB

• NDB

• BDB

Which database has better horizontal scaling support out of the box?

• MySQL

• PostgreSQL

• Both have equal scaling.

• Neither

Which of the following is a feature of PostgreSQL but not MySQL?

• Support for multiple storage engines

• JSONB data type

• Use of the InnoDB storage engine

• Built-in clustering support

Which database has better out-of-the-box support for spatial data types?

• MySQL

• PostgreSQL

• Both support spatial data equally.

• Neither supports spatial data.

Which of the following does PostgreSQL support that MySQL does not?

• Full-text search

• Window functions

• Foreign keys

• JSON data types

MySQL offers support for ________________, which allows users to replicate data between master and slave servers.