Font size
S
M
L
XL
WorksheetsDatabase Concepts
Total questions: 10
Worksheet time: 2mins
Name
Class
Date
1.
The number of rows in a relation
a)
degree
b)
tuple
c)
cardinality
d)
domain
2.
SQL stands for
(a)
3.
What type of commands are GRANT and REVOKE?
a)
DML
b)
DDL
c)
TCL
d)
DCL
4.
Data about data is ______________
a)
Data Description
b)
Metadata
c)
Data redundancy
d)
Data inconsistency
5.
Which of these could be a primary key?
a)
Centre number
b)
Surname
c)
Teacher name
d)
Students addresses
6.
How many records are in this database?
a)
8
b)
5
c)
9
d)
12
7.
What is the primary key in this database?
a)
Emp_Id
b)
Last Name
c)
Gender
d)
Title
8.
Which SQL statement is used to extract data from a database?
a)
OPEN
b)
GET
c)
EXTRACT
d)
SELECT
9.
Which SQL statement is used to delete data from a database?
a)
COLLAPSE
b)
DELETE
c)
REMOVE
d)
DROP
10.
Which SQL statement is used to update data in a database?
a)
SAVE
b)
SAVE AS
c)
UPDATE
d)
MODIFY
Reset
