Top 150+ Solved Basics of Database Management System (DBMS) MCQ Questions Answer
Q. The following term applies to a collection ofrelated records in a database
a. File
b. Layout
c. File
d. Field
Q. The following command is used to search the record that satisfies the specified criteria
a. FOUND
b. SEARCH
c. GET
d. LOCATE
Q. The data in a record is of the following types
a. four text fields and three numeric fields
b. two integer fields and five text fields
c. three text fields and four numeric fields
d. none of the above
Q. A treelike structure of records in a database.Select the best fit for answer
a. Hierarchical database structure
b. Relational database structure
c. Multidimensional database structure
d. Sequential database access
Q. The following language used by most of the DBMSs for helping their users to access data
a. High level language
b. Query language
c. SQL
d. 4GL
Q. What is a largest collection of data stored in a computer? You might use this type of program to keep a record of all the friends in your address book.
a. Information Processing
b. Spreadsheet
c. Operating system
d. Database
Q. Which command is used to replace ?
a. REPLACE
b. REPLACE ALL
c. Add record from edit menu
d. All of above
Q. The following part of a database that holds only one type of information
a. Report
b. Query
c. Record
d. Field
Q. All of the following terms are related to computerized databases except which one?
a. Search
b. Sort
c. Field names
d. Record grab
Q. Need to see all the information from two tables on one form. Insert
a. A page break
b. A subform
c. A linked command button
d. None of the above
Q. What is the primary difference between a pivot table report and a cross tab query?
a. A pivot table report can contain sums, counts, and averages while a cross tab query cannot.
b. You can’t pivot a cross tab query
c. A cross tab query lets you group similar items. A pitot table report does not
d. None of above
Q. What’s the best Access object for an invoice you’ll mail to customers?
a. A report
b. A form
c. A table
d. All of the above