wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

SQL FINAL QUIZ

Total questions: 25

Worksheet time: 19mins

Name
Class
Date
1.
a)

A. Microsoft SQL Server

b)

B. Microsoft Access

c)

C. MySQL

d)

D. Oracle

2.
a)

A. Is the database readable?

b)

B. Is the collected data correct and accurate?

c)

C. Is the data organised and formatted correctly?

d)

D. Does it make enough money?

3.
a)

A. Table

b)

B. Column

c)

C. Field

d)

D. All of the mentioned

4.
a)

A. A table constraint is declared independently from a column definition and can apply to more than one column in a table

b)

B. A column constraint is specified as part of a column definition and applies only to that column

c)

C. Primary keys allow for NULL as one of the unique values

d)

D. Table constraints must be used when more than one column must be included in a constraint

5.
a)

A. !=

b)

B. <>

c)

C. &&

d)

D. >=

6.
a)

A. prints 80

b)

B. prints garbage

c)

C. is illegal

d)

D. prints 075.971

7.
a)

A. COUNT()

b)

B. NUMBER()

c)

C. SUM()

d)

D. COUNT(*)

8.
a)

A. 20

b)

B. 10

c)

C. 200

d)

D. 0

9.
a)

A. Update only one row at a time

b)

B. Delete more than one row at a time

c)

C. Update more than one row at a time

d)

D. Delete only one row at a time

10.
a)

A. DML

b)

B. DDL

c)

C. DCL

d)

D. TCL

11.
a)

D. TCL

b)

B. employee

c)

C. from

d)

D. "IT"

12.
a)

A. Primary key

b)

B. Foreign key

c)

C. Secondary key

d)

D. None of the above

13.
a)

A. Add columns

b)

B. Edit columns

c)

C. Add constraints

d)

D. All the above

14.
a)

A. One

b)

B. Three

c)

C. Five

d)

D. Seven

15.
a)

A. Select count(Address) from HocSinh

b)

B. Select sum(1) from HocSinh

c)

C. Select count(*) from HocSinh

d)

D. Select count(ClassID) from HocSinh

16.
a)

A. Flowchart

b)

B. Table

c)

C. Relational model

d)

D. ER diagram

17.
a)

A. Network model

b)

B. Relational model

c)

C. ER model

d)

D. Hierarchical model

18.
a)

A. Define clause

b)

B. From clause

c)

C. Where clause

d)

D. Select clause

19.
a)

A. Float

b)

B. Numeric

c)

C. Decimal

d)

D. Character

20.
a)

A. When existing rows are modified.

b)

B. When a table is deleted.

c)

C. When add primary key into table

d)

D. All of the above

21.
a)

A. DELETE free the table space while TRUNCATE does not.

b)

B. Both TRUNCATE and DELETE statements free the table's space.

c)

C. Both TRUNCATE and DELETE statement does not free the table's space.

d)

D. All is incorrect.

22.
a)

A. =

b)

B. Not in

c)

C. Between

d)

D. <>

23.
a)

A. Unique

b)

B. Union

c)

C. Distinct

d)

D. Group by

24.
a)

A. Primary key can store null value, whereas a unique key cannot store null value.

b)

B. We can have only one primary key in a table while we can have multiple unique keys

c)

C. Primary key cannot be a date variable whereas unique key can be

d)

D. Foreign key cannot store null value

25.
a)

A. Attribute

b)

B. Tuple

c)

C. Relation

d)

D. Entity field