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 50 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
Great answer, keep it coming :)


bbburns21

  • Member
  • Posts: 336
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

 

Did you know?

Human stomach acid is strong enough to dissolve small pieces of metal such as razor blades or staples.

Did you know?

Approximately 15–25% of recognized pregnancies end in miscarriage. However, many miscarriages often occur before a woman even knows she is pregnant.

Did you know?

People about to have surgery must tell their health care providers about all supplements they take.

Did you know?

Walt Disney helped combat malaria by making an animated film in 1943 called The Winged Scourge. This short film starred the seven dwarfs and taught children that mosquitos transmit malaria, which is a very bad disease. It advocated the killing of mosquitos to stop the disease.

Did you know?

It is believed that the Incas used anesthesia. Evidence supports the theory that shamans chewed cocoa leaves and drilled holes into the heads of patients (letting evil spirits escape), spitting into the wounds they made. The mixture of cocaine, saliva, and resin numbed the site enough to allow hours of drilling.

For a complete list of videos, visit our video library