Answered step by step
Verified Expert Solution
Question
1 Approved Answer
(4) (igitiition It I I pmestitire ini (i) atl wir the atrover 14 timbecthed &6 8nsista on 20. Bynamie E04? a) is tised to generate
(4) (igitiition It I I pmestitire ini (i) atl wir the atrover 14 timbecthed \&6 8nsista on 20. Bynamie E04? a) is tised to generate uppropdate 8QL code on the fly as an application is processing. b) is quite volatile. c) is not used widely on the futemel. d) creates a less flexible applieation. 21. In order to seleet name and city of the customers of the salesman "SMITH", consider the following queries and piek the correot answer below: select customer_name, customer_city from customer, salesman where customer.salesman_id = salesman.salesman_id and salesman.lname = 'SMITH'; select customer_name, customer_city from customer where customer.salesman_id = (select salesman_id from salesman where lname = 'SMITH'); a) only the first query may be used b) only the second query may be used c) both queries may be used d) none of them may be used 22. Consider the following query and pick the correct answer below: select customer.customer_name, salesman.sales_quota from customer where customer.salesman_id = (select salesman_id where Iname = 'SMITH'); a) it will select the name and city of the customers of the salesman "SMITH" b) it will select the name of the customers and the quota of the salesman "SMTTH" c) it will select both name and city of eutomers and the quota of the salesman "SMITH" d) it will produce an error
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started