Top 150+ Solved Basics of Database Management System (DBMS) MCQ Questions Answer
Q. You can enter data in a table in
a. design view
b. datasheet view
c. format view
d. None of the above
Q. Creating a data file means
a. Designing base and defining the structure of the database
b. Getting the information about database
c. Selecting data from database
d. Deleting data from database
Q. In a large DBMS
a. each user can “see” only a small part of the entire database
b. each user can access every subschema
c. each subschema contains every field in the logical schema
d. none of the above is true
Q. You want to keep track of addresses, phone numbers, parent/guardian names as well as class attendance, average and grades. Every so often you want to send reports home that select failing grades and excessive absences. The following of the Microsoft Office suit used in this course is best suited for this kind of information
a. Excel
b. PowerPoint
c. Access
d. Word
Q. Each individual data items of record is called a
a. Field
b. Data type
c. Comment
d. All of the above
Q. Memo field in database file is used to
a. Store lengthy number
b. Store images
c. Store audio files
d. Store long textual information
Q. Applications that rely on databases are
a. Supermarket stock control, theater bookings and payroll
b. Accounts, online banking, PowerPoint presentations
c. Internet shopping, robotics, computer games
d. None of above
Q. Data owners must protect their data against corruption or loss. One sensible method to achieving this is to
a. Take regular backups
b. Keep a hardcopy printout of all data
c. Keep fingers crossed at all times
d. None of above
Q. Facilities offered by databases are
a. The ability to store a large amount of data in a structured format, easy update, sort, query, production of reports
b. Easy editing, spell check, perform calculations, library of mathematical functions, replication
c. The ability to rotate images, copy and paste, fill scale
d. None of above
Q. Users who store data about real people for marketing purposes must register the data and its potential use with
a. The computer misuse controller
b. The data protection controller
c. HM customs and excise
d. None of above
Q. When you double click a query object, you open
a. The object in design view
b. The object in print preview
c. The result of the query
d. The underlying table on which the query is based
Q. Checks that are added to databases to detect unsuitable data on inpt are called
a. validation
b. verification
c. vegetation
d. none of above
Q. Auto Report allows you to
a. View a subset of your data
b. Create a simple report
c. Create a data entry form
d. Enter records