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

Which SQL statement is used to delete data from a database?

Answer :
  • Delete

Which SQL statement is used to insert new data in a database?

Answer :
  • Insert into

With SQL, how do you select a column named "FirstName" from a table named "Persons"?

Answer :
  • SELECT FirstName FROM Persons

With SQL, how do you select all the columns from a table named "Persons"?

Answer :
  • SELECT * FROM Persons

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

Answer :
  • SELECT * FROM Persons WHERE FirstName='Peter'

In which of the following cases a DML statement is not executed?

Answer :
  • When a table is deleted

Which of the following are the five built-in functions provided by SQL?

Answer :
  • COUNT, SUM, AVG, MAX, MIN

Which of the following do you need to consider when you make a table in SQL?

Answer :
  • All of the above

SQL is:

Answer :
  • A data sublanguage

The condition in a WHERE clause can refer to only one value.

Answer :
  • False