Data Base Management System

15 Questions | By Imac2013 | Last updated: Mar 21, 2022 | Total Attempts: 312

Questions

Settings

Create your own Quiz

Paper 1

Questions and Answers

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