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"?
With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?
Which SQL statement is used to return only different values?
Which SQL keyword is used to sort the result-set?
With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?
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?
How can you change "Hansen" into "Nilsen" in the "LastName" column 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 will be the output of the following statement? SELECT ROUND(123.89, -1)
What will be the output of the following statement? SELECT STR(6365, 3)
What will be the output of the following statement? SET ARITHABORT OFF SET ANSI_WARNINGS OFF SELECT 100/0
View text definitions are stored in which system table?
What's the maximum value can an INT data type hold?
What is the best data type to store the birthdays of the US Presidents, starting with George Washington's birthday of February 22, 1732?
Which of the following is NOT a valid description of the public role?
What is the maximum date value that can be stored in a SMALLDATETIME data type?