wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Introduction to SQL (Grade 12)

Total questions: 15

Worksheet time: 8mins

Name
Class
Date
1.

A collection of information that is organized so that it can be easily accessed, managed and updated is called

a)

file.

b)

array.

c)

database.

d)

function.

2.

The relational model has relationship between tables using primary keys, foreign keys and indexes.

a)

True

b)

False

3.

How many types of SQL commands are there?

a)

Two

b)

Three

c)

Four

d)

Five

4.

A type of SQL language used to define the structure that holds the data is

a)

DDL

b)

DML

c)

DCL

5.

A type of SQL language used to control the visibility of data is

a)

DDL

b)

DML

c)

DCL

6.

A type of SQL language used for manipulation of data itself is called

a)

DDL

b)

DML

c)

DCL

7.

Create, Alter and Drop are the examples of

a)

DDL

b)

DML

c)

DCL

8.

Grant and Revoke are examples of

a)

DDL

b)

DML

c)

DCL

9.

Select and Insert are examples of

a)

DDL

b)

DML

c)

DCL

10.

Update and Delete are examples of

a)

DDL

b)

DML

c)

DCL

11.

A classic query engine handles all the non-SQL queries

a)

True

b)

False

12.

A SQL query engine can handle logical files

a)

True

b)

False

13.

A Relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model.

a)

True

b)

False

14.

The fetching and storing of data become slower by using relationships between tables.

a)

True

b)

False

15.

The columns in a database table are called as records.

a)

True

b)

False