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 31 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
Wow, this really help


tanna.moeller

  • Member
  • Posts: 328
Reply 3 on: Yesterday
:D TYSM

 

Did you know?

The oldest recorded age was 122. Madame Jeanne Calment was born in France in 1875 and died in 1997. She was a vegetarian and loved olive oil, port wine, and chocolate.

Did you know?

Oliver Wendell Holmes is credited with introducing the words "anesthesia" and "anesthetic" into the English language in 1846.

Did you know?

Most strokes are caused when blood clots move to a blood vessel in the brain and block blood flow to that area. Thrombolytic therapy can be used to dissolve the clot quickly. If given within 3 hours of the first stroke symptoms, this therapy can help limit stroke damage and disability.

Did you know?

Complications of influenza include: bacterial pneumonia, ear and sinus infections, dehydration, and worsening of chronic conditions such as asthma, congestive heart failure, or diabetes.

Did you know?

Although puberty usually occurs in the early teenage years, the world's youngest parents were two Chinese children who had their first baby when they were 8 and 9 years of age.

For a complete list of videos, visit our video library