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.