Top 150+ Solved Basics of Database Management System (DBMS) MCQ Questions Answer
Q. A set of programs that handle firm’s database responsibilities is called a
a. Database Management System (DBMS)
b. Database Processing System (DBPS)
c. Data Management System (DMS)
d. All of above
Q. Which of the following is not a relational database?
a. dBase IV
b. 4th Dimension
c. FoxPro
d. Reflex
Q. Which is used to provide the sight information to the right person at the right time for proper decision making ?
a. DBMS
b. MIS
c. ISO
d. PSO
Q. Which of the following database objects asks a question of information in a database and then displays the result?
a. Tables
b. Reports
c. Queries
d. Forms
Q. What data type should you choose for a zip code field in a table?
a. Text
b. Number
c. Memo
d. All of above
Q. A list consists of last names, first names, address and pin codes if all people in the list have the same last and the same pin code, a useful key would be
a. The pin code
b. The last name
c. A compound key consisting of the first name and the last name
d. All of the above
Q. What happens when you add the asterisk (() from any field list ot a query?
a. The table will not include any fields from the table
b. The query sorts the table’s record in the order you specify
c. The query will include every field from the table*
d. The query uses the records from the table without displaying them
Q. The criteria BETWEEN 1/1/99 and 12/31/99 would which is proper
a. Display records between the dates 1/2/ 99 and 1/1/00
b. Display records between the dates 1/1/ 99 and 12/31/99
c. Display records whose dates equaled 1/1/99 or 12/31/99
d. All of the above
Q. DDP stands for
a. Distributed Double Processing
b. Double Decimal Processing
c. Distributed Data Programming
d. Distributed Data Processing
Q. To see sales amount figures totaled, into which drop area would you drag that field?
a. Drop column fields here
b. Drop row fields here
c. Drop data items here
d. None of the above
Q. Which access feature do you use to develop applications that host access data on the web?
a. Dynamic web data
b. Data access pates
c. Html data pages
d. None of the above
Q. What is the common name for a column of data within an Access table?
a. Field
b. Record
c. Row
d. None of the above
Q. A data structure consisting of several fields, some or all of which are instances of the same data structure, is called
a. Field
b. Bead
c. Database
d. Data collection