Database Modeling and Design MCQs with Answers
Practice important Database Modeling and Design MCQs with answers and explanations.
Multiple Choice Questions
Q41: Which of the following is a characteristic of distributed processing?
- A: Single server handling all tasks
- B: No communication between components
- C: Multiple systems coordinating tasks
- D: Centralized data storage
View Answer
C
Q42: In Client-Server architecture, a chat application is an example of how _______.
- A: Only one client interacts with a server
- B: Servers forward messages to all clients
- C: Messages are stored permanently in the client
- D: Clients communicate with servers but not with each other
View Answer
B
Q43: Which role in DBMS is responsible for the physical realization of the database?
- A: System Analyst
- B: End User
- C: Database Administrator
- D: Application Programmer
View Answer
C
Q44: What does the term 'tiers' refer to in 3-Tier Architecture?
- A: Database storage units
- B: Logically related components
- C: Network protocols
- D: Application software versions
View Answer
B
Q45: What is the first step in database development?
- A: Examining documents
- B: Conducting interviews
- C: Observation
- D: Research
View Answer
A
Q46: Which of the following is a critical technique for identifying data to be collected and reported?
- A: Examining documents
- B: Conducting interviews
- C: Observation
- D: Research
View Answer
A
Q47: What is the key purpose of documenting existing systems in fact-finding?
- A: To create user stories
- B: To lay the foundation of database design
- C: To analyze stakeholders' objectives
- D: To organize user feedback
View Answer
B
Q48: Which fact-finding technique involves face-to-face interaction?
- A: Examining documents
- B: Interviews
- C: Observation
- D: Research
View Answer
B
Q49: What is the difference between structured and unstructured interviews?
- A: Structured interviews have open-ended questions
- B: Unstructured interviews have specific questions
- C: Structured interviews are informal
- D: Unstructured interviews lack specific questions
View Answer
D
Q50: In which type of interview does the interviewee drive the discussion?
- A: Structured
- B: Unstructured
- C: Close-ended
- D: Open-ended
View Answer
B