Free Printable STRUCTURED QUERY LANGUAGE

Worksheets

STRUCTURED QUERY LANGUAGE

Total questions: 46

Worksheet time: 26mins

Name

Class

Date

ENTER YOUR NAME

4 lines

CLASS & SECTION

12 A

12 B

12 D

12 A (JP)

12 F(JP)

BRANCH

MEERA BAGH

JANAK PURI

Which SQL function is used to count the number of rows in a SQL query?

COUNT()

NUMBER()

SUM()

COUNT(*)

Which of the following SQL clauses is used to DELETE tuples from a database table?

DELETE

REMOVE

DROP

CLEAR

If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default

ASC

DESC

There is no default value

None of the mentioned

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

SELECT * FROM Persons WHERE FirstName=’a’

SELECT * FROM Persons WHERE FirstName LIKE ‘a%’

SELECT * FROM Persons WHERE FirstName LIKE ‘%a’

SELECT * FROM Persons WHERE FirstName=’%a%’

What does the ALTER TABLE clause do?

The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints

The SQL ALTER TABLE clause is used to insert data into database table

THE SQL ALTER TABLE deletes data from database table

The SQL ALTER TABLE clause is used to delete a database table

The UPDATE SQL clause can _____________

update only one row at a time

update more than one row at a time

delete more than one row at a time

delete only one row at a time

10.

SQL query to find all the cities whose humidity is 95.

SELECT city WHERE humidity = 95

SELECT city FROM weather WHERE humidity = 95

SELECT humidity = 89 FROM weather

SELECT city FROM weather

11.

SQL query to find the temperature in increasing order of all cities.

SELECT city FROM weather ORDER BY temperature

SELECT city, temperature FROM weather

SELECT city, temperature FROM weather ORDER BY temperature

SELECT city, temperature FROM weather ORDER BY city

12.

The command to remove rows from a table ‘CUSTOMER’ is __________________

DROP FROM CUSTOMER

UPDATE FROM CUSTOMER

REMOVE FROM CUSTOMER

DELETE FROM CUSTOMER WHERE

13.

Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy.

SELECT city, temperature, condition FROM weather WHERE condition NOT IN (‘sunny’, ‘cloudy’)

SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN (‘sunny’, ‘cloudy’)

SELECT city, temperature, condition FROM weather WHERE condition IN (‘sunny’, ‘cloudy’)

SELECT city, temperature, condition FROM weather WHERE condition BETWEEN (‘sunny’, ‘cloudy’);

14.

SQL is

Structured Query Language

Simple Query Language

Structured Question Language

Structure Quality Language

15.

DDL means

(a)

16.

DML

(a)

17.

In order to modify data in a database we would use which SQL statement?

Update

Amend

Alter

Modify

18.

Which statement is used to extract data from a database?

Extract

Get

Open

Select

19.

Which statement allows us to add a record to a table?

Add To

Update To

Add Into

Insert Into

20.

Less than or equal to?

21.

Which word is missing from the following SQL statement?

Select * table_name

With

Where

From

And

22.

Which SQL statement would add a record to the database?

INSERT INTO Designer VALUES ('SMI01', 'M Smith', 'mail@msmith.com', '01224123456')

INSERT VALUES ('SMI01', 'M Smith', 'mail@msmith.com', 01224123456') INTO Designer

INSERT ('SMI01', 'M Smith', 'mail@msmith.com', '01224123456') INTO Designer

INSERT Designer INTO VALUES (''SMI01', 'M Smith', 'mail@msmith.com', '01224123456')

23.

Where does the CREATE Command belong?

DML

DDL

DCL

24.

It is a DML command that is used to display record.

DISPLAY

STRUCTURE

WHERE

SELECT

25.

A primary key can be NULL in the table? TRUE or FALSE

TRUE

FALSE

26.

Write a code for the following: Return the names and imdb_ratings of all movies with ‘day’ in the name.

SELECT * FROM movies WHERE name LIKE ‘day’;

RETURN name, imdb_rating FROM movies WHERE name LIKE '%day%';

SELECT name, imdb_rating FROM movies WHERE name LIKE '%day%';

SELECT * FROM movies WHERE imdb_rating AND name LIKE ‘%day%’;

27.

A column in a database

record

row

field

data

28.

Return all dramas made after 2004.

SELECT * FROM movies WHERE genre = 'drama';

SELECT * FROM movies WHERE genre = 'drama' AND year > 2004;

SELECT * FROM movies WHERE genre = "drama' AND year < 2004;

SELECT * FROM movies WHERE imdb_rating = 7 AND LIMIT = 7

29.

What is a special value in SQL that represents missing or unknown data?

NULL

30.

Write the code for the following : Return all movies with the word love.

SELECT * FROM movies WHERE name LIKE %love%;

SELECT * FROM movies WHERE name LIKE ‘love’;

SELECT * FROM movies WHERE name LIKE %love;

SELECT * FROM movies WHERE name LIKE ‘%love%’;

31.

What is wrong with the following code: SELECT * FROM movies WHERE genre = comedy AND year < 2016 ORDER BY year DESC;

Comedy should have single quotes around it

AND should be lower case

movies should be capitalized

No changes should be made

32.

What does * mean when writing code?

Select all columns

Select all rows

Select all genres

Select jaskfjfjfjsfjiosjisjfjsfjsfjkjsk

33.

What is missing in this code? SELECT * FROM WHERE genre = ‘action’ ORDER BY year ASC;

Missing an AND

Table name

Capitalize action

None of these

34.

What word is missing from the line below?
SELECT *
_______ CUSTOMER;

FROM

WHERE

SELECT

ORDER BY

35.

What is the purpose of *?

Selects ALL fields from the table

Selects only the first field in the table

Selects the last field in the table

Shows only the first row in the table

36.

Return only the customers who have ER anywhere in their last name.

last_name LIKE "%er%"

last_name = "%er"

last_name = "%er%"

last_name LIKE "%er"

37.

Which clause allows you to SORT data?

ORDER BY

WHERE

FROM

HAVING

38.

What represents no value?

NULL

" "

N/A

39.

SELECT MAX(price)
FROM PRODUCT
will return how many rows?

As many rows that are in the table

40.

AVG, COUNT, MAX, MIN and SUM are known as what?

Aggregate functions

Wildcard filters

Subqueries

Calculated field

41.

If you were wanting to filter data, which clause would you use?

Where

Order by

From

Select

42.

Which character returns all the data found in a table?

43.

Which symbol would you use to represent more than 50

= 50

< 50

> 50

# 50

44.

Using which word allows you to specify that more than one condition must be met in a query?

Also

And

Where

45.

In order to amend data in a database we would use which SQL statement?

Update

Amend

Alter

Modify

46.

Using which word allows you to specify that only one of a series of conditions needs to be met in a query filter?

And

Maybe

100 %

STRUCTURED QUERY LANGUAGE

Total questions: 46

Worksheet time: 26mins

Similar Resources on Wayground