NEW
Font size
S
M
L
XL
WorksheetsSQL RDBMS BASIC
Total questions: 18
Worksheet time: 9mins
Name
Class
Date
1.
What does SQL stand for?
a)
Standard Query Language
b)
Sequential Query Language
c)
Structured Question Language
d)
Structured Query Language
2.
What is a field?
a)
A collection of information
b)
A single item of information
c)
A list of information
d)
A group of records
3.
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
4.
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
5.
Data administrator are responsible for ________
a)
Overall management of data resources in an organization
b)
Physical data design
c)
Managing technical issues in the database environment
d)
Writing application program
6.
Some advantages of the database approach include all, but:
a)
Minimal data redundancy
b)
Program-data dependency
c)
Improved data consistency
d)
Improved data sharing
7.
A relational database consists of a collection of
a)
Field
b)
Record
c)
Table
d)
Keys
8.
The term attribute refers to a ________ of a table
a)
Record
b)
Foreign key
c)
Primary key
d)
Field
9.
A_______ in a table represents a relationship among a set of values
a)
Field
b)
Foreign key
c)
Record
d)
Primary key
10.
The term _______ is used to refer a row
a)
Record
b)
Foreign key
c)
Primary key
d)
Field
11.
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
12.
Which of the following gives a logical structure of the database graphically?
a)
Entity--relationship diagram
b)
Entity diagram
c)
Database diagram
d)
Architectural representation
13.
If you were collecting and storing information about your music collection, an album would be considered a(n) _____.
a)
Relation
b)
Entity
c)
Instance
d)
Attribute
14.
The records of a table can be of ________ order.
a)
Any
b)
Same
c)
Sorted
d)
Constant
15.
A attribute in a relation is a foreign key if the _____ from one relation is used as an attribute in that relation.
a)
Record
b)
Foreign key
c)
Primary key
d)
Field
16.
which one of the following cannot be taken as a primary key?
a)
ID
b)
RegistrationNo
c)
DepartmentID
d)
Street
17.
Duplicate data often results in loss of data integrity because:
a)
A. Data formats may be inconsistent
b)
B. Data values may not agree
c)
Neither A & B
d)
Both A & B
18.
RDBMS stands for....
a)
relationship database management system
b)
relational database management system
c)
related database management system
d)
relational database management software
Reset
