Search & Filtering
why is it important for companies to have a particular target market?
Get all the videos that are released in the year 2018.
Note:
Sort the output in the descending order of
published_datetime and then in the alphabetical order of name Expected Output Format;
video_id name duration_in_secs no_of_views............
Provide the transmission media (Guided or Unguided) used in the following networks
and explain the functions and characteristics (bandwidth, Security, Throughput) and
explain what these networks are primarily used for.
1. Satellite Cable TV Network
2. Campus LAN
3. 5G Network
4. Airport IP Telephony Network
5. VLAN
6. VANET
7. ZigBee Network
8. FTTH Network
9. VoIP
10. SKYPE
Recall for an advertisement for a famous Philippine company. Then answer the following questions
1.What is the product? _____________________________________________
2.What is the brand name of the product? ______________________________
3.What can you say about the packaging if there is any? _________________________________________________________
4.What is the tagline of the product if you can recall? ______________________
5.Who do you think is the target market of this company? Why?
_____________________________________________________________________________________________________________________________________________________________
6.Do you think their company’s target market is appropriate with the products/services they are offering? Why?
______________________________________________________________________________________________________________________________________________________________________________
1. The chairman is trying to forecast the number of tourists who would be visiting the city of Adama in the
coming year. Some students from Royal College have examined the problem as part of course project. They
estimated the current year’s volume as 110,000 tourists. They have also projected that the volume in the
next year will be 120,000 and the volume in the future will continues to grow at the same rate. Determine
equation of a line which relates the number of tourists, P, to year’s t as measured from this current year?
Write expression that gives the required unknown value.
1. If a = 8 and c = 12, find B.
Answer:
2. If a = 13 and B = 16°, find c.
Answer:
3. If A = 15° and c = 37, find a.
Answer:
Get the top 10 most viewed videos till date.
Note:
Sort the output in the descending order of
no_of_views and published_datetime Expected Output Format;
name channel_id no_of_views.........
Get videos from TEDx channel (id=353) with more than 50 thousand views.
Note:
Sort the output in the descending order of
no_of_views and in the ascending order of videonameExpected Output Format
video_id name duration_in_secs no_of_views
How to convert basic data to user defined data type
A restaurant buys avocados from three suppliers P, Q and R. Records show that 30% of the avocados
come from P, 55% come from Q and the rest come from R. Further records show that 8% of avocados
supplied by P are substandard, 12% of avocados supplied by Q are substandard and 15% of
avocados supplied by R are substandard
