NEW
Font size
S
M
L
XL
WorksheetsGAMMA-AN-06.05.2024
Total questions: 15
Worksheet time: 30mins
Name
Class
Date
1.
To uniquely identify a record in database, the key used is
a)
key
b)
Primary key
c)
Secondary key
d)
Third level key
2.
The issues that deals with the collection and use of data about individuals is
a)
Accuracy
b)
Access
c)
Privacy
d)
Publicity
3.
The database administrator is, in effect, the coordinator between them ____ and the ____
a)
Database, users
b)
Application program; database
c)
DBMS; database
d)
Application programs; users
4.
In order to understand DBMS, it is important to understand?
a)
The physical schema
b)
One sub schema
c)
All sub schema that are system support
d)
Both (a) and (b)
5.
Where will we find the referential integrity command?
a)
Table
b)
Tools
c)
Format
d)
None of these
6.
The DBMS that is most difficult to use is ____
a)
Oracle Corporation’s Oracle
b)
Microsoft’s Access
c)
Microsoft’s SQL Server
d)
None of these
7.
In a relational schema, each tuple is divided into fields called
a)
Domains
b)
Queries
c)
Relations
d)
None of these
8.
An indexing operation
a)
Establishes an index for a file
b)
Sorts a file using two keys
c)
Sorts a file using a single key
d)
Both (b) and (c)
9.
The modify operation is likely to be done after
a)
Insert
b)
Delete
c)
Look-up
d)
None of these
10.
Which command creates and initializes one or more memory variables?
a)
RELEASE
b)
KEEP
c)
STORE
d)
UPDATE
11.
The method of file organization in which data records in a file are arranged in a specified order according to key field is known as the
a)
Sequential access method
b)
Queuing method
c)
Predetermined method
d)
Direct access method
12.
Report generators are used to
a)
Store data input by a user
b)
Retrieve information from files
c)
Answer queries
d)
Both (b) and (c)
13.
The logical data structure with a one-to-many relationship is a
a)
Tree
b)
Chain
c)
Network
d)
All of these
14.
In a database, related fields are grouped to
a)
File
b)
Bank
c)
Menu
d)
Data record
15.
The database environment has all the following components except
a)
Database administrator
b)
Database
c)
Users
d)
Separate files
Reset
