Top 150+ Solved Basics of Database Management System (DBMS) MCQ Questions Answer
Q. Auto Form allows you to
a. View a subset of your data
b. Create a simple report
c. Create a data entry form
d. Enter records
Q. The asterisk (*) is sometimes used in database queries. This character is then called a
a. Wildcard
b. Dummy
c. Ditto
d. All of the above
Q. When performing a look-up operation using a form
a. You enter the search value into the form
b. You look at each form sequentially until you see the one you want
c. You type the key in an entry line, and the correct form is displayed
d. All of the above
Q. Which custom date format displays the numeric day of the year when a date is entered?
a. YY
b. YYYY
c. Y
d. All of above
Q. When you save an Access project, what fileformat do you use?
a. .adp
b. .xm.
c. .mdb
d. All of above
Q. Which of the following criterion would find records whose personality field does not equal “Nice”?
a. <>Nice
b. NOT Nice
c. <>”Nice”
d. IS NOT Nice
Q. What is the maximum character field size you can set for a field that has a text data type?
a. 64
b. 255
c. 512
d. All of above
Q. Which of the following fields would not make a suitable primary key ?
a. A date field
b. An invoice number
c. An autoNumber field
d. A customer’s social security number
Q. Auto reports can contain each of the following elements except
a. A detail section
b. A page footer
c. A group header
d. All of the above
Q. A repository for data, usually covering some specific topic is called
a. Data acquisition
b. Data bank
c. Real time
d. Database
Q. A notation for defining the form and structure of data is known as
a. Data description language
b. Binary language
c. Data channels
d. Data definition language
Q. A data item, which is not broken down into smaller units, is
a. Data element
b. Elementary data item
c. Data entry
d. Database management
Q. Which of the following terms refers to the degree to which data in database system are accurate and correct?
a. Data security
b. Data validaity
c. Data independence
d. Data integrity
Q. A repository for data, usually covering specific topic is
a. Database
b. Data requisition
c. Data bank
d. Data collection