SQL and PL/pgSQL Quiz

What is the purpose of the UNION operator in SQL?

• To concatenate two strings

• To perform mathematical union operation on two sets

• To create a new table by merging two existing tables

• To combine the result sets of two or more SELECT statements into a single result set

Which operator is used to combine the result sets of two or more SELECT statements in PostgreSQL?

• UNION

• JOIN

• INTERSECT

• EXCEPT

What is PL/pgSQL?

• A graphical user interface for PostgreSQL

• A command-line interface for PostgreSQL

• A procedural programming language for writing PostgreSQL functions

• A query language for PostgreSQL

Which statement is used to create a function in PL/pgSQL?

• DECLARE FUNCTION

• CREATE FUNCTION

• DEFINE FUNCTION

• FUNCTION

What is the purpose of variables in PL/pgSQL?

• To store and manipulate data within a function

• To define the structure of a table

• To perform mathematical calculations

• To create temporary tables

Which keyword is used to declare a variable in PL/pgSQL?

• SET

• CREATE

• DECLARE

• DEFINE

What is the syntax for calling a function in PL/pgSQL?

• SELECT function_name(arguments)

• EXECUTE function_name(arguments)

• CALL function_name(arguments)

• RUN function_name(arguments)

Which statement is used to return a value from a PL/pgSQL function?

• RETURN

• OUTPUT

• RESULT

• VALUE

What is the purpose of the UNION operator in PostgreSQL?

• To combine the result sets of two or more SELECT statements into a single result set

• To perform mathematical union operation on two sets

• To create a new table by merging two existing tables

• To concatenate two strings

Which operator is used to combine the result sets of two or more SELECT statements in SQL?

• UNION

• JOIN

• INTERSECT

• EXCEPT