Answer:
The table is attached as a picture.
a)
Select VENDOR_CONTACT_LAST_NAME || ', ' || VENDOR_CONTACT_FIRST_NAME "full_name" from VENDORS where VENDOR_CONTACT_LAST_NAME like 'A%' or VENDOR_CONTACT_LAST_NAME like 'E%' order by VENDOR_CONTACT_LAST_NAME,VENDOR_CONTACT_FIRST_NAME;
concatenation operator || is used . Also LIKE is used for pattern matching. full_name is alias for the concatenated column
b) As sample data is not given ,Please test the query for the data given in table
Explanation:
Answer:
length of tube = 4.12 m
Explanation:
Given data:
flow rate of engine oil = 1 kg/s
diameter of tube = 5-mm
inlet temperature of oil = 45°C
exit temperature of oil = 80°C
surface temperature of tube = 150°C
<u>Determine the required length of the tube </u>
attached below is a detailed solution to the given problem
length of tube = 4.12 m
Answer:
a)True
Explanation:
Rolling:
Rolling is a metal forming in which a material passes through two or more than two depends on conditions,rolls to produce the desired product.
Ring rolling:
In ring rolling a thick ring compresses by rolls to produce the large diameter ring.Actually volume of material is constant so when diameter of ring increases then to compensate it, the thickness of ring reduces .In simple words we can say that in ring rolling a thick ring of smaller is rolled into a thin ring of larger diameter.