COS326 L7 2025

Which of the following is a valid array declaration in PostgreSQL?

• 1. text[] schedule[][]

• 1. schedule text[][]

• 1. ARRAY(text[][])

• schedule = text[][]

Which PostgreSQL function returns the dimensions of an array?

• array_length()

• array_dims()

• array_size()

• array_dimensions()

What does the following query return?

SELECT name FROM sal_Emp WHERE payByQuarter[1] <> payByQuarter[2];

• Names of employees with equal first two quarterly payments

• Names of employees with different first two quarterly payments

• Names of employees with missing payments

• Names of employees with NULL values

Which of the following is a valid way to insert a 2D array in PostgreSQL?

• ARRAY[ ['a', 'b'], ['c', 'd'] ]

• ARRAY( ('a', 'b'), ('c', 'd') )

• ARRAY{ {'a', 'b'}, {'c', 'd'} }

• ARRAY['a', 'b', 'c', 'd']

The query

SELECT array_dims(schedule) FROM sal_Emp WHERE name = 'Thando';

returns the _______ of the schedule array.