PostgreSQL Quiz - Multiple Choice Questions (MCQs)
Welcome to the PostgreSQL Quiz for beginners! This quiz will test your knowledge of fundamental PostgreSQL concepts through 40+ multiple-choice questions. Let's dive in!
PostgreSQL Quiz - Multiple Choice Questions (MCQs)
-
What is PostgreSQL?
- A. A NoSQL database
- B. A relational database management system (RDBMS)
- C. A programming language
- D. A web server
-
Which of the following is a key feature of PostgreSQL?
- A. Support for JSON
- B. Exclusively uses the MyISAM storage engine
- C. Proprietary software
- D. Limited to small datasets
-
Which command-line utility is used for interactive PostgreSQL operations?
- A. pgadmin
- B. psql
- C. pgsql
- D. adminsql
-
Which SQL command is used to create a new PostgreSQL database?
- A. NEW DATABASE
- B. ADD DATABASE
- C. CREATE DATABASE
- D. DATABASE CREATE
-
How do you add a comment in SQL in PostgreSQL?
- A. /* Comment Here */
- B. // Comment Here
- C. -- Comment Here
- D. # Comment Here
-
Which data type in PostgreSQL can be used to store binary data?
- A. CHAR
- B. BINARY
- C. BYTEA
- D. DATA_BYTE
-
Which command in PostgreSQL is used to list all the available databases?
- A. SHOW DATABASES;
- B. \ld
- C. \l
- D. DISPLAY DATABASES;
-
Which keyword is used in PostgreSQL to define a primary key constraint?
- A. PRIMARY
- B. KEY
- C. UNIQUE
- D. PRIMARY KEY
-
Which PostgreSQL function can be used to obtain the current date and time?
- A. GET_TIMESTAMP()
- B. CURRENT_TIMESTAMP
- C. NOW_DATE_TIME()
- D. FETCH_DATETIME()
-
What is the maximum length of a table name in PostgreSQL?
- A. 32 characters
- B. 64 characters
- C. 128 characters
- D. 256 characters
-
Which PostgreSQL function returns the number of characters in a string?
- A. STRLEN()
- B. LENGTH()
- C. CHAR_COUNT()
- D. NUMCHAR()
-
What does the SERIAL keyword in PostgreSQL do?
- A. Creates a series of numbers
- B. Creates an auto-increment integer column
- C. Serializes a table for export
- D. Links tables in a series
-
In which language is PostgreSQL written?
- A. Python
- B. Java
- C. C
- D. Ruby
-
Which of the following is NOT a valid backup option for PostgreSQL?
- A. pg_dump
- B. pg_restore
- C. pg_backup
- D. pg_basebackup
-
Which command can be used to see the query plan for a statement without executing it?
- A. EXPLAIN
- B. DESCRIBE
- C. QUERY PLAN
- D. INSPECT
-
Which PostgreSQL feature allows for partitioning tables?
- A. Table Slicing
- B. Table Mapping
- C. Table Segmentation
- D. Table Inheritance
-
How do you retrieve the version of the PostgreSQL server you're connected to?
- A. SHOW VERSION();
- B. SELECT version();
- C. RETRIEVE VERSION;
- D. SELECT @version;
-
Which command-line utility is used for administrative tasks like creating, deleting, and maintaining PostgreSQL databases?
- A. pgadmin
- B. pgsql
- C. psql
- D. createdb and dropdb
-
Which datatype is used in PostgreSQL to store IPv4 and IPv6 addresses?
- A. IP
- B. NET_ADDR
- C. INET
- D. NETWORK
-
Which command can be used to list all the tables in the current PostgreSQL database?
- A. \tables
- B. \l
- C. \dt
- D. LIST TABLES;
-
Which of the following is NOT a locking mechanism in PostgreSQL?
- A. Advisory Locks
- B. Tuple Locks
- C. Transaction Locks
- D. Segment Locks
Answer: D. Segment Locks
-
PostgreSQL is often referred to as an ORDBMS. What does the "OR" stand for?
- A. Operational Relational
- B. Object-Relational
- C. Organized Record
- D. Open-Resource
Answer: B. Object-Relational
-
How would you retrieve unique values from a column named "names" in a table called "users"?
- A. SELECT DISTINCT(names) FROM users;
- B. UNIQUE SELECT names FROM users;
- C. SELECT names UNIQUE FROM users;
- D. GET DISTINCT names FROM users;
Answer: A. SELECT DISTINCT(names) FROM users;
-
Which function would you use to obtain the current user name in PostgreSQL?
- A. GET_USER();
- B. CURRENT_USER();
- C. USER_NAME();
- D. CURRENT_USER;
Answer: B. CURRENT_USER();
-
Which command will allow you to switch to a different database named 'testdb' in the psql interface?
- A. USE testdb;
- B. \c testdb;
- C. SWITCH testdb;
- D. SELECT DATABASE testdb;
Answer: B. \c testdb;
-
What is the primary role of the WAL in PostgreSQL?
- A. Web Access Layer
- B. Write Ahead Logging
- C. Write After Load
- D. Workload Allocation Logic
Answer: B. Write Ahead Logging
-
Which of the following data types would be best for storing monetary values in PostgreSQL?
- A. FLOAT
- B. INTEGER
- C. MONEY
- D. DECIMAL
Answer: C. MONEY
-
What is the purpose of the VACUUM command in PostgreSQL?
- A. To clean and optimize the database
- B. To backup the database
- C. To restore the database
- D. To migrate data
Answer: A. To clean and optimize the database
-
Which of these is a PostgreSQL tool for creating a physical backup?
- A. pg_dump
- B. pg_backup
- C. pg_basebackup
- D. pg_clone
Answer: C. pg_basebackup
-
How do you concatenate two columns in PostgreSQL?
- A. USING
- B. JOIN
- C. +
- D. ||
Answer: D. ||
-
Which of these commands is used to remove a table from PostgreSQL?
- A. DELETE TABLE
- B. DROP TABLE
- C. REMOVE TABLE
- D. DISCARD TABLE
Answer: B. DROP TABLE
-
What does the CASCADE option do when used with the DROP TABLE command?
- A. Drops the table and all associated indexes
- B. Drops the table and any dependent objects
- C. Recreates the table after dropping
- D. Ignores any dependencies and drops the table
Answer: B. Drops the table and any dependent objects
-
What is the default port on which PostgreSQL listens?
- A. 3306
- B. 8080
- C. 5432
- D. 80
Answer: C. 5432
-
Which command in psql will list all the databases?
- A. \list
- B. \databases
- C. \showdb
- D. \db
Answer: A. \list
-
How would you describe the structure of a table named "employees" using psql?
- A. \d employees
- B. DESCRIBE employees;
- C. \tableinfo employees
- D. \struct employees
Answer: A. \d employees
-
If you want to see the list of users and their roles in psql, which command would you use?
- A. \users
- B. \roles
- C. \du
- D. \listusers
Answer: C. \du
-
Which psql command would you use to turn on the timing of commands?
- A. \timeon
- B. \timing
- C. \showtime
- D. \settime
Answer: B. \timing
-
How would you quit out of the psql interface?
- A. \exit
- B. QUIT;
- C. \q
- D. LEAVE;
Answer: C. \q
-
Which command is used to display the history of executed SQL commands in psql?
- A. \history
- B. \h
- C. \s
- D. \log
Answer: C. \s
-
What does the psql command \e do?
- A. Exits the psql shell
- B. Opens the last SQL command in an editor
- C. Executes the SQL command
- D. Echoes the SQL command
Answer: B. Opens the last SQL command in an editor