Sql Server MCQ

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.
    • Hard-coded SQL statements in a procedure.
  • 9. The SQL SELECT statement is capable of

    • Projection
    • Selection
    • Protection & Security
    • Both A & B
  • 10. SQL views can be used to hide?

    • Complicated SQL syntax
    • Rows
    • Columns
    • All of the above