I\'ve answered these questions, but I am not 100% sure on all of them, any help
ID: 3726747 • Letter: I
Question
I've answered these questions, but I am not 100% sure on all of them, any help would be appreciated. The subject is relational databases. Thank you!
Question 15 Answer saved Points out of 5.00 P Flag question A query retrieving the data from one relation can be used to populate another relation. Select one True O False Question 16 Answer saved Points out of 5.00 P Flag questionVekiclelD Iype Make OwmlD OuaName VEHICLE Observe the table VEHICLE that contains the following four records VEHICLE 01 02 03 Fard Pam Pat Pam 121 Ca Ford ruck Honda Ca Honda This table will be used for the following questions citing table VEHICLE. The following query on table VEHICLE will return 4 values SELECT vehicleid FROM vehicle Select one True O False Question 17 Answer saved Points out of 5.00 P Flag questionYekiclelD Type Make OmaID OaName VEHICLE Observe the table VEHICLE that contains the following four records VEHICLE O1 02 03 OI Pam Pat Fard Ca Ford Truck Honda Ca Honda 2m2 This table will be used for the following questions citing table VEHICLE. The following query on table VEHICLE will return 2 values SELECT DISTINCT ownerid, ownername FROM vehicle, Select one rue !) FalseExplanation / Answer
Please find the answer below:
14. Answer is correct. AS Group by will give count for each class type.
15. True. One query result can be used as where in other query
16. select vehicleid from vehicle will return 111,222,333,444 so it's True
17. distinct will return distinct combination of ownerid and ownername so 3 result will come. So its false
18. select make from vehicle will return Ford,Ford,Honda,Honda so 4 value will get SO it's true.
19. count(*) will return number of total row. SO True
20. count(*) with group by will return count for each id. Here three ids are so 3 number will get so its False