Instiq

1General knowledge

Practice questions →Glossary →
  • 1.1General Characteristics of OSS-DB

    Survey the full feature set of PostgreSQL, the nature of OSS (open source software) and the PostgreSQL license, and how the community operates and how to participate in it. Also cover the distinction between major version and minor version, the roughly annual release cycle, the support policy (updates for five years), and how to submit a bug report to the community.

  • 1.2General Knowledge of Relational Databases

    Organize the basic concepts of the relational data model (tables, rows, columns, primary keys, foreign keys) and the role a DBMS plays. Cover general knowledge of SQL, and its three-way classification by purpose: DDL (data definition language), DML (data manipulation language), and DCL (data control language). Also cover the idea of normalization in database design.