Setup & Install Databases

Question 1

How can you verify a successful MySQL server installation from the terminal?

A.

A) `show databases;`

B.

B) `mysql --version`

Explanation: The command `mysql --version` displays the installed version, confirming the server setup.

C.

C) `use mysql;`

D.

D) `root -p`

Question 2

Which user account is created during MySQL installation and requires a custom password?

A.

A) Admin user

B.

B) Root user

Explanation: The root user is the admin account set up with a memorable password to access the MySQL prompt.

C.

C) Guest user

D.

D) System user

Question 3

What does the **MySQL prompt** (mysql>) indicate?

A.

A) Terminal dollar prompt ($) for OS commands

B.

B) Successful login to the MySQL server

Explanation: The mysql> prompt appears after logging in with `mysql -u root -p`, allowing SQL command execution.

C.

C) Connection to MySQL Workbench only

D.

D) Default database selection

Question 4

Which tool is recommended for interactive query execution after server installation?

A.

A) Terminal command line exclusively

B.

B) Root password manager

C.

C) Default system databases

D.

D) MySQL Workbench

Explanation: MySQL Workbench is a GUI tool that connects to the server instance for easier query practice.`

Question 5

During **PostgreSQL** installation, what should you do with the **Stack Builder** option?

A.

A) Always select it for required drivers

B.

B) Use it to set the database password

C.

C) Deselect it as it's optional for extra tools

Explanation: **Stack Builder** provides optional additional drivers and tools, so it can be deselected during setup.

D.

D) Select it to change the default port

Question 6

Which tool is included with **PostgreSQL** installation to access the server via a GUI, similar to **MySQL Workbench**?

A.

A) **pgAdmin 4**

Explanation: **pgAdmin 4** is the GUI tool for connecting to the **PostgreSQL** server and default "postgres" database.

B.

B) **MySQL Workbench**

C.

C) **Stack Builder**

D.

D) **companyDB**

Question 7

Which database remains the primary focus for the course despite **PostgreSQL** being available?

A.

A) **companyDB**

B.

B) **postgres**

C.

C) **MySQL**

Explanation: **MySQL** (with **MySQL Server** and **MySQL Workbench**) is used most frequently; **PostgreSQL** is optional.

D.

D) **pgAdmin 4** database

📝 Setup & Install Databases

Quiz Complete!