You need to extract data from the system your predecessor created. you discover tables have been created according to the third
normal form. you find the needed data in three different tables. what SQL syntax allows you to garner this data?
a. union
b. join
c. Select
d. Having
a. union
b. join
c. Select
d. Having
1 answer:
Answer:
b. join
Explanation:
Correct answer:
Join: It allow join(paste) two tables by one or more commun columns
Example in the image attached
Bad answer:
Union: it only allow paste two tables with the same structure
select: it only allow get information from 1 table if not use join
having: it only allow get filtered information with a condition
You might be interested in
Answer:
code = 010100000001101000101
Explanation:
Steps:
The inequality yields , where M = 16. Therefore,
The second step will be to arrange the data bits and check the bits. This will be as follows:
Bit position number Check bits Data Bits
21 10101
20 10100
The bits are checked up to bit position 1
Thus, the code is 010100000001101000101