wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Revision database

Total questions: 45

Worksheet time: 23mins

Name
Class
Date
1.
The following are functions of a DBMS except
a)
Creating database
b)
Processing data
c)
Creating and processing forms
d)
Administrating database
2.
Which is the best example of a primary key?
a)
Driver's License Number
b)
Home Runs Hit
c)
Price
d)
First and Last Name
3.
The front-end of a database is known as a _____.
a)
form
b)
report
c)
query
d)
website
4.
The following are functions of a DBMS except
a)
Creating database
b)
Processing data
c)
Creating and processing forms
d)
Administrating database
5.
A database management system (DBMS) is a:
a)
Software system used to create, maintain, and provide controlled access to a database
b)
Hardware system used to create, maintain, and provide controlled access to a database
c)
Hardware system used to create, maintain, and provide uncontrolled access to a database
d)
Software system used to create, maintain, and provide uncontrolled access to a database
6.
A database application can perform which of the following activities?
a)
Add records
b)
Display / read records
c)
Update records
d)
All of the above
7.
A relational database consists of a collection of
a)
Field
b)
Record
c)
Table
d)
Keys
8.
The term _______ is used to refer a row
a)
Record
b)
Foreign key
c)
Primary key
d)
Field
9.
Consider attributes ID, CITY, and NAME. Which one if this can be considered as a primary key?
a)
NAME
b)
ID
c)
CITY
d)
ID, NAME
10.

Which statement is used to extract data from a database?

a)

Extract

b)

Get

c)

Open

d)

Select

11.

Which character returns all the data found in a table?

a)

%

b)

#

c)

*

d)

/

12.

Which word is missing from the following SQL statement?


Select * table_name

a)

With

b)

Where

c)

From

d)

And

13.

Where does the CREATE Command belong?

a)

DML

b)

DDL

c)

DCL

14.
What is a special value in SQL that represents missing or unknown data?
a)
%
b)
?
c)
NULL
d)
*
15.

Which SQL statement is used to insert new data in a database?

a)

ADD NEW

b)

INSERT INTO

c)

ADD RECORD

d)

INSERT NEW

16.

 ___________ which helps to uniquely identify a record.

a)

Check key

b)

Tuple

c)

Default key

d)

Primary key

17.

What does the "Q" in SQL stand for?

a)

Question

b)

Query

c)

Quotes

d)

Queue

18.

Which SQL statement is used to update data in a database?

a)

SAVE AS

b)

MODIFY

c)

ALTER

d)

UPDATE

19.

With SQL, how do you select all the columns from a table named "EMPLOYEE"?

a)

SELECT EMPLOYEE

b)

SELECT * EMPLOYEE

c)

SELECT * FROM EMPLOYEE

d)

SELECT ALL FROM EMPLOYEE

20.

Backup data means 

a)

Creating a copy / duplicate of the data on your system

b)

Backward storage of the data

c)

Moving back and forth in the database

d)

Creating a data on your system

21.

Attribute in a database means 

a)

Rows

b)

Columns

c)

Cell

d)

Table

22.

What is HH:MM:SS format in MySQL?

a)

Hospital Management System

b)

Headings Managed Sequentially

c)

Heavy Machine System

d)

Hours Minutes Second

23.

MySQL stores data in the 

a)

Cell

b)

Rows

c)

Columns

d)

Tables

24.

What is missing at the end of the statement

SELECT CustomerName, City, Country FROM Customers

a)

?

b)

,

c)

;

d)

*

25.

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

a)

COUNT()

b)

NUMBER()

c)

SUM()

d)

COUNT(*)

26.

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

a)

DELETE

b)

REMOVE

c)

DROP

d)

CLEAR

27.

What is the correct syntax to create a table on MySQL

a)

CREATE TABLE <tablename>

b)

CREATE ENTITY <tablename>

c)

CREATE COLLECTION <tablename>

d)

CREATE RECORD <tablename>

28.

Replace the missing word:

CREATE TABLE departments (
name _____,
)

a)

varchar(255)

b)

string(255)

c)

letters(255)

d)

words(255)

29.

How would we represent a column referencing another table as the a foreign key?

a)

FOREIGN KEY (department_id) REFERENCES departments(id)

b)

FOREIGN KEY departments(id)

REFERENCES (department_id),

c)

FOREIGN KEY REFERENCES

departments(id)

(department_id),

d)

FOREIGN KEY

REFERENCES

(department_id) departments(id)

30.

To create a record into a users table, what would be the correct syntax?

a)

insert from users (name) values ("stephen");

b)

insert into users (name) values ("stephen");

c)

insert where users (name) values ("stephen");

d)

insert when users (name) values ("stephen");

31.

Which SQL statement is used to update data in a database?

a)

SAVE AS

b)

CHANGE

c)

UPDATE

d)

MODIFY

32.

Which SQL statement is used to delete data from a database?

a)

REMOVE

b)

DELETE

c)

COLLAPSE

d)

DROP

33.

Which SQL statement is used to insert new data in a database?

a)

ADD RECORD

b)

ADD NEW

c)

INSERT NEW

d)

INSERT INTO

34.

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

a)

EXTRACT FirstName FROM Persons

b)

SELECT FirstName FROM Persons

c)

SELECT Persons.FirstName

d)

Select Persons FROM FirstName

35.

Which data manipulation command is used to combines the records from one or more tables?

a)

SELECT

b)

PROJECT

c)

JOIN

d)

PRODUCT

36.

In which of the following cases a DML statement is not executed?

a)

When existing rows are modified.

b)

When a table is deleted.

c)

When some rows are deleted.

d)

All of the above

37.

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

a)

DISPLAY

b)

STRUCTURE

c)

WHERE

d)

SELECT

38.

It is a flexible language that is used to communicate with a relational database such as MariaDB

a)

Java

b)

PhpMyAdmin

c)

SQL

d)

MariaDB

39.

What is the meaning of DDL?

a)

Data Definition Language

b)

Database definition Language

c)

Data Definition Link

d)

Data Division Langauge

40.

What is the meaning of DML?

a)

Database Manipulation Language

b)

Data Manipulative Language

c)

Data Manipulation Language

d)

Data Management Language

41.

What is the meaning of DCL?

a)

Data Count Language

b)

Database Control Language

c)

Data Calculation Language

d)

Data Control Language

42.

What is the commands that define a database, including creating, altering, and dropping tables and establishing constraints

a)

DCL

b)

DDL

c)

DML

d)

SQL

43.

It is a command from DML that is used to remove an existing record.

a)

DROP

b)

DELETE

c)

ERASE

d)

EDIT

44.

Which of the following is not a database data type?

a)

varchar

b)

int

c)

array

d)

date

45.

Which SQL statement would add a record to the database?

a)

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

b)

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

c)

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

d)

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

Similar Resources on Wayground

Programación y robótica educativa (OpcMul)

50 questions

Programación y robótica educativa (OpcMul)

quiz

Worksheet

•

Professional Development

ITIL SERVICE LIFECYCLE

41 questions

ITIL SERVICE LIFECYCLE

quiz

Worksheet

•

Professional Development

21 st Century Literacy Skills

40 questions

21 st Century Literacy Skills

quiz

Worksheet

•

Professional Development

Java Collections Trivia

45 questions

Java Collections Trivia

quiz

Worksheet

•

Professional Development

T2 - Seguridad Pasiva - Seguridad Informática

46 questions

T2 - Seguridad Pasiva - Seguridad Informática

quiz

Worksheet

•

Professional Development

Paginas Web EPO 62

40 questions

Paginas Web EPO 62

quiz

Worksheet

•

3rd Grade - Professio...

Microsoft 365 Test

42 questions

Microsoft 365 Test

quiz

Worksheet

•

Professional Development

Pre_Place_Batch_2027_SET_C

40 questions

Pre_Place_Batch_2027_SET_C

quiz

Worksheet

•

Professional Development