Top 150+ Solved Basics of Database Management System (DBMS) MCQ Questions Answer
Q. What is a Grouped Report?
a. A type of report that can be generated by the Report Wizard
b. A report that displays data that has been sorted in ascending or descending order
c. A report that displays data grouped by fields you specify
d. None
Q. Which field allow to select items from drop down list?
a. An OLE field
b. A Memo Field
c. A lookup Field
d. A hyperlink field
Q. What did the first Table Analyzer do?
a. Analyze the data in a set of flat files and automatically create a relational database system from that information
b. Provide a graphic way to design relational databases
c. Automate process of connecting tables to SQL Server
d. None
Q. Pivot Table reports are good for
a. Analyzing large amounts of data
b. Turning tables upside down
c. Breaking spreadsheet data into multiple worksheet
d. None of above
Q. Which of the following are common ways to enforce data validation when entering data into an Access form?
a. Create an input mask to restrict the kind of value that can be entered in positions across the field.
b. Define a validation rule for that field
c. A and B
d. none of the above
Q. The purpose of the Add-in Manager is to
a. Create macros and automate data processing
b. Add or remove data in an existing database
c. Add or remove templates, macros, and wizards
d. All of above
Q. Sub-schema can be used to
a. Create very different, personalized views of the same data
b. Present information in different formats
c. Hide sensitive information by omitting fields from the subschema’s description
d. All of the above
Q. If you are entering data in a form, a quick way to cpy a value from the previous record is to press
a. Ctrl+’
b. F6
c. Ctrl+D
d. None of the above
Q. DBMS is
a. Collection of data
b. Set of programs to access those data
c. Set of programs to update those data
d. All of the above
Q. COPY STRUCTURE command is used to
a. Copy contents of an active database to a new file
b. Copy all records of an active database to disk
c. Copy contents of an active database to disk
d. Copy structure of an active database to a new file
Q. COUNT command is used to
a. Count the number of data fields in an active database file
b. Count the number of data files which are active
c. Count the records which are updated
d. Count the number of records in an active database file
Q. What is the term to ask the computer to pt information in order numerically or alphabetically ?
a. Crop
b. Report
c. Sort
d. Organize
Q. A form that is used to collect data in a structured manner for entry to a database is called a
a. Database deign form
b. Systems flowchart
c. Data capture form
d. None of above