W3 SQL

Question 1

sql

What does SQL stand for?

Answer 1

Structured Query Language

Question 2

sql

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

Answer 2

SELECT

Question 3

sql

Which SQL statement is used to update data in a database?

Answer 3

UPDATE

Question 4

sql

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

Answer 4

DELETE

Question 5

sql

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

Answer 5

INSERT INTO

Question 6

sql

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

Answer 6

SELECT FirstName FROM Persons

Question 7

sql

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

Answer 7

SELECT * FROM Persons

Question 8

sql

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

Answer 8

SELECT * FROM Persons WHERE FirstName=’Peter’

Question 9

sql

With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” starts with an “a”?

Answer 9

SELECT * FROM Persons WHERE FirstName LIKE ‘a%’

Question 10

sql

The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true

Answer 10

True

Question 11

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

Answer 11

SELECT * FROM Persons WHERE FirstName=’Peter’ AND LastName=’Jackson’

Question 12

sql

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

Answer 12

SELECT * FROM Persons WHERE LastName BETWEEN ‘Hansen’ AND ‘Pettersen’

Question 13

sql

Which SQL statement is used to return only different values?

Answer 13

SELECT DISTINCT

Question 14

sql

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

Answer 14

ORDER BY

Question 15

sql

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

Answer 15

SELECT * FROM Persons ORDER BY FirstName DESC

Question 16

sql

With SQL, how can you insert a new record, Jimmy and Jackson, into the “Persons” table?

Answer 16

INSERT INTO Persons VALUES (‘Jimmy’, ‘Jackson’)

Question 17

sql

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

Answer 17

INSERT INTO Persons (LastName) VALUES (‘Olsen’)

Question 18

sql

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

Answer 18

UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’

Question 19

sql

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

Answer 19

DELETE FROM Persons WHERE FirstName = ‘Peter’

Question 20

sql

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

Answer 20

SELECT COUNT(*) FROM Persons

Question 21

sql

What is the most common type of join?

Answer 21

INNER JOIN

Question 22

sql

Which operator is used to select values within a range?

Answer 22

RANGE

Question 23

sql

The NOT NULL constraint enforces a column to not accept NULL values.

Answer 23

False

NOT NULL prevents NULL values from being accepted

Question 24

sql

Which operator is used to search for a specified pattern in a column?

Answer 24

LIKE

Question 25

sql

Which SQL statement is used to create a database table called ‘Customers’?

Answer 25

CREATE TABLE Customers

Question 26

sql

%

Answer 26

Represents zero or more characters

Question 27

sql

_ (underscore)

Answer 27

Represents a single character

Question 28

sql

[]

Answer 28

Represents any single character within the brackets *

Question 29

slq

^

Answer 29

Represents any character not in the brackets *

Question 30

sql

-

Answer 30

Represents any single character within the specified range *

Question 31

sql

{}

Answer 31

Represents any escaped character **

Question 32

sql

SELECT

Answer 32

extracts data from a database

Question 33

sql

UPDATE

Answer 33

updates data in a database

Question 34

sql

DELETE

Answer 34

deletes data from a database

Question 35

sql

INSERT INTO

Answer 35

inserts new data into a database

Question 36

sql

CREATE DATABASE

Answer 36

creates a new database

Question 37

sql

ALTER DATABASE

Answer 37

modifies a database

Question 38

sql

CREATE TABLE

Answer 38

creates a new table

Question 39

sql

ALTER TABLE

Answer 39

modifies a table

Question 40

sql

DROP TABLE

Answer 40

deletes a table

Question 41

sql

CREATE INDEX

Answer 41

creates an index

Question 42

sql

DROP INDEX

Answer 42

deletes an index

Question 43

sql

SELECT * FROM Customers WHERE CustomerName LIKE '%es';

Answer 43

Return all customers that ends with the pattern ‘es’

Question 44

sql

SELECT * FROM Customers WHERE CustomerName LIKE '%mer%';

What does this sql block return?

Answer 44

Return all customers that contains the pattern ‘mer’

Question 45

sql

SELECT * FROM Customers WHERE City LIKE '_ondon';

What does this sql block return?

Answer 45

Return all customers with a City starting with any character, followed by “ondon”

Question 46

sql

SELECT * FROM Customers WHERE City LIKE 'L_ _ _on';

What does this sql block return?

Answer 46

Return all customers with a City starting with “L”, followed by any 3 characters, ending with “on”

Question 47

sql

SELECT * FROM Customers WHERE CustomerName LIKE '[bsp]%';

What does this sql block return?

Answer 47

Return all customers starting with either “b”, “s”, or “p”

Question 48

sql

SELECT * FROM Customers WHERE CustomerName LIKE '[a-f]%';

What does this sql block return?

Answer 48

Return all customers starting with “a”, “b”, “c”, “d”, “e” or “f”