Basic SQL Quiz - 2
Description: Basic SQL Quiz - 2 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: sql |
With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?
Which SQL statement is used to return only different values?
With SQL, how can you insert a new record into the "Persons" table?
With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?
With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?
With SQL, how can you return the number of records in the "Persons" table?
What will be the output of the following statement? SELECT LEN(CAST(LEFT('026-100', 3) AS INT))
What will be the output of the following statement? SELECT CAST(-1 AS SMALLDATETIME)
What is the best data type to store the birthdays of the US Presidents, starting with George Washington's birthday of February 22, 1732?
What is the maximum date value that can be stored in a SMALLDATETIME data type?