Top 150+ Solved Basics of Database Management System (DBMS) MCQ Questions Answer
Q. Which of the following is a database management system?
a. Ms-Word
b. Lotus 1-2-3
c. Oracle
d. None of above
Q. What is the corresponding text for the <#1/1/ 95# validation rule setting?
a. Neter a value less or more than 1,195
b. Value must be less than 95 characters
c. Enter a date before 1995
d. All of above
Q. What is the name of the Visual Basic Editor utility that allows you to view the Microsoft Access type library’s available objects and members?
a. Object Viewer
b. Object Browser
c. Type Library Spy
d. None of above
Q. A computer language for informing the DBMS regarding the data structure used is
a. PASCAL
b. DDL
c. PROLOG
d. FORTRAN
Q. The executive responsible for the data processing function in an organization is
a. PM
b. DBMS
c. DP
d. DPM
Q. Which of the following is NOT a type of Microsoft Access database object?
a. Queries
b. Workbooks
c. Forms
d. Tables
Q. A file containing relatively permanent data is
a. Random file
b. Transaction file
c. Master file
d. Sequential file
Q. The complete picture of data stored in database is known as
a. Record
b. Scheme
c. System flowchart
d. DBMS
Q. Data items groped together for storage purposes are called a
a. Record
b. Title
c. List
d. string
Q. Which of the following terms does not describe a database structure used by a DBMS to link data from several files?
a. Relational
b. Structural
c. Network
d. All of the above
Q. In a relational schema, each tuple is dividedinto fields called
a. Relations
b. Domains
c. Queries
d. All of the above
Q. How do you filter by selection?
a. Right click the field value and select filter by selection from the shortcut menu
b. Find and double click the value on which you want to base the filter
c. Find and select the value on which you want to base the filter and select tools>filter by selection from the menu
d. None of the above
Q. What is a fast way to adjust the width of a column?
a. Right click the left side of the column heading
b. Double click the left side of the column heading
c. Double click the right side of the column heading
d. Select tools>adjust column width from the menu