Free Printable sql test

Worksheets

sql test

Total questions: 180

Worksheet time: 2hrs 35mins

Name

Class

Date

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

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

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

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

MODIFY Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’

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

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

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

10.

Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70.

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ OR temperature > 70

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ OR temperature > 70

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ AND temperature > 70

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ AND temperature > 70

11.

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

DROP FROM CUSTOMER

UPDATE FROM CUSTOMER

REMOVE FROM CUSTOMER

DELETE FROM CUSTOMER WHERE

12.

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’);

13.

SQL is

Structured Query Language

Simple Query Language

Structured Question Language

Structure Quality Language

14.

DDL means

(a)

15.

DML

(a)

16.

To remove a record from a table which SQL statement would you use?

Remove

Cancel

Delete

Eradicate

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.

Referential Integrity is

System of rules

System of data

Table constraints

is related to Primary key

26.

______________ constraint prevents NULL values

UNIQUE

NOT NULL

NULL

FOREIGN KEY

27.

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

TRUE

FALSE

28.

What does "SQL" stand for?

Structured Question Language

Structured Query Language

Simple Query Language

Simple Question Language

29.

Which statement is used to extract data from a database?

Extract

Get

Open

Select

30.

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

Where

Order by

From

Select

31.

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

Also

And

Where

32.

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

33.

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

Update

Amend

Alter

Modify

34.

To remove a record from a table which SQL statement would you use?

Remove

Cancel

Delete

Eradicate

35.

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

Add To

Update To

Add Into

Insert Into

36.

Less than or equal to?

37.

Which character returns all the data found in a table?

38.

Which word is missing from the following SQL statement?

Select * table_name

With

Where

From

And

39.

What is the correct order of clauses in a SQL statement?

SELECT, FROM, ORDER BY, WHERE

SELECT, FROM, WHERE, ORDER BY

SELECT, WHERE, FROM, ORDER BY

WHERE, FROM, SELECT, ORDER BY

40.

How do we select all rows for the "Designer" table?

SELECT * FROM Designer

SELECT [All] FROM Designer

SELECT Designer.*

SELECT FROM Designer

41.

How would we script a SQL query to select "Description" from the Item table?

SELECT Item.Description

EXTRACT Description FROM Item

SELECT Item FROM Description

SELECT Description FROM Item

42.

Which query would return only the fields DesignerID and Designer?

SELECT * FROM Designers

SELECT DesignerID, Name FROM Designers

SELECT DesignerID AND Designer FROM Designers

SELECT DesignerID, Designer FROM Designers

43.

You are required to update the phone number for only the DesignerID "SMI01" in the "Designer" table. Which of these would successfully do that?

UPDATE Designer SET PhoneNo = '01224123456'

UPDATE Designer (PhoneNo) VALUES ('01224123456')

UPDATE Designer SET PhoneNo = '01224123456' WHERE DesignerID = 'SMI01'

UPDATE PhoneNo = '01224123456' FROM Designer WHERE DesignerID = 'SMI01'

44.

With SQL how can I return all items in the Item table sorted from the lowest priced to the highest priced?

SELECT * FROM Items ORDER BY Price ASCENDING

SELECT * FROM Items ORDER BY Price ASC

SELECT * FROM Items BY Price LOWEST TO HIGHEST

SELECT * FROM Items ORDER BY Price DESC

45.

How would you DELETE records from the Items table with a "Chair" Type?

DELETE 'Chair' FROM Items

DELETE Type FROM Items WHERE Type = 'Chair'

DELETE FROM Items WHERE Type = 'Chair'

DELETE ITEMS WHERE Type = 'Chair'

46.

How would you display Chairs in the Items table that have a Price greater than £50.

SELECT * FROM Items WHERE Type = 'Chair' AND Price > 50

SELECT * FROM Items WHERE Type = 'Chair' OR Price < 100

SELECT * FROM Iterms WHERE Type = 'Chair' AND Price >= 50

SELECT * FROM Items WHERE Price > 50

47.

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')

48.

What does SQL stand for?

Standard Query Language

Sequential Query Language

Structured Question Language

Structured Query Language

49.

Match the following SQL term with a description - FROM

The criteria which must be met

The fields to display

The field and order used to sort the results

The table used in the query

50.

Match the following SQL term with a description - SELECT

The fields to display

The table used in the query

The criteria which must be met

The field and order used to sort the results

51.

Match the following SQL term with a description - WHERE

The table used in the query

The fields to display

The field and order used to sort the results

The criteria which must be set

52.

Match the following SQL term with a description - ORDER BY

The fields to display

The field and order used to sort the results

The table used in the query

The criteria that must be met

53.

In what order does SQL process the instructions?

FROM - SELECT - WHERE - ORDER BY

WHERE - FROM - SELECT - ORDER BY

SELECT - FROM - WHERE - ORDER BY

SELECT - FROM - ORDER By - WHERE

54.

What is a field?

A collection of information

A single item of information

A list of information

A group of records

55.

Which of the following is not a database data type?

text

number

array

date

56.

Which example of the field name below is in camel case?

First Name

firstName

FIRSTNAME

firstname

57.

Which symbol would you use to represent more than 50

= 50

< 50

> 50

# 50

58.

What does "SQL" stand for?

Structured Question Language

Structured Query Language

Simple Query Language

Simple Question Language

59.

Which statement is used to extract data from a database?

Extract

Get

Open

Select

60.

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

Also

And

Where

61.

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

Update

Amend

Alter

Modify

62.

To remove a record from a table which SQL statement would you use?

Remove

Cancel

Delete

Eradicate

63.

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

Add To

Update To

Add Into

Insert Into

64.

Less than or equal to?

65.

Which character returns all the data found in a table?

66.

Which word is missing from the following SQL statement?

Select * table_name

With

Where

From

And

67.

What is the correct order of clauses in a SQL statement?

SELECT, FROM, ORDER BY, WHERE

SELECT, FROM, WHERE, ORDER BY

SELECT, WHERE, FROM, ORDER BY

WHERE, FROM, SELECT, ORDER BY

68.

What is a field?

A collection of information

A single item of information

A list of information

A group of records

69.

What does "SQL" stand for?

Structured Question Language

Structured Query Language

Simple Query Language

Simple Question Language

70.

Which statement is used to extract data from a database?

Extract

Get

Open

Select

71.

To remove a record from a table which SQL statement would you use?

Remove

Cancel

Delete

Eradicate

72.

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

Add To

Update To

Add Into

Insert Into

73.

Less than or equal to?

74.

Which character returns all the data found in a table?

75.

Which word is missing from the following SQL statement?

Select * table_name

With

Where

From

And

76.

How do we select all rows for the "Designer" table?

SELECT * FROM Designer

SELECT [All] FROM Designer

SELECT Designer.*

SELECT FROM Designer

77.

How would we script a SQL query to select "Description" from the Item table?

SELECT Item.Description

EXTRACT Description FROM Item

SELECT Item FROM Description

SELECT Description FROM Item

78.

You are required to update the phone number for only the DesignerID "SMI01" in the "Designer" table. Which of these would successfully do that?

UPDATE Designer SET PhoneNo = '01224123456'

UPDATE Designer (PhoneNo) VALUES ('01224123456')

UPDATE Designer SET PhoneNo = '01224123456' WHERE DesignerID = 'SMI01'

UPDATE PhoneNo = '01224123456' FROM Designer WHERE DesignerID = 'SMI01'

79.

With SQL how can I return all items in the Item table sorted from the lowest priced to the highest priced?

SELECT * FROM Items ORDER BY Price ASCENDING

SELECT * FROM Items ORDER BY Price ASC

SELECT * FROM Items BY Price LOWEST TO HIGHEST

SELECT * FROM Items ORDER BY Price DESC

80.

How would you DELETE records from the Items table with a "Chair" Type?

DELETE 'Chair' FROM Items

DELETE Type FROM Items WHERE Type = 'Chair'

DELETE FROM Items WHERE Type = 'Chair'

DELETE ITEMS WHERE Type = 'Chair'

81.

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

82.

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%’

83.

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

84.

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

85.

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

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

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

MODIFY Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’

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

86.

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’);

87.

In what order does SQL process the instructions?

FROM - SELECT - WHERE - ORDER BY

WHERE - FROM - SELECT - ORDER BY

SELECT - FROM - WHERE - ORDER BY

SELECT - FROM - ORDER By - WHERE

88.

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

TRUE

FALSE

89.

Which statement will show all fields and records from the table called "celebs"?

SELECT * FROM celebs;

SELECT FROM celebs;

SELECT forename, surname FROM celebs;

SELECT celebs;

90.

The SQL statement being run is:

SELECT player_name, score FROM leaderboard;

What is the name of the table in this query?

SELECT

player_name

score

leaderboard

91.

The SQL statement being run is:

SELECT player_name, score FROM leaderboard;

How many columns of results will be shown when this query is run?

92.

Which SQL statement will show the names and heights of all basketball players taller than 200?

SELECT name FROM Player WHERE height >200;

SELECT name FROM Player WHERE height >=200;

SELECT name, height FROM Player WHERE height >200;

SELECT name, height FROM Player WHERE height <200;

93.

Which SQL statement will show the names and weights of all wrestlers lighter than 170?

SELECT name, weight FROM Wrestler WHERE weight >170;

SELECT name, weight FROM Wrestler WHERE weight <= 170;

SELECT name, weight FROM Wrestler WHERE weight <170;

SELECT name, weight FROM Wrestler WHERE weight >=170;

94.

Which character always appears at the end of a SQL statement?

;

95.

Which of these statements will show all wrestlers sorted from the heaviest to the lightest?

SELECT * FROM Wrestler WHERE weight <170;

SELECT * FROM Wrestler WHERE weight >170;

SELECT * FROM Wrestler ORDER BY weight ASC;

SELECT * FROM Wrestler ORDER BY weight DESC;

96.

Which of these statements will show all wrestlers in alphabetical order of their name

SELECT * FROM Wrestler ORDER BY name ASC;

SELECT * FROM Wrestler ORDER BY name DESC;

SELECT * FROM Wrestler ORDER BY weight ASC;

SELECT * FROM Wrestler ORDER BY weight DESC;

97.

Which SQL statement will show the names and heights of all basketball players sorted from smallest to tallest?

SELECT name FROM Player ORDER BY height ASC;

SELECT name FROM Player ORDER BY height DESC;

SELECT name, height FROM Player ORDER BY height ASC;

SELECT name, height FROM Player ORDER BY height DESC;

98.

The SQL statement that was run was:

SELECT username, score FROM Player WHERE score>900;

The results were:

andy_pandy_12 911

aleeyah_nasoor_09 920

new_slang 907

utter_mess 901

How many records were returned in the query results?

99.

What does SQL stand for?

Structured Query Language

Strong Question Language

Structured Question Language

100.

The language used application programs to request data from the DBMS is referred to as __________

DDL

DML

Query Language

All of the mentioned

101.

Match SQL language with SQL commands

1)DDL i)Revok, Grant

2)DML ii)rename a table

3)TCL iii)insert, update

4)DCL iv)rollback , commit

1-iii,2-i,3-ii,4-iv

1-iii,2-ii,3-iv,4-i

1-ii,2-iii,3-iv,4-i

1-i,2-iii,3-ii,4-iv

102.

Which of the following is not a type of SQL statement?

Data Manipulation Language (DML)

Data Definition Language (DDL)

Data Control Language (DCL)

Data Communication Language (DCL)

103.

In existing table, ALTER TABLE statement is used to

Add columns

Add constraints

Delete columns

Delete constrains

All the above

104.

SQL Query to delete all rows in a table without deleting the table (structure, attributes, and indexes)

DELETE FROM table_name;

DELETE TABLE table_name;

DROP TABLE table_name;

None

105.

Correct syntax query syntax to drop a column from a table is

DELETE COLUMN column_name;

DROP COLUMN column_name;

ALTER TABLE table_name DROP COLUMN column_name;

None is correct.

106.

SQL has how many main commands for DDL:

107.

Which command is used for removing a table and all its data from the database:

Create command

Drop table command

Alter table command

All of the mentioned

108.

Which of the following language is used to specify database Schema ?

DDL

DML

DCL

None

109.

DDL Stands for ___________.

Data Management Language

Data Manupulation Language

Data Development Language

Data Definition Language

110.

SQL is

Structured Query Language

Simple Query Language

Structured Question Language

Structure Quality Language

111.

To remove a record from a table which SQL statement would you use?

Remove

Cancel

Delete

Eradicate

112.

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

Update

Amend

Alter

Modify

113.

Which statement is used to extract data from a database?

Extract

Get

Open

Select

114.

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

Add To

Update To

Add Into

Insert Into

115.

Less than or equal to?

116.

Which word is missing from the following SQL statement?

Select * table_name

With

Where

From

And

117.

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')

118.

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

DISPLAY

STRUCTURE

WHERE

SELECT

119.

______________ constraint prevents NULL values

UNIQUE

NOT NULL

NULL

FOREIGN KEY

120.

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

DELETE

REMOVE

DROP

CLEAR

121.

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

122.

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

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

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

MODIFY Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’

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

123.

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

124.

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

Also

And

Where

125.

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

126.

Which character returns all the data found in a table?

127.

What is the correct order of clauses in a SQL statement?

SELECT, FROM, ORDER BY, WHERE

SELECT, FROM, WHERE, ORDER BY

SELECT, WHERE, FROM, ORDER BY

WHERE, FROM, SELECT, ORDER BY

128.

How do we select all rows for the "Designer" table?

SELECT * FROM Designer

SELECT [All] FROM Designer

SELECT Designer.*

SELECT FROM Designer

129.

How would we script a SQL query to select "Description" from the Item table?

SELECT Item.Description

EXTRACT Description FROM Item

SELECT Item FROM Description

SELECT Description FROM Item

130.

With SQL how can I return all items in the Item table sorted from the lowest priced to the highest priced?

SELECT * FROM Items ORDER BY Price ASCENDING

SELECT * FROM Items ORDER BY Price ASC

SELECT * FROM Items BY Price LOWEST TO HIGHEST

SELECT * FROM Items ORDER BY Price DESC

131.

How would you display Chairs in the Items table that have a Price greater than £50.

SELECT * FROM Items WHERE Type = 'Chair' AND Price > 50

SELECT * FROM Items WHERE Type = 'Chair' OR Price < 100

SELECT * FROM Iterms WHERE Type = 'Chair' AND Price >= 50

SELECT * FROM Items WHERE Price > 50

132.

Match the following SQL term with a description - WHERE

The table used in the query

The fields to display

The field and order used to sort the results

The criteria which must be set

133.

Match the following SQL term with a description - ORDER BY

The fields to display

The field and order used to sort the results

The table used in the query

The criteria that must be met

134.

What is a field?

A collection of information

A single item of information

A list of information

A group of records

135.

Which of the following is not a database data type?

text

number

array

date

136.

Which example of the field name below is in camel case?

First Name

firstName

FIRSTNAME

firstname

137.

What would the SQL query pictured do?

Find all the men

Find all of the female writers

Find all of Elgar's friends

Find all the male writers

Find all the fish

138.

Which of the queries is most likely to have produced this result?

ANSWER: SELECT id, name, year FROM movies WHERE year > 2010;

ANSWER: SELECT id, name, year FROM movies WHERE year < 2010;

ANSWER: SELECT * FROM movies WHERE year > 2010;

ANSWER: SELECT id, name, year FROM movies WHERE YEAR > 2010;

139.

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

140.

To create a CHECK constraint on the "Age" column when the table "Persons" is already created, which SQL will be used:

ALTER TABLE Persons

ADD CHECK (Age>=18);

CREATE TABLE Persons

ADD CHECK (Age>=18);

CREATE TABLE Persons

CONSTRAINT (Age>=18);

DROP TABLE Persons

CONSTRAINT (Age>=18);

141.

To drop a UNIQUE constraint, use the following SQL:

ALTER TABLE Persons

________ CONSTRAINT UC_Person;

DROP

UPDATE

DELETE

REMOVE

142.

Write the correct SQL statement to create a new table called Persons.

______________ (

PersonID int,

LastName varchar(255),

FirstName varchar(255),

Address varchar(255),

City varchar(255)

);

UPDATE TABLE Persons

ALTER TABLE Persons

CREATE TABLE Persons

CREATE TABLE AS PEOPLE

143.

The following SQL ensures that the "ID", "LastName", and "FirstName" columns will NOT accept NULL values when the "Persons" table is created:

CREATE TABLE Persons (

ID int _______ ,

LastName varchar(255) ________ ,

FirstName varchar(255) _________,

Age int

);

NOT NULL for first blank only and others are NULL

NOT NULL for all 3 blanks

NULL for all 3 blanks

none of the answers

144.

The _________ constraint is used to set a default value for a column.

The default value will be added to all new records, if no other value is specified.

NULL

DEFAULT

CHECK

UNKNOWN

145.

What do the letters in CRUD stand for?

Create Read Update Delete

Craft Run Upload Database

Create Run Unrun Data

Crunch Read Uptime Downtime

146.

Which statement is used to extract data from a database?

EXTRACT

GET

OPEN

SELECT

147.

To remove a record from a table, which SQL statement would you use?

REMOVE

DELETE

CANCEL

ERADICATE

148.

What's one solid reason for us to use databases instead of just storing stuff in a variable on the server?

If the server goes down, we won't lose all our data--our data will persist between sessions

A database is a more compact way of storing the information

Accessing information from a database is faster than accessing information from a variable

It's a toss-up, really--they're both good ways of storing information

149.

Using which word allows you to specify that MORE THAN ONE condition must be met in a query?

WHERE

AND

SELECT

150.

I want to create a table in my table named "actors" with two columns: "name" and "age." What statement will do this?

CREATE TABLE actors (name TEXT, age INTEGER);

CREATE actors WITH COLUMNS (name, age);

CREATE DATABASE actors WITH COLUMNS (name TEXT, age INTEGER);

CREATE actors (name, age): TABLE, TEXT, INTEGER;

151.

I want to add the actor "Brad Pitt" (aged 56) to my table "actors." Which statement will do this?

INSERT INTO actors VALUES ("Brad Pitt", 56);

INSERT "Brad Pitt" AND 56 INTO actors;

UPDATE age = 56 WHERE name = "Brad Pitt";

CREATE ENTRY ("Brad Pitt", 56) IN TABLE actors;

152.

I want to select EVERY column and entry in my "actors" table. How can I do that?

SELECT * FROM actors;

SELECT age FROM actors;

SELECT * FROM actors WHERE age > 30;

SELECT name, age FROM actors WHERE age < 30;

153.

I want to select all columns in my "actors" table for all actors older than 30. How can I do that?

SELECT * FROM actors;

SELECT age FROM actors;

SELECT * FROM actors WHERE age > 30;

SELECT name, age FROM actors WHERE age < 30;

154.

Which aggregate function would I want to use to see which actor in my table is the oldest?

SUM

MAX

GROUP BY

WHERE

155.

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

FROM

WHERE

SELECT

ORDER BY

156.

What does “SQL” stand for?

Standard Query Language.

Structured Query Language.

Structured Quick-access Language.

Standard Questioning Language.

157.

What does a Relationship do within a database?

It reduces data redundancy by linking fields in different tables.

It shows which users in a database are related.

It increases data redundancy by linking fields in different tables.

The fields are the vertical columns in a table.

158.

What is data redundancy?

Data that is repeated multiple times.

Data that is safe from SQL attacks.

Data that is weak to SQL attacks.

Data that has no use anymore.

159.

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

SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'

SELECT [all] FROM Persons WHERE FirstName='Peter'

SELECT * FROM Persons WHERE FirstName<>'Peter'

SELECT * FROM Persons WHERE FirstName='Peter'

160.

What word is missing from the line below?

SELECT * _______ CUSTOMER WHERE Name = "Bob";

FROM

WHERE

SELECT

ORDER BY

161.

To remove a record from a table which SQL statement would you use?

Remove

Cancel

Delete

Eradicate

162.

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

Add To

Update To

Add Into

Insert Into

163.

Less than or equal to?

164.

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')

165.

How many fields are there?

166.

How many records are in this table?

167.

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

EXTRACT FirstName FROM Persons

SELECT Persons.FirstName

SELECT FirstName FROM Persons

SELECT * FROM Persons

168.

Which word is missing from the following SQL statement?

Select * table_name

With

Where

From

And

169.

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

COUNT()

NUMBER()

SUM()

COUNT(*)

170.

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

DELETE

REMOVE

DROP

CLEAR

171.

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

172.

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%’

173.

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

174.

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

175.

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

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

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

MODIFY Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’

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

176.

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

177.

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

178.

Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70.

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ OR temperature > 70

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ OR temperature > 70

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ AND temperature > 70

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ AND temperature > 70

179.

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

DROP FROM CUSTOMER

UPDATE FROM CUSTOMER

REMOVE FROM CUSTOMER

DELETE FROM CUSTOMER WHERE

180.

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’);

Reset

sql test

Total questions: 180

Worksheet time: 2hrs 35mins

Similar Resources on Wayground