PostgreSQL Essentials Quiz Quiz

1. PostgreSQL characteristics

   Which statement correctly describes PostgreSQL in terms of its key features?

   1. It is a closed source, object-oriented database
   2. It is only available for commercial use
   3. It only supports relational tables
   4. It is a powerful, open source, object-relational database system
   5. It is a lightweight in-memory database

2. Language used for development

   PostgreSQL was primarily written in which programming language?

   1. Java
   2. Ruby
   3. C
   4. C++
   5. Python

3. Original name of PostgreSQL

   What was the original name for PostgreSQL when it was first created?

   1. Ingres
   2. Pregress
   3. PreSQL
   4. Postgress
   5. Postgres

4. History of Postgres95

   Which of the following statements is true regarding Postgres95?

   1. It added support for SQL in 1994
   2. All of the above
   3. It facilitated the formation of the PostgreSQL Global Development Team
   4. None of the above
   5. It was released as Postgres95 in 1995

5. Listing psql commands

   If you want to see a complete list of commands in the PostgreSQL interactive terminal (psql), which command should you use?

   1. /help
   2. help
   3. $help
   4. u0026help
   5. ?help

6. Aborting a transaction

   Which syntax correctly aborts the current transaction in PostgreSQL?

   1. CANCEL TRANSACTION
   2. ABORT
   3. ABORT [ WORK | TRANSACTION ]
   4. ABORT [ TRANSACT ]
   5. ROLLBACK [ NOW ]

7. Renaming a procedural language

   To change the name of a procedural language, which statement should be used in PostgreSQL?

   1. ALTER LANGUAGE name RENAME TO new_name
   2. UPDATE LANGUAGE name RENAME TO new_name
   3. UPDATE LANG name TO new_name
   4. RENAME LANGUAGE name TO new_name
   5. MODIFY LANGUAGE name TO new_name

8. Modifying triggers

   What does the command 'ALTER TRIGGER name ON table RENAME TO new_name' accomplish in PostgreSQL?

   1. Deletes an existing trigger
   2. Disables a trigger
   3. Updates the logic of a trigger
   4. Changes the name of a trigger
   5. Inserts a new trigger

9. Purpose of ANALYZE command

   What is the main purpose of running the command 'ANALYZE [ VERBOSE ] [ table [ (column [, ...] ) ] ]' in PostgreSQL?

   1. Deletes all records from a table
   2. Starts a transaction block
   3. Backs up the database schema
   4. Collects statistics about a database
   5. Drops a database

10. Numeric data types

    Which of the following represents the types of numeric integers supported by PostgreSQL?

    1. Only four-byte integers
    2. Two-byte, four-byte, and eight-byte integers
    3. Only eight-byte integers
    4. Two-byte and three-byte integers
    5. Only two-byte integers

11. Currency data type

    Which PostgreSQL data type is specifically used to store amounts of money with fixed fractional precision?

    1. binary
    2. money
    3. currency
    4. character
    5. numeric

12. Boolean value states

    Besides true and false, which third logical state can the PostgreSQL Boolean data type represent?

    1. error
    2. unset
    3. null
    4. undefined
    5. unknown

13. Geometric data types

    Geometric data types in PostgreSQL are designed to represent which kind of data?

    1. Enumerations
    2. Boolean values
    3. Two-dimensional spatial objects
    4. One-dimensional values
    5. String literals

14. Network address types

    Does PostgreSQL provide data types for storing IPv4, IPv6, and MAC addresses?

    1. TRUE
    2. Only IPv4
    3. Sometimes
    4. Only IPv6
    5. FALSE

15. Bit string types

    How many main types of SQL bit types are there in PostgreSQL?

    1. 5
    2. 2
    3. 6
    4. 4
    5. 3