CREST CPSA (Practitioner Security Analyst)

Databases

14 practice questions with explanations — 15 free to try

1 of these 14 questions are in the free 15-question taster · the full topic is part of Premium

PassNova has 14 CREST CPSA (Practitioner Security Analyst) practice questions on Databases, each with a clear explanation. A 15-question taster is free with no sign-up; the full bank is part of PassNova Premium. Updated for 2026.

Sample questions

Databases: example questions & answers

1 worked example with answers and explanations below. Try 15 CREST CPSA (Practitioner Security Analyst) questions free in the browser; the full 14-question Databases bank is part of PassNova Premium.

  1. On which default TCP port does Microsoft SQL Server listen for client connections?

    • A1433✓
    • B3306
    • C5432
    • D1521

    Answer: Microsoft SQL Server's default instance listens on TCP 1433 (with the SQL Server Browser on UDP 1434). Oracle's listener defaults to 1521, MySQL to 3306 and PostgreSQL to 5432.

Start practising Databases →