A simple event database that tracks acts and the events where they perform has an ERD as illustrated. There are acts entered into the database that have not yet performed at any events. If a left outer join were performed to select all data from each table, what values would be displayed for the event fields for acts who have not yet performed at an event.
A) SELECT
B) NULL
C) The fields would be blank.
D) There can be no empty fields.

Question

A simple event database that tracks acts and the events where they perform has an ERD as illustrated. There are acts entered into the database that have not yet performed at any events. If a left outer join were performed to select all data from each table, what values would be displayed for the event fields for acts who have not yet performed at an event. 
A) SELECT 
B) NULL 
C) The fields would be blank. 
D) There can be no empty fields.

Quizplus · Accepted Answer

The Answer of A simple event database that tracks acts and the events where they perform has an ERD as illustrated. There are acts entered into the database that have not yet performed at any events. If a left outer join were performed to select all data from each table, what values would be displayed for the event fields for acts who have not yet performed at an event. 
A) SELECT 
B) NULL 
C) The fields would be blank. 
D) There can be no empty fields.

A Simple Event Database That Tracks Acts and the Events