Introduction to Computing MCQs with Answers
Practice important Introduction to Computing MCQs with answers and explanations.
Multiple Choice Questions
Q2151: What are the two major layers in a typical database application?
- A: Application layer and database management layer
- B: Application layer and user interface layer
- C: Database layer and query processor layer
- D: Storage layer and application layer
View Answer
A
Q2152: What role does the Database Management System (DBMS) play in a database application?
- A: It manipulates the database directly based on user requests
- B: It handles the user interface for the database
- C: It processes client requests from a website
- D: It stores data on multiple machines
View Answer
B
Q2153: How does separating application software from the DBMS benefit software design?
- A: It allows for simplified application software design and abstracts database storage details
- B: It enhances the security of the database
- C: It speeds up the data retrieval process
- D: It reduces the need for database backups
View Answer
A
Q2154: What does data independence in a database system mean?
- A: The ability to change the database structure without affecting application software
- B: The ability to encrypt data independently of the application
- C: The ability to keep data in a single location
- D: The ability to use multiple types of databases
View Answer
A
Q2155: What can the DBMS enforce when separating application software and the database?
- A: The restrictions imposed by various subschemas
- B: The encryption standards for the database
- C: The user interface design requirements
- D: The network connectivity settings
View Answer
A
Q2156: Fill in the blank: The application software in a database system handles communication with the _____, while the DBMS manages the database itself.
- A: user
- B: website
- C: clients
- D: software
View Answer
C
Q2157: Fill in the blank: One advantage of using a DBMS is that it provides a means to control access to the database by enforcing restrictions described in the database’s _____.
- A: schema
- B: subschemas
- C: queries
- D: transactions
View Answer
B
Q2158: Fill in the blank: Data independence allows for changes to the database organization without needing to modify the _____ that interacts with the database.
- A: DBMS
- B: system
- C: application software
- D: user interface
View Answer
D
Q2159: Fill in the blank: When the personnel department needs to add a new field to the employee records, the DBMS can handle the change without requiring modifications to all _____ programs.
- A: application
- B: backup
- C: network
- D: security
View Answer
A
Q2160: Fill in the blank: The separation between application software and DBMS helps to manage changes to the database schema without affecting the _____.
- A: security settings
- B: application software
- C: network configuration
- D: data backups
View Answer
B