Introduction to Computing MCQs with Answers
Practice important Introduction to Computing MCQs with answers and explanations.
Chapter: 151
Q2141:
What is the purpose of a schema in a database system?
A. It provides a description of the entire database structure
B. It controls user access to different parts of the database
C. It defines the user interface for interacting with the database
D. It specifies the database management system used
Correct Answer:
A
Chapter: 151
Q2142:
What is a subschema used for in a database system?
A. It describes only the portion of the database relevant to a specific user
B. It provides a description of the entire database structure
C. It controls database backups
D. It specifies the database server configuration
Correct Answer:
A
Chapter: 151
Q2143:
What type of data might be excluded from a registrar's subschema in a university database?
A. Student addresses
B. Faculty employment history
C. Student academic records
D. Student phone numbers
Correct Answer:
B
Chapter: 151
Q2144:
How can a subschema protect sensitive data in a database?
A. By restricting access to specific portions of the database for different users
B. By encrypting the entire database
C. By backing up the database regularly
D. By limiting the size of the database
Correct Answer:
A
Chapter: 151
Q2145:
What information would a subschema for the payroll department likely include?
A. Faculty employment history
B. Student academic records
C. Student addresses
D. Student phone numbers
Correct Answer:
A
Chapter: 151
Q2146:
Fill in the blank: A _____ is a description of the entire database structure.
A. schema
B. subschema
C. backup
D. file system
Correct Answer:
A
Chapter: 151
Q2147:
Fill in the blank: A _____ describes only the portion of the database pertinent to a specific user's needs.
A. schema
B. subschema
C. record
D. table
Correct Answer:
B
Chapter: 151
Q2148:
Fill in the blank: The registrar’s subschema in a university database would exclude information about _____ to protect sensitive data.
A. faculty employment history
B. faculty office locations
C. faculty course schedules
D. faculty names
Correct Answer:
A
Chapter: 151
Q2149:
Fill in the blank: A subschema for the payroll department would not include the linkage between _____ and faculty members.
A. students
B. staff members
C. administrators
D. guests
Correct Answer:
A
Chapter: 151
Q2150:
Fill in the blank: To control access to sensitive information, database systems use _____ to provide different levels of data access.
A. encryption
B. permissions
C. schemas and subschemas
D. backup systems
Correct Answer:
C
Chapter: 152
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
Correct Answer:
A
Chapter: 152
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
Correct Answer:
B
Chapter: 152
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
Correct Answer:
A
Chapter: 152
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
Correct Answer:
A
Chapter: 152
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
Correct Answer:
A
Chapter: 152
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
Correct Answer:
C
Chapter: 152
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
Correct Answer:
B
Chapter: 152
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
Correct Answer:
D
Chapter: 152
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
Correct Answer:
A
Chapter: 152
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
Correct Answer:
B