Author Question: Parenthesis represent an optional element in the data dictionary. Indicate whether the statement ... (Read 21 times)

ETearle · **on:** Jul 7, 2018

Parenthesis represent an optional element in the data dictionary.

Indicate whether the statement is true or false

Question 2

Briefly explain the difference between an inner and an outer join.

What will be an ideal response?

morganmarie791 · **Reply #1 on:** Jul 7, 2018

Answer to Question 1

TRUE

Answer to Question 2

Inner joins return all the related tables from the two tables involved in the join. They do not return any records that do not have a related record. Outer joins return all the records from one of the tables in the join even if they do not have a related record in the other table. In the second table only the related records are returned.