This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: Which of the following is NOT true regarding outer joins? A) The OUTER JOIN clause returns all ... (Read 83 times)

theo

  • Hero Member
  • *****
  • Posts: 698
on: Aug 28, 2018
Which of the following is NOT true regarding outer joins?
 
  A) The OUTER JOIN clause returns all rows from two or more of the tables within the FROM clause, as long as those rows meet any WHERE or HAVING search conditions.
  B) The OUTER JOIN clause is used whenever multiple tables that are accessed through a SQL SELECT statement returns all of the records from one table and only those records from the other table where the joined fields match.
  C) The LEFT JOIN clause is used when you want to return all rows in the left table, even if no matching rows exist in the right table.
  D) The FULL OUTER JOIN clause is not supported in Microsoft Access.

Question 2

The ________ function truncates the decimal and returns only the numbers to the left of the decimal.
 
  Fill in the blank(s) with correct word


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

Toya9913

  • Sr. Member
  • ****
  • Posts: 341
Reply #1 on: Aug 28, 2018
Answer to Question 1

A

Answer to Question 2

Integer


theo

  • Member
  • Posts: 698
Reply 2 on: Aug 28, 2018
:D TYSM

cpetit11

  • Member
  • Posts: 321
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

In 1835 it was discovered that a disease of silkworms known as muscardine could be transferred from one silkworm to another, and was caused by a fungus.

Did you know?

For about 100 years, scientists thought that peptic ulcers were caused by stress, spicy food, and alcohol. Later, researchers added stomach acid to the list of causes and began treating ulcers with antacids. Now it is known that peptic ulcers are predominantly caused by Helicobacter pylori, a spiral-shaped bacterium that normally exist in the stomach.

Did you know?

Blood in the urine can be a sign of a kidney stone, glomerulonephritis, or other kidney problems.

Did you know?

The first-known contraceptive was crocodile dung, used in Egypt in 2000 BC. Condoms were also reportedly used, made of animal bladders or intestines.

Did you know?

The most common treatment options for addiction include psychotherapy, support groups, and individual counseling.

Part of the Hubble Ultra-Deep Field image showing a typical section of space containing galaxies int Part of the Hubble Ultra-Deep Field image showing a typical section of space containing galaxies int
The internal structures of the outer, middle, and inner ear. The internal structures of the outer, middle, and inner ear.
Adapoids and omomyoids had longer snouts and are the first “true” primates. Adapoids and omomyoids had longer snouts and are the first “true” primates.
Which of the following statements is true of linkage? Which of the following statements is true of linkage?
The steps in the hearing process. (1) Sound waves enter the outer ear and travel through the ear ... The steps in the hearing process. (1) Sound waves enter the outer ear and travel through the ear ...
Lipid composition in the outer leaflet (green) and inner leaflet (gold) of the plasma membrane Lipid composition in the outer leaflet (green) and inner leaflet (gold) of the plasma membrane
Video: Cardiac Cycle (Part 3 of 4)

For a complete list of videos, visit our video library