Introduction to Computing MCQs with Answers
Practice important Introduction to Computing MCQs with answers and explanations.
Multiple Choice Questions
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
View Answer
A
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
View Answer
A
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
View Answer
B
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
View Answer
A
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
View Answer
A
Q2146: Fill in the blank: A _____ is a description of the entire database structure.
- A: schema
- B: subschema
- C: backup
- D: file system
View Answer
A
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
View Answer
B
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
View Answer
A
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
View Answer
A
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
View Answer
C