Data Base Management System
Settings
Paper 1
- 1.What is the language used by most of the DBMSs for helping their users to access data?
- A.
High level language
- B.
SQL
- C.
Query Language
- D.
4GL
- 2.Which of the following is a problem of file management system?
- A.
Difficult to update
- B.
Lack of data independence
- C.
Data redundancy
- D.
program dependence
- E.
All of above
- 3.Which of the following is true of a network structure?
- A.
t is a physical representation of the data
- B.
It allows a many-to-many relationship
- C.
It is conceptually simple
- D.
It will be dominant data base of the future
- 4.One data dictionery software package is called
- A.
DB/DC dictionary
- B.
TOTAL
- C.
ACCESS
- D.
Data Manager
- E.
Datapac
- 5.The function of a database is
- A.
To check all input data
- B.
To check all spelling
- C.
To collect and organize input data
- D.
To output data
- 6.The model for a record management system might be
- A.
Handwritten list
- B.
A Rolodex card file
- C.
A business form
- D.
All of above
- 7.Primitive operations common to all record management system include
- A.
Print
- B.
Sort
- C.
Look-up
- D.
All of above
- 8.In a large DBMS
- A.
Each user can "see" only a small part of the entire database
- B.
Each subschema contains every field in the logical schema
- C.
Each user can access every subschema
- D.
All of the above
- 9.Which of the following fields in a student file can be used as a primary key?
- A.
Class
- B.
Social Security Number
- C.
GPA
- D.
Major
- 10.Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?
- A.
Report writer
- B.
Data manipulation language
- C.
Transaction log
- D.
Query language
- 11.In the DBMS approach, application programs perform the
- A.
Storage function
- B.
Processing functions
- C.
Access control
- D.
None of the above
- 12.A set of programs that handle a firm's database responsibilities is called
- A.
Database management system (DBMS)
- B.
Database processing system (DBPS)
- C.
Data management system (DMS)
- D.
All of above
- 13.Which is the make given to the database management system which is able to handle full text data, image data, audio and video?
- A.
Full media
- B.
Multimedia
- C.
Graphics media
- D.
Hypertext
- 14.A record management system
- A.
Can be used to extract information stored in a computer file
- B.
Always uses a list as its model
- C.
Can handle many files of information at a time
- D.
Both a and b
- 15.A command that lets you change one or more fields in a record is
- A.
Lookup
- B.
Insert
- C.
Delete
- D.
Modify
Back to top