Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

(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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Processing Fundamentals Design And Implementation

Authors: David M. Kroenke

5th Edition

B000CSIH5A, 978-0023668814

More Books

Students also viewed these Databases questions