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

Which of the following is not a SQL keyword or SQL clause?

Answer :
  • Invert

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

Which of the following statements gets the total value of the column 'Price' in the 'Sales' table?

Answer :
  • SELECT SUM(Price) FROM Sales

Which of the following 3 SQL statements is correct?

Answer :
  • SELECT Username, Password FROM Users

What does DML stand for?

Answer :
  • Data Manipulation language

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

Which TCL command undo all the updates performed by the SQL in the transaction ?

Answer :
  • ROLLBACK