Thursday, January 13, 2011

Database Management System and Design MCQ Set 1

Questions 1:

The ascending order of a data hirerchy is:
a. bit-byte-record-field-file-database
b. byte-bit-field-record-file-database
c. bit-byte-field-record-file-database
d. bit-byte-file-record-field-database

Question 2:

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

Question 3:

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

Question 4:

One data dictionery software package is called
a. DB/DC dictionary
d. Datapac
e. Data Manager

Question 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

Question 6:

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

Question 7:

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

Question 8:

Primitive operations common to all record management system include
a. print
b. sort
c. look-up
d. all of above

Question 9:

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

Question 10:

Information can be transferred between the DBMS and a
a. spreadsheet program
b. word processor program
c. graphics program
d. all of the above


1. c    2. b    3. e     4. a     5. c    6. c     7. d    8. c     9. a     10. d


  1. You really make it appear so easy along with your presentation but I find this matter to be actually one thing that I think I might by no means understand. It kind of feels too complex and very wide for me. I’m having a look ahead for your subsequent publish, I will attempt to get the dangle of it!
    Oracle Training

  2. Hi! I am a digital marketer. The previous seo guy working for my client left a spammy comment at your blog with the username Janice Rafael which links to my client's site.
    Such comments are or might cause serious damage to my client's site with respect to SEO which is why I am request you here by to remove it asap.
    If you don't remove it by 12:00 am, Pacific Standard Time, 2nd January 2014, we will have use Google's Disavow Tool to get back-link removed and, sorry to say this, but Google may not look too nicely upon you either for not having removed the comment. Thanks in advance for your cooperation.