Database Modeling and Design MCQs with Answers
Practice important Database Modeling and Design MCQs with answers and explanations.
Chapter: 3
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
Correct Answer:
C
Chapter: 3
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
Correct Answer:
B
Chapter: 3
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
Correct Answer:
C
Chapter: 3
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
Correct Answer:
B
Chapter: 4
Q45:
What is the first step in database development?
A. Examining documents
B. Conducting interviews
C. Observation
D. Research
Correct Answer:
A
Chapter: 4
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
Correct Answer:
A
Chapter: 4
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
Correct Answer:
B
Chapter: 4
Q48:
Which fact-finding technique involves face-to-face interaction?
A. Examining documents
B. Interviews
C. Observation
D. Research
Correct Answer:
B
Chapter: 4
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
Correct Answer:
D
Chapter: 4
Q50:
In which type of interview does the interviewee drive the discussion?
A. Structured
B. Unstructured
C. Close-ended
D. Open-ended
Correct Answer:
B
Chapter: 4
Q51:
Which of the following is an example of an unstructured interview question?
A. How do you calculate your monthly salary?
B. What illnesses are common in your village?
C. What tasks do you do to prepare monthly salaries?
D. How do you store customer data?
Correct Answer:
B
Chapter: 4
Q52:
Observing operations is particularly useful when the system is ________.
A. Simple
B. Too complex to explain
C. Highly documented
D. Well understood
Correct Answer:
B
Chapter: 4
Q53:
What is essential for successful observation in fact-finding?
A. Interrupting the user
B. Knowing as much as possible about the system
C. Collecting feedback from users
D. Asking many questions
Correct Answer:
B
Chapter: 4
Q54:
When conducting an observation, what should the observer avoid?
A. Taking notes
B. Asking too many questions
C. Observing peak periods
D. Documenting in parallel
Correct Answer:
B
Chapter: 4
Q55:
What should be the primary goal of research in the fact-finding process?
A. Saving time by finding existing solutions
B. Confirming user needs
C. Understanding user requirements
D. Creating new frameworks
Correct Answer:
A
Chapter: 4
Q56:
What type of questions are easier to tabulate in questionnaires?
A. Free-format
B. Open-ended
C. Close-ended
D. Fixed-format
Correct Answer:
D
Chapter: 4
Q57:
Which type of questionnaire offers greater freedom in answering questions?
A. Free-format
B. Fixed-format
C. Close-ended
D. Multiple choice
Correct Answer:
A
Chapter: 4
Q58:
Which method involves gathering information through specific-purpose documents?
A. Interviewing
B. Research
C. Questionnaire
D. Observing operations
Correct Answer:
C
Chapter: 4
Q59:
What is the disadvantage of fixed-format questions in a questionnaire?
A. Responses are subjective
B. Additional information might be missed
C. They take more time to tabulate
D. Respondents have too much freedom
Correct Answer:
B
Chapter: 4
Q60:
The purpose of interviews in fact-finding is to ________.
A. Verify facts
B. Lay down the foundation of a database
C. Document customer data
D. Examine documents
Correct Answer:
A