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 59 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


ASDFGJLO

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

 

Did you know?

Oxytocin is recommended only for pregnancies that have a medical reason for inducing labor (such as eclampsia) and is not recommended for elective procedures or for making the birthing process more convenient.

Did you know?

Asthma cases in Americans are about 75% higher today than they were in 1980.

Did you know?

Your chance of developing a kidney stone is 1 in 10. In recent years, approximately 3.7 million people in the United States were diagnosed with a kidney disease.

Did you know?

Adult head lice are gray, about ? inch long, and often have a tiny dot on their backs. A female can lay between 50 and 150 eggs within the several weeks that she is alive. They feed on human blood.

Did you know?

Coca-Cola originally used coca leaves and caffeine from the African kola nut. It was advertised as a therapeutic agent and "pickerupper." Eventually, its formulation was changed, and the coca leaves were removed because of the effects of regulation on cocaine-related products.

For a complete list of videos, visit our video library