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

Author Question: What is an OUTER JOIN? What will be an ideal response?[br][br][b][color=#151B54]Question ... (Read 87 times)

kshipps

  • Hero Member
  • *****
  • Posts: 571
What is an OUTER JOIN?
 
  What will be an ideal response?

Question 2

In the case of so-called active data warehouses, the loads occur in ________ that happen continuously, ensuring that the data in the data warehouse is updated close to real time (enabling analysis of the latest data).
 
  A) Dimensional modeling actions
  B) OLAP actions
  C) OLTP actions
  D) Micro batches



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

leannegxo

  • Sr. Member
  • ****
  • Posts: 374
Answer to Question 1

An OUTER JOIN statement is a variation of the JOIN operation that supplements the results with the records from one relation that have no match in the other relation.

Answer to Question 2

D




kshipps

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


deja

  • Member
  • Posts: 332
Reply 3 on: Yesterday
Great answer, keep it coming :)

 

Did you know?

Elderly adults are at greatest risk of stroke and myocardial infarction and have the most to gain from prophylaxis. Patients ages 60 to 80 years with blood pressures above 160/90 mm Hg should benefit from antihypertensive treatment.

Did you know?

Many medications that are used to treat infertility are injected subcutaneously. This is easy to do using the anterior abdomen as the site of injection but avoiding the area directly around the belly button.

Did you know?

There can actually be a 25-hour time difference between certain locations in the world. The International Date Line passes between the islands of Samoa and American Samoa. It is not a straight line, but "zig-zags" around various island chains. Therefore, Samoa and nearby islands have one date, while American Samoa and nearby islands are one day behind. Daylight saving time is used in some islands, but not in others—further shifting the hours out of sync with natural time.

Did you know?

The calories found in one piece of cherry cheesecake could light a 60-watt light bulb for 1.5 hours.

Did you know?

Of the estimated 2 million heroin users in the United States, 600,000–800,000 are considered hardcore addicts. Heroin addiction is considered to be one of the hardest addictions to recover from.

For a complete list of videos, visit our video library