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"