SQL Server MCQ Questions with answers and solutions Page 19

Q. What is the meaning of LIKE ‘%0%0%’?

(A) Feature has two 0’s in it, at any position
(B) Feature has more than two 0’s
(C) Feature ends with two 0’s
(D) Feature begins with two 0’s

💬 Discuss

✅ Correct Answer: (A) Feature has two 0’s in it, at any position

Published by Ram Sharma ⭐ 193.88K Points at 22-Jun-2022 09:26 pm in SQL Server

Q. Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy.

(A) SELECT city, temperature, condition FROM weather WHERE condition NOT IN (‘sunny’, ‘cloudy’)
(B) SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN (‘sunny’, ‘cloudy’)
(C) SELECT city, temperature, condition FROM weather WHERE condition IN (‘sunny’, ‘cloudy’)
(D) SELECT city, temperature, condition FROM weather WHERE condition BETWEEN (‘sunny’, ‘cloudy’);

💬 Discuss

✅ Correct Answer: (A) SELECT city, temperature, condition FROM weather WHERE condition NOT IN (‘sunny’, ‘cloudy’)

Published by Ram Sharma ⭐ 193.88K Points at 22-Jun-2022 09:26 pm in SQL Server

Q. Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70.

(A) SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ AND temperature > 70
(B) SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ AND temperature > 70
(C) SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ OR temperature > 70
(D) SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ OR temperature > 70

💬 Discuss

✅ Correct Answer: (B) SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ AND temperature > 70

Published by Ram Sharma ⭐ 193.88K Points at 23-Jun-2022 09:12 pm in SQL Server

Q. Find all the tuples having a temperature greater than ‘Paris’.

(A) SELECT * FROM weather WHERE temperature > ‘Paris’ temperature
(B) SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = ‘Paris’)
(C) SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = ‘Paris’)
(D) SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = ‘Paris’

💬 Discuss

✅ Correct Answer: (D) SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = ‘Paris’

Published by Ram Sharma ⭐ 193.88K Points at 23-Jun-2022 09:13 pm in SQL Server

Q. Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79.

(A) SELECT * FROM weather WHERE humidity IN (63 to 79)
(B) SELECT * FROM weather WHERE humidity NOT IN (63 AND 79)
(C) SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79
(D) SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79

💬 Discuss

✅ Correct Answer: (C) SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79

Published by Ram Sharma ⭐ 193.88K Points at 23-Jun-2022 09:14 pm in SQL Server

Q. The command to remove rows from a table ‘CUSTOMER’ is __________________

(A) DROP FROM CUSTOMER
(B) UPDATE FROM CUSTOMER
(C) REMOVE FROM CUSTOMER
(D) DELETE FROM CUSTOMER WHERE

💬 Discuss

✅ Correct Answer: (D) DELETE FROM CUSTOMER WHERE

Published by Ram Sharma ⭐ 193.88K Points at 23-Jun-2022 09:14 pm in SQL Server

Q. The following SQL is which type of join:

Code:

SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID

(A) Cartesian join
(B) Outer join
(C) Natural join
(D) Equi-join

💬 Discuss

✅ Correct Answer: (D) Equi-join

Published by Ram Sharma ⭐ 193.88K Points at 23-Jun-2022 09:15 pm in SQL Server

Q. The following SQL is which type of join:

Code:

SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T

(A) Cartesian join
(B) Outer join
(C) Natural join
(D) Equi-join

💬 Discuss

✅ Correct Answer: (A) Cartesian join

Published by Ram Sharma ⭐ 193.88K Points at 23-Jun-2022 09:16 pm in SQL Server

Q. Which is not a type of join in T-SQL?

(A) Cartesian join
(B) Outer join
(C) Natural join
(D) Equi-join

💬 Discuss

✅ Correct Answer: (C) Natural join

Published by Ram Sharma ⭐ 193.88K Points at 23-Jun-2022 09:16 pm in SQL Server

Q. Which of the following is not a limitation of view?

(A) Adding Column is Expensive by Joining Table Outside View
(B) Cross Database Queries Not Allowed in Indexed View
(C) Index Created on View Used Often
(D) ORDER BY Does Not Work

💬 Discuss

✅ Correct Answer: (C) Index Created on View Used Often

Published by Ram Sharma ⭐ 193.88K Points at 23-Jun-2022 09:18 pm in SQL Server

SQL Server MCQs with answers Page - 19

Q. What is the meaning of LIKE ‘%0%0%’?

Q. Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy.

Q. Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70.

Q. Find all the tuples having a temperature greater than ‘Paris’.

Q. Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79.

Q. The command to remove rows from a table ‘CUSTOMER’ is __________________

Q. The following SQL is which type of join:

Q. The following SQL is which type of join:

Q. Which is not a type of join in T-SQL?

Q. Which of the following is not a limitation of view?

Programming Categories

📱 Download Our App