1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
elena-s [515]
3 years ago
10

Considering the two tables below called Orders and OrderLines, how many rows would be returned by this SQL query? SELECT o.Order

ID, ol.OrderLineID FROM Orders AS o LEFT JOIN OrderLines AS ol ON o.OrderID = ol.OrderID ;

Engineering
1 answer:
natima [27]3 years ago
3 0

Answer:

The query will return four (4) rows

Explanation:

(See attachment below for the table)

The query will return rows where ORDERID is the same on both tables i.e. table ORDERS and ORDERLINES.

The similar rows (on column ORDERID) are 1897 and 87; for table ORDERLINESS and table ORDERS.

But on table ORDERLINESS, there are three rows with 1897 (under ORDERID column).

In total, they have 4 rows in common which are

ORDERID

1897

1897

1897 and

87

You might be interested in
An inductor has a 50.0-Ω reactance when connected to a 60.0-Hz source. The inductor is removed and then connected to a 45.0-Hz s
nignag [31]

Given:

X_{L} = 50.0 \ohm

frequency, f = 60.0 Hz

frequency, f' = 45.0 Hz

V_rms} = 85.0 V

Solution:

To calculate max current in inductor, I_{L(max):

At f = 60.0 Hz

X_{L} = 2\pi fL

50.0 = 2\pi\times 60.0\times L

L = 0.1326 H

Now, reactance X_{L} at f' = 45.0 Hz:

X'_{L} = 2\pi f'L

X'_{L} = 2\pi\times 45.0\times 0.13263 = 37.5\ohm

Now, I_{L(max) is given by:

I_{L(max) = \sqrt {\frac{2V_{rms}}{X'_{L}}}

I_{L(max) = \sqrt {\frac{2\times 85.0}{37.5}} = 2.13 A

Therefore,  max current in the inductor, I_{L(max) = 2.13 A

7 0
3 years ago
The nuclear reactions resulting from thermal neutron absorption in boron and cadmium are 10B5 + 1 n0 ï  7Li3 + 4He2 113Cd48 + 1
kirill115 [55]

Solution :

The nuclear reaction for boron is given as :

$^{10}\textrm{B}_5 + ^{1}\textrm{n}_0 \rightarrow ^{7}\textrm{Li}_3 + ^{4}\textrm{He}_2$

And the reaction for Cadmium is :

$^{113}\textrm{Cd}_48 + ^{1}\textrm{n}_0 \rightarrow ^{114}\textrm{Cd}_48 + \gamma [5 \ \textrm{MeV}]$

We know that it is easier that to shield or stop an alpha particle (i.e. He nucli) as they can be stopped or obstructed by only a few centimetres of the material. However, the gamma rays ( γ ) can penetrate through the material to a greater distance. Therefore, we can choose the first one.

6 0
2 years ago
Show that for a linearly separable dataset, the maximum likelihood solution for the logisitic regression model is obtained by fi
KATRIN_1 [288]

Answer:

Answer for the question:

"Show that for a linearly separable dataset, the maximum likelihood solution for the logisitic regression model is obtained by finding a weight vector w whose decision boundary wx. "

is explained in the attachment.

Explanation:

8 0
3 years ago
If you measure 0.7 V across a diode, the diode is probably made of
tatuchka [14]

Answer:

Made of Silicon.

Explanation:

A diode is a semiconductor device use in mostly electronic appliances. It is two terminals device consisting of a P-N junction formed either in Germanium or silicon crystal.

Diode can be forward biased or reverse biased.

When a diode is forward biased and the applied voltage is increased from zero, hardly any current flows through the device in the beginning.

It is so because the external voltage is being opposed by the internal barrier voltage whose value is 0.7v for silicon and 0.3v for germanium.

If you measure 0.7 V across a diode, the diode is probably therefore made of Silicon.

6 0
2 years ago
An aluminum alloy tube with an outside diameter of 3.50 in. and a wall thickness of 0.30 in. is used as a 14 ft long column. Ass
slega [8]

Answer:

slenderness ratio = 147.8

buckling load = 13.62 kips

Explanation:

Given data:

outside diameter is 3.50 inc

wall thickness 0.30 inc

length of column is 14 ft

E = 10,000 ksi

moment of inertia = \frac{\pi}{64 (D_O^2 -D_i^2)}

I = \frac{\pi}{64}(3.5^2 -2.9^2) = 3.894 in^4

Area = \frac{\pi}{4} (3.5^2 -2.9^2) = 3.015 in^2

radius = \sqrt{\frac{I}{A}}

r = \sqrt{\frac{3.894}{3.015}

r = 1.136 in

slenderness ratio = \frac{L}{r}

                              = \frac{14 *12}{1.136} = 147.8

buckling load = P_cr = \frac{\pi^2 EI}}{l^2}

P_{cr} = \frac{\pi^2 *10,000*3.844}{( 14\times 12)^2}

P_{cr} = 13.62 kips

3 0
2 years ago
Other questions:
  • Ammonia enters the expansion valve of a refrigeration system at a pressure of 1.4 MPa and a temperature of 32degreeC and exits a
    15·1 answer
  • When storing used oil, it need to be kept in________ container?
    11·1 answer
  • A displacement transducer has the following specifications: Linearity error ± 0.25% reading Drift ± 0.05%/○C reading Sensitivity
    8·1 answer
  • An actual vapour compression system comprises following process represents a. 1-2 Compression process b. 2-3 Condens 1 (or heat
    5·1 answer
  • A highway reconstruction project is being undertaken to reduce crash rates. The reconstruction involves a major realignment of t
    14·1 answer
  • g An analog voice signal, sampled at the rate of 8 kHz (8000 samples/second), is to be transmitted by using binary frequency shi
    12·1 answer
  • A 1200-kg car moving at 20 km/h is accelerated
    5·1 answer
  • Which of the following correctly explains why it would be beneficial for an engineer to become a member of the Leadership in Ene
    15·2 answers
  • How does refrigeration preserve food and dead bodies​
    12·2 answers
  • A program contains the following function definition: int cube(int number) { return number * number * number; } Write a stateme
    8·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!