Database containers for local development in Docker - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the command to start a PostgreSQL container named 'pg_local' with the latest image.

Docker

docker run --name pg_local -e POSTGRES_PASSWORD=mysecretpassword -d [1]

Drag options to blanks, or click blank then click option'

Amongo:latest

Bpostgres:latest

Cmysql:latest

Dredis:latest

Attempts:

3 left

💡 Hint

Common Mistakes

Using a non-PostgreSQL image like MySQL or MongoDB.

The postgres:latest image is used to run a PostgreSQL database container.

2fill in blank

medium

Complete the command to map the container's port 5432 to the host's port 5433.

Docker

docker run -p [1]:5432 postgres

Drag options to blanks, or click blank then click option'

A5433

B5432

C3306

D27017

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping the ports or using default container port as host port.

Mapping host port 5433 to container port 5432 allows accessing PostgreSQL on port 5433 locally.

3fill in blank

hard

Fix the error in the command to persist PostgreSQL data in a Docker volume named 'pgdata'.

Docker

docker run -v [1]:/var/lib/postgresql/data postgres

Drag options to blanks, or click blank then click option'

Apgdata:/var/lib/postgresql/data

B/pgdata

Cpgdata

Dpgdata_volume

Attempts:

3 left

💡 Hint

Common Mistakes

Using a path instead of a volume name, or adding extra slashes.

The volume name pgdata should be specified without slashes to mount correctly.

4fill in blank

hard

Fill both blanks to run a MySQL container with root password 'rootpass' and expose port 3307 on host.

Docker

docker run -e [1]=rootpass -p [2]:3306 mysql

Drag options to blanks, or click blank then click option'

AMYSQL_ROOT_PASSWORD

B3306

C3307

DMYSQL_PASSWORD

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong environment variable or wrong port mapping.

Use MYSQL_ROOT_PASSWORD to set root password and map host port 3307 to container port 3306.

5fill in blank

hard

Fill all three blanks to create a Docker Compose service for PostgreSQL with volume and port mapping.

Docker

services:
  db:
    image: [1]
    ports:
      - "[2]:5432"
    volumes:
      - [3]:/var/lib/postgresql/data

Drag options to blanks, or click blank then click option'

Apostgres:13

B5433

Cpgdata

Dmysql:8

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong image, port, or volume name.

The service uses postgres:13 image, maps host port 5433 to container 5432, and mounts volume pgdata.