20762C: Developing SQL 2016 Databases Quiz Questions and Answers

Which of the following SQL clauses is used to select data from 2 or more tables?

Answer :
  • Join

A trigger is...

Answer :
  • a special type of store procedure, executed when certain event occurs

Which SQL statement selects all rows from a table called Products and orders the result set by ProductID column?

Answer :
  • SELECT * FROM Products ORDER BY ProductID

The UNION SQL clause can be used with________.

Answer :
  • SELECT clause only

Which SQL keyword is used to sort the result-set ?

Answer :
  • ORDER BY

What is the purpose of a view?

Answer :
  • To present relevant information to users and hide complexity.

The UPDATE SQL clause can________.

Answer :
  • update more than one row at a time

Which SQL statement is used to return only different values ?

Answer :
  • SELECT DISTINCT

What does DML stand for?

Answer :
  • Data Manipulation language

SQL query to find all the cities whose humidity is 95 .

Answer :
  • SELECT city FROM weather WHERE humidity = 95