Shay7sabbsnice Shay7sabbsnice

18-05-2017
Computers and Technology

contestada

Assume you are using the UNION operator to combine the results from two identical tables, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table. ____ records are returned when using the UNION operator.

Respuesta :

19-05-2017

The result of using UNION operator for these tables will have 10 + 7 - 2 = 15 records (number of records in CUSTOMER + number of records in CUSTOMER_2 - number of common records).

Answer Link

Otras preguntas

Richard Beck has a life insurance policy which he has modified to include an accidental death benefit payable to his son and daughter. This modification has mos

Claire can eat 3/4 of a pizza every 5 minutes. How much of a pizza can she eat in 1 minute?

In the winter of 1866, a convention was held to rewrite the Texas Constitution. All of the following attended EXCEPT: a. high-ranking members of the Confederac

The substance that are present after ant chemical reaction are called

Natalie, an American student studying abroad in Taiwan, is at a restaurant when she sees a waitress drop a tray of drinks and then giggle. Natalie finds this re

Which is equal to -(4 - 5)2 + 1?

Jake earns $7.50 per hour working at a local car wash. The function, ƒ ƒ ( x ) = 7.50 x , relates the amount Jake earns to the number of hours he works. Write

How does the direction of vibration of a longitudinal wave compare to its direction of motion?

A nurse observes a few small, yellow nodules on the cervix of a client during the speculum exam. They are not painful or odorous, and a thin, clear discharge is

In which form of government would the people elect officials to make government decisions? 1.monarcy 2.Direct democracy 3.Representative democracy 4.Autocracy