[Solved] Consider this PostgreSQL query run on a server:INSERT INTO users (id, name) VALUES (1, 'Alice');INSERT INTO users (id, name) VALUES (2, 'Bob');SELECT * FROM users ORDER BY id;What will be the output... | PostgreSQL

PostgreSQL - PL/pgSQL Fundamentals

Consider this PostgreSQL query run on a server:

INSERT INTO users (id, name) VALUES (1, 'Alice');
INSERT INTO users (id, name) VALUES (2, 'Bob');
SELECT * FROM users ORDER BY id;

What will be the output of the SELECT query?

A[{"id":1, "name":"Alice"}, {"id":2, "name":"Bob"}]

B[{"name":"Alice"}, {"name":"Bob"}]

C[{1, 'Alice'}, {2, 'Bob'}]

DSyntax error

Step-by-Step Solution

Solution:

Step 1: Understand the INSERT commands
Two rows are inserted with ids 1 and 2 and names Alice and Bob.
Step 2: Analyze the SELECT query
The SELECT fetches all rows ordered by id, so rows appear in order 1 then 2.
Final Answer:
[{"id":1, "name":"Alice"}, {"id":2, "name":"Bob"}] -> Option A
Quick Check:
Inserted rows appear ordered by id [OK]

Quick Trick: SELECT * ORDER BY id returns rows sorted by id [OK]

Common Mistakes:

Master "PL/pgSQL Fundamentals" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Consider this PostgreSQL query run on a server: