Examlex
The following queries produce the same results.
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');
Q29: The UNION clause is used to combine
Q44: An entity-type name should be _ to
Q66: What are some of the standard SQL
Q66: Data models of an existing database are
Q71: A requirement to begin designing physical files
Q77: Security measures for dynamic Web pages are
Q82: A(n)_ is defined by the tables and
Q82: A(n)_ is an impasse that results when
Q97: Optimistic concurrency control,or _,restricts each transaction to
Q115: Which of the following is the wildcard