Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Chapter: 33
Q561:
In MS Access, forms are mainly used to ____.
A. Enter data into tables
B. Modify SQL queries
C. Change database structure
D. Edit relationships
Correct Answer:
A
Chapter: 33
Q562:
What is one of the essential features of a user-friendly interface?
A. Complexity
B. Easy navigation
C. High security
D. Hidden features
Correct Answer:
B
Chapter: 33
Q563:
How can command buttons in a form be used?
A. Open another form
B. Close Access
C. Run a query
D. Delete a record
Correct Answer:
A
Chapter: 33
Q564:
What option is available for setting a form's background design in MS Access?
A. Color Themes
B. Wizard Styles
C. Custom Layouts
D. Form Styles
Correct Answer:
B
Chapter: 33
Q565:
What is the key benefit of using input forms in MS Access?
A. Easy data entry for unfamiliar users
B. Automates data validation
C. Ensures secure data encryption
D. Manages large datasets
Correct Answer:
A
Chapter: 33
Q566:
How do you delete a field from a form in MS Access?
A. Right-click and select delete
B. Select and press Backspace
C. Use the Form Wizard
D. Use SQL query
Correct Answer:
A
Chapter: 33
Q567:
Which of the following must be maintained when designing input forms?
A. Data validity
B. Form aesthetics
C. Database capacity
D. Form complexity
Correct Answer:
A
Chapter: 33
Q568:
What action does the Command Button Wizard help users to do in MS Access?
A. Create form titles
B. Design reports
C. Assign actions to buttons
D. Add background images
Correct Answer:
C
Chapter: 33
Q569:
How do input forms benefit a user unfamiliar with MS Access?
A. They simplify the SQL process
B. They guide data entry
C. They provide data encryption
D. They enhance database design
Correct Answer:
B
Chapter: 33
Q570:
Which MS Access tool provides step-by-step guidance in creating forms?
A. Database Wizard
B. Query Wizard
C. Form Wizard
D. Table Builder
Correct Answer:
C
Chapter: 34
Q571:
What type of storage is lost when power is turned off?
A. Non-volatile storage
B. Volatile storage
C. Flash memory
D. Magnetic disk
Correct Answer:
B
Chapter: 34
Q572:
Which of the following is a characteristic of physical storage media?
A. Speed of access
B. Power consumption
C. Number of drives
D. Operating system compatibility
Correct Answer:
A
Chapter: 34
Q573:
What is a common use for flash memory?
A. Data backup
B. Battery-powered devices
C. Main memory
D. Disk caching
Correct Answer:
B
Chapter: 34
Q574:
How does disk caching improve performance?
A. By using high-speed SRAM
B. By increasing main memory capacity
C. By storing frequently accessed data in a memory buffer
D. By encrypting data
Correct Answer:
C
Chapter: 34
Q575:
What is the purpose of RAID-0?
A. Provides fault tolerance
B. Stripes data for higher throughput
C. Mirrors data for redundancy
D. Uses error correction codes
Correct Answer:
B
Chapter: 34
Q576:
RAID-1 is also known as:
A. Striping
B. Mirroring
C. Parity
D. Error Correction
Correct Answer:
B
Chapter: 34
Q577:
Which RAID level distributes parity among drives?
A. RAID-1
B. RAID-2
C. RAID-3
D. RAID-5
Correct Answer:
D
Chapter: 34
Q578:
What is a key advantage of RAID-5 over RAID-4?
A. Faster read speeds
B. Lower cost per megabyte
C. Higher fault tolerance
D. Better write performance
Correct Answer:
B
Chapter: 34
Q579:
What kind of caching uses high-speed SRAM instead of DRAM?
A. Disk caching
B. Memory caching
C. Flash caching
D. Magnetic caching
Correct Answer:
B
Chapter: 34
Q580:
A memory cache that is built into the architecture of microprocessors is referred to as:
A. Level 1 (L1) cache
B. Level 2 (L2) cache
C. External cache
D. Disk cache
Correct Answer:
A