Quiz5

Question 1

Sorting records returned by a SELECT statement is done with a _____ clause

a.
ORDER BY

b.
SORT ON

c.
ASCENDING

d.
GROUP BY

Answer 1

a.
ORDER BY

Question 2

SQL is used to interact with what kind of database?

a.
Relational

b.
Hierarchical

c.
Object-oriented

d.
Document

Answer 2

a.
Relational

Question 3

Standard two-part naming in SQL Server follows which convention?

a.
[server name].[table name]

b.
[database name].[schema name]

c.
[schema name].[table name]

d.
[server name].[database name]

Answer 3

c.
[schema name].[table name]

Question 4

What SQL command do you use to query a database?

a.
WHERE

b.
SELECT

c.
FROM

d.
SET

Answer 4

b.
SELECT

Question 5

Which comparison operator indicates a value is not equal?

a.
<

b.
<=

c.
>=

d.
<>

Answer 5

d.
<>

Question 6

What does the INSERT statement do?

a.
Fetch data from a database

b.
Insert new rows into a table

c.
Insert new columns into a table

d.
Insert a new table into a database

Answer 6

b.
Insert new rows into a table

Question 7

All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate?

a.
SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘___ 231 ___’

b.
SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘% 231’

c.
SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘%231%’

d.
SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘231%’

Answer 7

d.
SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘231%’