Question 1

With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?

sql

SELECT * FROM Persons WHERE FirstName LIKE 'Peter' AND LastName LIKE 'Jackson'
SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'
SELECT FirstName='Peter', LastName='Jackson' FROM Persons

Answer

Correct Option: B

Question 2

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"?

sql

SELECT LastName>'Hansen' AND LastName
SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'
SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName

Answer

Correct Option: B

Question 3

Which SQL statement is used to return only different values?

sql

SELECT UNIQUE
SELECT INDENTITY
SELECT DIFFERENT
SELECT DISTINCT

Answer

Correct Option: D

Question 4

Which SQL keyword is used to sort the result-set?

sql

SORT BY
ORDER
ORDER BY
SORT

Answer

Correct Option: C

Question 5

With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?

sql

SELECT * FROM Persons SORT BY 'FirstName' DESC
SELECT * FROM Persons ORDER BY FirstName DESC
SELECT * FROM Persons ORDER FirstName DESC
SELECT * FROM Persons SORT 'FirstName' DESC

Answer

Correct Option: B

Question 6

With SQL, how can you insert a new record into the "Persons" table?

sql

INSERT INTO Persons VALUES ('Jimmy', 'Jackson')
INSERT ('Jimmy', 'Jackson') INTO Persons
INSERT VALUES ('Jimmy', 'Jackson') INTO Persons

Answer

Correct Option: A

Question 7

With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?

sql

INSERT INTO Persons (LastName) VALUES ('Olsen')
INSERT ('Olsen') INTO Persons (LastName)
INSERT INTO Persons ('Olsen') INTO LastName

Answer

Correct Option: A

Question 8

How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?

sql

UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'
UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'
MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen
MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'

Answer

Correct Option: B

Question 9

With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?

sql

DELETE FROM Persons WHERE FirstName = 'Peter'
DELETE ROW FirstName='Peter' FROM Persons
DELETE FirstName='Peter' FROM Persons

Answer

Correct Option: A

Question 10

With SQL, how can you return the number of records in the "Persons" table?

sql

SELECT COLUMNS() FROM Persons
SELECT COUNT(*) FROM Persons
SELECT COLUMNS(*) FROM Persons
SELECT COUNT() FROM Persons

Answer

Correct Option: B

Question 11

What will be the output of the following statement? SELECT LEN(CAST(LEFT('026-100', 3) AS INT))

sql

2
3
7
Statement will generate an error.

Answer

Correct Option: A

Question 12

What will be the output of the following statement? SELECT CAST(-1 AS SMALLDATETIME)

sql

1900-01-01 00:00:00.000
1899-01-01 00:00:00.000
1752-01-01 00:00:00.000
The system will generate an error. Only positive integer values can be converted to a SMALLDATETIME data type.

Answer

Correct Option: D

Question 13

What will be the output of the following statement? SELECT ROUND(123.89, -1)

sql

120.00
123.00
123.90
124.00

Answer

Correct Option: A

Question 14

What will be the output of the following statement? SELECT STR(6365, 3)

sql

6365
6,365
6400
6365.000

Answer

Correct Option: A

Question 15

What will be the output of the following statement? SET ARITHABORT OFF SET ANSI_WARNINGS OFF SELECT 100/0

sql

Null
0
Infinity
An error is generated.

Answer

Correct Option: A

Question 16

View text definitions are stored in which system table?

sql

sysobjects
syscolumns
syscomments
sysviews

Answer

Correct Option: C

Question 17

What's the maximum value can an INT data type hold?

sql

2,147,483,647
2,147,483,648
4,294,967,295
4,294,967,296

Answer

Correct Option: A

Question 18

What is the best data type to store the birthdays of the US Presidents, starting with George Washington's birthday of February 22, 1732?

sql

DATETIME
INT
SMALLDATETIME
VARCHAR

Answer

Correct Option: B

Question 19

Which of the following is NOT a valid description of the public role?

sql

The public role captures all default permissions for users in a database.
The public role cannot be dropped.
The public role is contained in every database, including msdb, tempdb, model, and all user databases except in the master database for security purposes.
The public role cannot have users, groups, or roles assigned to it.

Answer

Correct Option: C

Question 20

What is the maximum date value that can be stored in a SMALLDATETIME data type?

sql

June 6, 2079
July 6, 2079
December 31, 2079
December 31, 9999

Answer

Correct Option: A

Description: Basic SQL Quiz - 2
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: sql

Basic SQL Quiz - 2

Find more quizzes from top tags