Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Chapter: 32
Q541:
Which of the following is a tip for designing a user-friendly interface?
A. Make the user search for buttons
B. Ensure the form tests user memory
C. Be consistent in the design
D. Force users to follow strict data structures
Correct Answer:
C
Chapter: 32
Q542:
What are examples of windows controls used for input and output?
A. Buttons, checkboxes
B. Text input, dates
C. Dropdowns, sliders
D. All of the above
Correct Answer:
D
Chapter: 32
Q543:
What should be displayed in a textbox for date fields?
A. Numbers
B. Dates
C. Text
D. Time
Correct Answer:
B
Chapter: 32
Q544:
What is a key characteristic of a form in application programs?
A. Forces users to follow rules
B. Provides user control over data
C. Minimizes user input
D. Focuses on the database structure
Correct Answer:
B
Chapter: 32
Q545:
Which of the following is NOT considered a general activity in the development of application programs?
A. Data input programs
B. Editing
C. Report generation
D. User authentication
Correct Answer:
D
Chapter: 32
Q546:
In a relational database, what is the outcome of performing operations on tables?
A. A new table is produced
B. Data is deleted
C. SQL queries are generated
D. Forms are created
Correct Answer:
A
Chapter: 33
Q547:
What is the primary purpose of an input form in MS Access?
A. Enter data into a table
B. View table structure
C. Perform calculations
D. Generate reports
Correct Answer:
A
Chapter: 33
Q548:
Which tool does MS Access provide for creating predefined forms?
A. Form Designer
B. Form Wizard
C. Macro Builder
D. SQL Query Builder
Correct Answer:
B
Chapter: 33
Q549:
Which layout option was selected for the form in the example?
A. Row
B. Column
C. Grid
D. Tabular
Correct Answer:
B
Chapter: 33
Q550:
Which style option was chosen for the form's background in the lecture example?
A. SandStone
B. BlueSkies
C. GreenFields
D. Classic
Correct Answer:
A
Chapter: 33
Q551:
What must be ensured while designing input forms?
A. User-friendliness
B. Data integrity
C. Easy accessibility
D. All of the above
Correct Answer:
D
Chapter: 33
Q552:
Data integrity ensures that the database ______.
A. Is user-friendly
B. Represents the real system
C. Has a fast query speed
D. Supports large files
Correct Answer:
B
Chapter: 33
Q553:
Which database table was used for the form design example?
A. EXAM
B. COURSE
C. STUDENT
D. TEACHER
Correct Answer:
C
Chapter: 33
Q554:
What action should be taken to open a form in Design View?
A. Click ‘Open’
B. Click ‘Form View’
C. Click ‘Design View’
D. Click ‘Properties’
Correct Answer:
C
Chapter: 33
Q555:
Command buttons are used for _____.
A. Deleting records
B. Adding records
C. Opening other forms
D. Printing reports
Correct Answer:
C
Chapter: 33
Q556:
Which of the following actions can be assigned to a command button in Access?
A. Open Form
B. Save Database
C. Add User
D. Clear Cache
Correct Answer:
A
Chapter: 33
Q557:
In which view can you add a new command button to a form in MS Access?
A. Form View
B. Report View
C. Design View
D. Query View
Correct Answer:
C
Chapter: 33
Q558:
To display images on a command button, what option must be selected?
A. Show All Pictures
B. Display All Graphics
C. Enable Image Mode
D. Preview Images
Correct Answer:
A
Chapter: 33
Q559:
Which table layout was selected for the form in the example?
A. Row layout
B. Grid layout
C. Column layout
D. Custom layout
Correct Answer:
C
Chapter: 33
Q560:
Which MS Access tool helps a user to create forms with predefined templates?
A. Report Wizard
B. Query Builder
C. Form Wizard
D. Data Designer
Correct Answer:
C