SQL Server interview questions part 4
SQL Server interview questions part 4
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. The UPDATE SQL clause can
Correct Answer is : update more than one row at a time
2. The UNION SQL clause can be used with
Correct Answer is : SELECT clause only
3. Which SQL statement is used to return only different values ?
Correct Answer is : SELECT DISTINCT
4. Which SQL keyword is used to sort the result-set ?
Correct Answer is : ORDER BY
5. How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?
Correct Answer is : UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
6. Which of the following command makes the updates performed by the transaction permanent in the database ?
Correct Answer is : COMMIT
7. Which TCL command undo all the updates performed by the SQL in the transaction ?
Correct Answer is : COMMIT
8. SQL query to find all the cities whose humidity is 95 .
Correct Answer is : SELECT city FROM weather WHERE humidity = 95
9. SQL query to find the temperature in increasing order of all cities.
Correct Answer is : SELECT city, temperature FROM weather ORDER BY city
10. What is the meaning of LIKE ‘%0%0%’ ?
Correct Answer is : Feature has two 0’s in it, at any position
11. Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy.
Correct Answer is : SELECT city, temperature, condition FROM weather WHERE condition NOT IN (‘sunny’, ‘cloudy’)
12. Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70.
Correct Answer is : SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ AND temperature > 70
13. Find all the tuples having temperature greater than ‘Paris’.
Correct Answer is : SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = ‘Paris’
14. Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79.
Correct Answer is : SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79
15. The command to remove rows from a table ‘CUSTOMER’ is
Correct Answer is : DELETE FROM CUSTOMER WHERE
16. Which of the following design strategy can reduce the occurrence of blocking locks ?
Correct Answer is : Use clustered indexes on high-usage tables
17. Which of the following design strategy can reduce the occurrence of blocking locks ?
Correct Answer is : Use clustered indexes on high-usage tables
18. Point out the correct statement :
Correct Answer is : A blocking lock occurs when one lock causes another process to wait in a holding queue
19. Point out the correct statement :
Correct Answer is : A blocking lock occurs when one lock causes another process to wait in a holding queue
20. Which of the following occurs when two connections need access to same piece of data concurrently and the meanwhile another is blocked because at a particular time, only one connection can have access ?
Correct Answer is : Block
