
COS326 L7 2025
Authored by Sheunesu Makura
Computers
University
Used 1+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
5 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is a valid array declaration in PostgreSQL?
text[] schedule[][]
schedule text[][]
ARRAY(text[][])
schedule = text[][]
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which PostgreSQL function returns the dimensions of an array?
array_length()
array_dims()
array_size()
array_dimensions()
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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']
5.
FILL IN THE BLANK QUESTION
1 min • 1 pt
The query
SELECT array_dims(schedule) FROM sal_Emp WHERE name = 'Thando';
returns the _______ of the schedule array.
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
10 questions
Knowledge Management Quiz
Quiz
•
University
10 questions
Firewall & IDS
Quiz
•
University
10 questions
DDL
Quiz
•
University
10 questions
e-commerce security TRUE/FALSE Quiz
Quiz
•
University - Professi...
10 questions
0xDebug - Python
Quiz
•
University
8 questions
Business Functional Areas
Quiz
•
University
10 questions
Database
Quiz
•
University
10 questions
KIỂU DỮ LIỆU CÓ CẤU TRÚC
Quiz
•
11th Grade - University
Popular Resources on Wayground
8 questions
Spartan Way - Classroom Responsible
Quiz
•
9th - 12th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
14 questions
Boundaries & Healthy Relationships
Lesson
•
6th - 8th Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
3 questions
Integrity and Your Health
Lesson
•
6th - 8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
9 questions
FOREST Perception
Lesson
•
KG
20 questions
Main Idea and Details
Quiz
•
5th Grade
Discover more resources for Computers
20 questions
Disney Trivia
Quiz
•
University
7 questions
Fragments, Run-ons, and Complete Sentences
Interactive video
•
4th Grade - University
7 questions
Renewable and Nonrenewable Resources
Interactive video
•
4th Grade - University
10 questions
DNA Structure and Replication: Crash Course Biology
Interactive video
•
11th Grade - University
7 questions
Force and Motion
Interactive video
•
4th Grade - University
20 questions
Implicit vs. Explicit
Quiz
•
6th Grade - University
14 questions
Ch.3_TEACHER-led
Quiz
•
University
7 questions
Comparing Fractions
Interactive video
•
1st Grade - University