Which of the following is the correct way to declare a variable of a composite type person in a PL/pgSQL function?

easy📝 Syntax Q3 of 15

PostgreSQL - Advanced Features

Which of the following is the correct way to declare a variable of a composite type person in a PL/pgSQL function?

ADECLARE p TYPE person;

BDECLARE p AS person;

CDECLARE p person;

DDECLARE p RECORD person;

Step-by-Step Solution

Solution:

Step 1: Understand variable declaration in PL/pgSQL
Variables are declared with DECLARE name type; without AS or TYPE keywords.
Step 2: Identify correct syntax
DECLARE p person; matches the correct syntax for composite type variable declaration.
Final Answer:
DECLARE p person; -> Option C
Quick Check:
Variable declaration = DECLARE name type; [OK]

Quick Trick: Declare composite variables like normal types without extra keywords [OK]

Common Mistakes:

Master "Advanced Features" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free