Normalization
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
|
Question 703
|
What result set is returned from the following SQL query?
SELECT customer_name, telephone FROM customers
WHERE city IN(‘Jaipur’,’Delhi’,’Agra’);
SELECT customer_name, telephone FROM customers
WHERE city IN(‘Jaipur’,’Delhi’,’Agra’);
|
The cusomer_name of all customers who are not living IN Jaipur,Delhi OR Agra
|
|
|
The customer_name and telephone of all customers
|
|
|
The customer_name and telephone of all customers living IN either Jaipur,Delhi OR
Agra |
|
|
The customer_name and telephone of all customers living IN Jaipur,Delhi AND Agra
|
Question 703 Explanation:
Only logic here is, when we are using keyword IN there must be OR keyword.
Correct Answer: C
Question 703 Explanation:
Only logic here is, when we are using keyword IN there must be OR keyword.