Below Sql Server quiz are Multiple Choice Questions (MCQs) type Quiz. These Sql Server MCQ Questions helps you to refresh your Sql Server, you can see the correct option by clicking on it. .
1. SQL query to find the temperature in increasing order of all cities.
SELECT city FROM weather ORDER BY temperature
SELECT city, temperature FROM weather
SELECT city, temperature FROM weather ORDER BY temperature
SELECT city, temperature FROM weather ORDER BY city
2. Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70.
SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ OR temperature > 70
SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ OR temperature > 70
SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ AND temperature > 70
SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ AND temperature > 70
3. Which SQL statement is used to insert new data in a database?
Insert Into
Add New
Insert Record
Add Record
4. Which of the following statements is true concerning subqueries?
Does not start with the word SELECT.
Involves the use of an inner and outer query.
Cannot return the same result as a query that is not a subquery.
All of the above
5. A database is used to
store data
modify data
extract data
All of the above
6. AND, OR and NOT are examples of
Clauses
Boolean operators
Conjuctive operators
Exclusive operators
7. The arranging of data in a logical sequence is called
Summarizing
Classifying
Sorting
Rearranging
8. Embedded SQL is which of the following?
The process of making an application capable of generating specific SQL code on the fly.
Hard-coded SQL statements in a trigger.
Hard-coded SQL statements in a program language such as Java.