20761C:Querying Data with Transact-SQL 2016 Quiz Questions and Answers

What is the difference between the DELETE and TRUNCATE SQL clauses?

Answer :
  • The TRUNCATE clause deletes all rows in a database table, while the DELETE clause can have a WHERE condition and might or might not delete all rows in a table.

The BETWEEN SQL keywords specifies_______.

Answer :
  • A range to test in the SQL query search condition

Which of the following SQL statements has the correct syntax?

Answer :
  • SELECT * FROM Table1 WHERE Column1 >= 10

Can you use the SQL JOIN and SQL HAVING clauses in one SQL statement?

Answer :
  • Yes

Which SQL keyword is used to retrieve a maximum value?

Answer :
  • Max

Which SQL function is used to count the number of rows in a SQL query?

Answer :
  • COUNT(*)

What does the term Entity stand for?

Answer :
  • A Table

What is the term used for the unique identifier of an entity?

Answer :
  • Primary Key

What does a tuple refer to?

Answer :
  • A Row

Which of the following is performed to combine data from two tables?

Answer :
  • Join