This topic contains a solution. Click here to go to the answer

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

ETearle

  • Hero Member
  • *****
  • Posts: 580
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?



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

morganmarie791

  • Sr. Member
  • ****
  • Posts: 336
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.




ETearle

  • Member
  • Posts: 580
Reply 2 on: Jul 7, 2018
:D TYSM


cam1229

  • Member
  • Posts: 329
Reply 3 on: Yesterday
Wow, this really help

 

Did you know?

The Babylonians wrote numbers in a system that used 60 as the base value rather than the number 10. They did not have a symbol for "zero."

Did you know?

The highest suicide rate in the United States is among people ages 65 years and older. Almost 15% of people in this age group commit suicide every year.

Did you know?

Long-term mental and physical effects from substance abuse include: paranoia, psychosis, immune deficiencies, and organ damage.

Did you know?

Amphetamine poisoning can cause intravascular coagulation, circulatory collapse, rhabdomyolysis, ischemic colitis, acute psychosis, hyperthermia, respiratory distress syndrome, and pericarditis.

Did you know?

The first monoclonal antibodies were made exclusively from mouse cells. Some are now fully human, which means they are likely to be safer and may be more effective than older monoclonal antibodies.

For a complete list of videos, visit our video library