Q1. What is the primary purpose of a form in system design?
A) To display summarized data only
B) To capture and input data from users
C) To create relational database tables automatically
D) To ensure referential integrity
Answer: B) To capture and input data from users
Explanation:
Forms are interactive documents designed for data input. They may contain predefined data, but
their main purpose is to allow users to enter new information into the database. Reports, on the
other hand, summarize existing data.
Q2. Which of the following is NOT a key question when designing forms and reports?
A) Who will use the form or report?
B) What is the font size used in the report?
C) What is the purpose of the form or report?
D) When and where will the form or report be used?
Answer: B) What is the font size used in the report?
Explanation:
User-centered design focuses on who, what, when, where, and how the form/report will be
used. Font size is a low-level design detail and considered later in implementation.
Q3. Which text display guideline is correct for interface design?
A) Use uppercase letters only for all text
B) Left-justify text with a ragged right margin
C) Hyphenate words between lines for readability
D) Abbreviations should always be avoided
Answer: B) Left-justify text with a ragged right margin
Explanation:
Left justification improves readability. Uppercase text, unnecessary abbreviations, and
hyphenation reduce clarity, especially in data-heavy forms and reports.
Q4. Highlighting information in a form or report should be:
A) Used for all data fields equally
B) Used sparingly for emphasis on critical information
C) Avoided completely to reduce visual clutter
D) Applied using only blinking text
Answer: B) Used sparingly for emphasis on critical information
Explanation:
Highlighting draws attention to errors, warnings, or high-priority messages. Overuse, especially
blinking or loud alerts, can confuse or frustrate users.
Q5. Which of the following best defines functional dependency?
A) A relationship where two tables share the same number of rows
B) A condition where the value of one attribute uniquely determines another attribute
C) A situation where all attributes are primary keys
D) A rule for arranging forms and reports
Answer: B) A condition where the value of one attribute uniquely determines another attribute
Explanation:
Functional dependency, denoted as A → B, is a key concept in normalization. It identifies
relationships that help remove redundancy and anomalies in relational tables.
Q6. A table is in First Normal Form (1NF) if:
A) It has no duplicated rows and all columns are atomic
B) It has no foreign keys
C) All attributes are dependent on the primary key
D) It has transitive dependencies
Answer: A) It has no duplicated rows and all columns are atomic
Explanation:
1NF eliminates repeating groups and ensures each cell contains a single value, providing the
foundation for higher normal forms.
Q7. In the EMPLOYEE1 relation, if the Salary of Emp_ID 100 is updated in only one row,
which anomaly occurs?
A) Insertion anomaly
B) Deletion anomaly
C) Update anomaly
D) Referential integrity violation
Answer: C) Update anomaly
Explanation:
Salary is repeated for the same employee across multiple rows. Updating only one row creates
inconsistent data, an update anomaly, which normalization to 2NF resolves.
Q8. Which of the following is the main purpose of Third Normal Form (3NF)?
A) To remove duplicate tables
B) To remove transitive dependencies between non-primary-key attributes
C) To ensure all attributes are numeric
D) To allow multiple values in a single cell
Answer: B) To remove transitive dependencies between non-primary-key attributes
Explanation:
3NF eliminates redundancy caused by attributes depending on other non-key attributes. This
ensures all attributes relate only to the primary key.
Q9. What is a foreign key?
A) A key that is unique in its own table only
B) An attribute that appears as a primary key in one table and a non-primary key in another
C) A composite key
D) A key that stores all data redundantly
Answer: B) An attribute that appears as a primary key in one table and a non-primary key in
another
Explanation:
Foreign keys maintain relationships between tables. They support referential integrity, ensuring
that linked data exists in the referenced table.
Q10. Which of the following is NOT part of physical database design?
A) Choosing data types for attributes
B) Defining key indexes for faster access
C) Normalizing tables to 3NF
D) Determining stored record structure
Answer: C) Normalizing tables to 3NF
Explanation:
Normalization occurs during logical design, not physical design. Physical design focuses on
storage, performance, and access optimization in the RDBMS.
Q11. In a relational database, which property ensures that the order of rows does not affect the
meaning of the data?
A) Atomicity
B) Row sequence independence
C) Referential integrity
D) Functional dependency
Answer: B) Row sequence independence
Explanation:
In relational tables, rows can be stored or displayed in any order without affecting the meaning
of the data, because relationships are defined by keys, not sequence.
Q12. Which guideline is correct when designing tables and lists for reports?
A) Right-justify textual data and left-justify numeric data
B) Use meaningful labels and allow white space for notes
C) Display all data on one screen without scrolling
D) Never separate labels from data
Answer: B) Use meaningful labels and allow white space for notes
Explanation:
Clear labeling and spacing improve readability and usability, especially in printed or digital
reports. Proper formatting prevents errors and user confusion.
Q13. Which of the following is a technique to prevent data entry errors?
A) Ignoring default values
B) Using context-sensitive help
C) Allowing blank entries in mandatory fields
D) Requiring manual computation for all fields
Answer: B) Using context-sensitive help
Explanation:
Context-sensitive help guides the user during data entry, reducing mistakes. Other techniques
include validation rules, default values, and proper formatting.
Q14. A table containing EMP_ID, Name, Department, Salary, and Model is in 2NF but has
Model → Manufacturer. What is this dependency called?
A) Partial dependency
B) Transitive dependency
C) Primary key dependency
D) Foreign key dependency
Answer: B) Transitive dependency
Explanation:
Manufacturer depends on Model (non-key attribute), not on the primary key. This is a transitive
dependency, which 3NF removes by creating a separate table.
Q15. What happens if referential integrity is violated in a relational database?
A) Data becomes partially or fully invalid
B) Normalization improves
C) Forms and reports automatically update
D) Primary keys become composite
Answer: A) Data becomes partially or fully invalid
Explanation:
Referential integrity ensures that foreign key values exist in the referenced table. Violation can
lead to orphaned records and inconsistent data.
Q16. Which of the following is TRUE about a report in system design?
A) It allows users to input data interactively
B) It contains only predefined data for viewing
C) It can never be derived from multiple records
D) It is always a single-page document
Answer: B) It contains only predefined data for viewing
Explanation:
Reports are passive documents designed to present information from one or more records. They
do not allow data entry; forms are used for input instead.
Q17. What is the main advantage of using prototypes for forms and reports design?
A) Reduces database normalization requirements
B) Allows user feedback before final implementation
C) Ensures all columns are numeric
D) Automatically creates foreign keys
Answer: B) Allows user feedback before final implementation
Explanation:
Prototyping involves creating initial versions of forms/reports that users can review and suggest
changes for. This iterative process improves usability and user satisfaction.
Q18. Which of the following is NOT a valid method of highlighting information?
A) Underlining
B) Reverse video
C) Changing font size
D) Ignoring error messages
Answer: D) Ignoring error messages
Explanation:
Highlighting is meant to draw attention to critical information, warnings, or errors. Ignoring error
messages is not a method of highlighting and leads to poor usability.
Q19. Which of the following is a violation of First Normal Form (1NF)?
A) Each row has a unique primary key
B) An attribute contains multiple values in a single cell
C) All columns contain values from the same domain
D) Rows can be interchanged without affecting meaning
Answer: B) An attribute contains multiple values in a single cell
Explanation:
1NF requires that each cell contains only a single atomic value. Repeating groups or multi-
valued attributes violate 1NF.
Q20. Why is normalization important in relational databases?
A) To make queries slower
B) To reduce redundancy and prevent anomalies
C) To eliminate the need for primary keys
D) To allow multiple values in a single cell
Answer: B) To reduce redundancy and prevent anomalies
Explanation:
Normalization organizes data into tables to minimize redundancy and avoid insertion, deletion,
and update anomalies. It ensures data integrity and efficient maintenance.
Q21. In EMP_COURSE (Emp_ID, Course, Date_Completed), what is the primary key?
A) Emp_ID
B) Course
C) Date_Completed
D) Emp_ID and Course
Answer: D) Emp_ID and Course
Explanation:
A composite key is used because the combination of Emp_ID and Course uniquely identifies
each row, ensuring no duplicates and proper tracking of multiple courses per employee.
Q22. A table is in 2NF if:
A) It has no repeating groups and no partial dependencies
B) All non-key attributes are dependent on part of a composite key
C) It contains transitive dependencies
D) It has no primary key
Answer: A) It has no repeating groups and no partial dependencies
Explanation:
2NF builds on 1NF by removing partial dependencies. Non-key attributes must depend on the
whole primary key, not just part of it.
Q23. Which of the following best describes a transitive dependency?
A) A non-key attribute depends on part of the primary key
B) A non-key attribute depends on another non-key attribute
C) A primary key depends on a foreign key
D) A table depends on another table
Answer: B) A non-key attribute depends on another non-key attribute
Explanation:
Transitive dependencies occur when an attribute indirectly depends on the primary key through
another non-key attribute. 3NF removes this type of dependency.
Q24. In the VEHICLE example, which relation ensures 3NF?
A) VEHICLE (Registration_No, Owner, Model, Manufacturer, Engine_Size)
B) VEHICLE1 (Model, Manufacturer, Engine_Size) and REGISTRATION (Registration_No,
Owner, Model)
C) EMPLOYEE (Emp_ID, Name, Department, Salary)
D) EMP_COURSE (Emp_ID, Course, Date_Completed)
Answer: B) VEHICLE1 (Model, Manufacturer, Engine_Size) and REGISTRATION
(Registration_No, Owner, Model)
Explanation:
Breaking the table into VEHICLE1 and REGISTRATION removes transitive dependencies
(Model → Manufacturer, Engine_Size), ensuring all non-key attributes depend only on the
primary key.
Q25. Which of the following is NOT a step in logical database design?
A) Developing a logical data model for each user interface
B) Combining normalized data from all user interfaces
C) Deciding the physical storage type of attributes
D) Translating the E-R model into normalized data requirements
Answer: C) Deciding the physical storage type of attributes
Explanation:
Physical storage decisions are part of physical database design, not logical design. Logical
design focuses on normalization and data structure.
Q26. What is meant by atomicity in relational databases?
A) Each row can be split into multiple rows
B) Each cell contains a single indivisible value
C) A table must contain only numeric data
D) Foreign keys can be null
Answer: B) Each cell contains a single indivisible value
Explanation:
Atomicity ensures that data in each cell cannot be further divided, which is a key requirement for
1NF.
Q27. Which of the following ensures referential integrity?
A) Primary key must be numeric
B) Foreign key values must exist in the referenced primary key column
C) All tables must be normalized to 3NF
D) All columns must be atomic
Answer: B) Foreign key values must exist in the referenced primary key column
Explanation:
Referential integrity guarantees that relationships between tables remain consistent by ensuring
that foreign key values correspond to existing primary key values.
Q28. Which technique is used to validate numeric input in a data entry form?
A) Pictures/Templates
B) Self-checking digits
C) Range checks
D) All of the above
Answer: D) All of the above
Explanation:
Data validation techniques include range checks, templates/pictures, and self-checking digits to
ensure numeric data accuracy.
Q29. What is the role of context-sensitive help in interface design?
A) Automatically calculates values
B) Guides the user for specific fields or actions
C) Replaces testing and usability evaluation
D) Converts non-relational tables to 3NF
Answer: B) Guides the user for specific fields or actions
Explanation:
Context-sensitive help improves usability by providing instructions or hints relevant to the
current data entry point.
Q30. Which of the following is TRUE about data redundancy?
A) It improves storage efficiency
B) It increases the risk of update, deletion, and insertion anomalies
C) It ensures better query performance
D) It is required in 1NF
Answer: B) It increases the risk of update, deletion, and insertion anomalies
Explanation:
Redundant data leads to inconsistencies when updating, inserting, or deleting records.
Normalization reduces redundancy to protect database integrity.
Q31. Which of the following is a major deliverable of the interface design phase?
A) Physical storage format
B) Design specifications for forms and reports
C) Normalized database tables
D) SQL query scripts
Answer: B) Design specifications for forms and reports
Explanation:
The design specifications include the narrative overview, sample forms/reports, and usability
testing information, serving as inputs for system implementation.
Q32. In interface design, which of the following BEST describes “navigation consistency”?
A) Using the same colors for all forms
B) Ensuring users move through forms and reports in a similar manner
C) Placing all numeric fields on the left side
D) Displaying only one field per screen
Answer: B) Ensuring users move through forms and reports in a similar manner
Explanation:
Consistent navigation reduces learning time and errors, making interfaces more intuitive and
user-friendly.
Q33. What is the purpose of providing default values in a data entry form?
A) To eliminate the need for validation
B) To reduce data entry effort and errors
C) To ensure 3NF compliance
D) To increase redundancy
Answer: B) To reduce data entry effort and errors
Explanation:
Defaults save user effort and prevent errors for predictable values, such as today’s date or
standard product prices.
Q34. Which of the following is an example of an insertion anomaly?
A) Deleting an old record leaves other data inconsistent
B) Updating a salary requires changing multiple rows
C) Failing to insert a new employee’s department because of missing fields
D) Sorting records incorrectly
Answer: C) Failing to insert a new employee’s department because of missing fields
Explanation:
Insertion anomalies occur when new data cannot be inserted without supplying unrelated or
redundant information, often due to poor normalization.
Q35. In the EMPLOYEE1 relation, which columns demonstrate a partial dependency?
A) Course and Date_Completed
B) Emp_ID → Name, Department, Salary
C) Emp_ID and Course → Date_Completed
D) Emp_ID → Emp_ID
Answer: B) Emp_ID → Name, Department, Salary
Explanation:
These non-key attributes depend on part of the composite primary key (Emp_ID), violating 2NF.
Removing these creates separate tables to satisfy 2NF.
Q36. Which of the following is a guideline for formatting numeric data in tables and reports?
A) Left justify all numbers
B) Break numbers into groups of three or four digits
C) Ignore alignment with decimals
D) Use only uppercase letters
Answer: B) Break numbers into groups of three or four digits
Explanation:
Grouping long numeric sequences improves readability. Numeric columns are usually right-
justified and aligned on decimal points.
Q37. Which of the following is NOT part of physical database design?
A) Deciding attribute data types
B) Creating normalized tables
C) Selecting index structures
D) Determining stored record structure
Answer: B) Creating normalized tables
Explanation:
Normalization occurs during logical database design, while physical design focuses on storage
structures, indexing, and efficiency.
Q38. What does a foreign key ensure in a relational database?
A) Atomicity of data
B) Referential integrity between two tables
C) Compliance with 1NF
D) Unique column names
Answer: B) Referential integrity between two tables
Explanation:
A foreign key links two tables and ensures that values in one table exist in another, maintaining
consistency between related data.
Q39. In a form design, which of the following is considered a usability feature?
A) Using technical jargon for error messages
B) Providing context-sensitive help
C) Allowing entry of redundant fields
D) Ignoring default values
Answer: B) Providing context-sensitive help
Explanation:
Context-sensitive help guides users during data entry, reducing errors and improving efficiency
and satisfaction.
Q40. Which type of database anomaly occurs when deleting a record inadvertently removes
other needed data?
A) Insertion anomaly
B) Deletion anomaly
C) Update anomaly
D) Referential anomaly
Answer: B) Deletion anomaly
Explanation:
Deletion anomalies occur when removing a record causes unintended loss of related data, which
normalization can prevent.
Q41. What is the first step to achieve 1NF from a non-normalized table?
A) Remove transitive dependencies
B) Make each column value atomic
C) Remove all foreign keys
D) Create views for each record
Answer: B) Make each column value atomic
Explanation:
1NF requires all attributes to have single, indivisible values. Multi-valued attributes or repeating
groups must be split into separate rows or tables.
Q42. Which attribute in the REGISTRATION relation acts as a foreign key?
A) Registration_No
B) Owner
C) Model
D) Engine_Size
Answer: C) Model
Explanation:
The Model attribute refers to the primary key in VEHICLE1, enforcing referential integrity
between the two tables.
Q43. Why should highlighting be used sparingly in interface design?
A) It increases database redundancy
B) Excessive highlighting can confuse or annoy users
C) It violates 3NF rules
D) It prevents data entry
Answer: B) Excessive highlighting can confuse or annoy users
Explanation:
Highlighting is effective for critical warnings or important information but overuse reduces its
impact and can frustrate users.
Q44. Which of the following is TRUE about functional dependency?
A) It guarantees that B can be computed from A
B) B has only one value for each value of A
C) A must always be numeric
D) B can depend on multiple tables
Answer: B) B has only one value for each value of A
Explanation:
Functional dependency means that for a given value of A, there is a single corresponding value
of B, though it does not imply computability.
Q45. Which guideline ensures clarity when designing forms and reports?
A) Use meaningful titles and revision dates
B) Avoid labeling columns or fields
C) Display all fields in random order
D) Use blinking text for all entries
Answer: A) Use meaningful titles and revision dates
Explanation:
Meaningful titles, revision codes, and dates help users understand the purpose, version, and
currency of forms and reports.
Q46. In designing tables for reports, which of the following is recommended?
A) Use meaningless labels to save space
B) Redisplay labels when data extend beyond one page or screen
C) Avoid sorting columns
D) Use fancy fonts for better aesthetics
Answer: B) Redisplay labels when data extend beyond one page or screen
Explanation:
Repeating column/row labels ensures clarity for users when viewing long tables or reports,
improving readability.
Q47. Which of the following is a characteristic of a relational table?
A) Columns can store arrays of values
B) Each row is unique and identified by a primary key
C) Row order defines the meaning of data
D) Columns may contain different types of data
Answer: B) Each row is unique and identified by a primary key
Explanation:
Relational tables require uniqueness of rows, enforced by a primary key, ensuring data integrity
and reducing redundancy.
Q48. Why is normalization important in logical database design?
A) It reduces disk storage but increases redundancy
B) It prevents anomalies like insertion, deletion, and update errors
C) It eliminates the need for foreign keys
D) It automatically generates reports
Answer: B) It prevents anomalies like insertion, deletion, and update errors
Explanation:
Normalization organizes data to minimize redundancy, ensuring updates, insertions, and
deletions do not cause inconsistencies.
Q49. In 2NF, a non-key attribute must be:
A) Dependent on a single part of a composite key
B) Dependent on the entire primary key
C) Independent of any key
D) Stored in a separate database
Answer: B) Dependent on the entire primary key
Explanation:
2NF eliminates partial dependencies; non-key attributes must rely on the full primary key, not
just part of a composite key.
Q50. Which of the following BEST describes a transitive dependency?
A) A primary key depends on a foreign key
B) A non-primary-key attribute depends on another non-primary-key attribute
C) A foreign key is null
D) Two tables share the same primary key
Answer: B) A non-primary-key attribute depends on another non-primary-key attribute
Explanation:
Transitive dependencies violate 3NF; non-key attributes should only depend on the primary key,
not other non-key attributes.
Q51. In a relational database, which of the following is TRUE?
A) Column order must always be preserved
B) Rows can be stored in any sequence
C) Multi-valued cells are allowed
D) Keys are optional
Answer: B) Rows can be stored in any sequence
Explanation:
The order of rows in a relational table does not affect meaning; relational databases rely on keys
and domains, not sequence.
Q52. Which technique is used to reduce data entry errors in forms?
A) Justifying all numbers to the left
B) Providing context-sensitive help and default values
C) Displaying random error codes
D) Allowing duplicate primary keys
Answer: B) Providing context-sensitive help and default values
Explanation:
Context-sensitive help guides users during entry, and defaults reduce mistakes for predictable or
repeated data.
Q53. Which of the following is an example of a logical data model?
A) EMPLOYEE table in 3NF
B) SQL index on Employee ID
C) Hard disk storage blocks
D) Indexed sequential file layout
Answer: A) EMPLOYEE table in 3NF
Explanation:
Logical data models focus on structuring data for efficiency, minimal redundancy, and integrity;
3NF tables are a result of logical design.
Q54. Which type of error occurs if a quantity field exceeds expected limits?
A) Truncation error
B) Reasonableness error
C) Appending error
D) Hyphenation error
Answer: B) Reasonableness error
Explanation:
Reasonableness tests ensure numeric values are within acceptable ranges, preventing nonsensical
entries.
Q55. Which attribute combination is the primary key in the EMP_COURSE relation?
A) Course
B) Emp_ID
C) Emp_ID + Course
D) Date_Completed
Answer: C) Emp_ID + Course
Explanation:
The combination of Emp_ID and Course uniquely identifies each record in EMP_COURSE,
making it a composite primary key.
Q56. Why should forms use meaningful titles, revision dates, and valid dates?
A) To satisfy 1NF requirements
B) To provide clarity and traceability for users
C) To enforce referential integrity
D) To normalize the database
Answer: B) To provide clarity and traceability for users
Explanation:
Titles and dates help users understand the purpose, currency, and version of forms and reports.
Q57. In the VEHICLE example, why was a separate VEHICLE1 table created?
A) To merge registration numbers
B) To eliminate transitive dependencies
C) To allow duplicate primary keys
D) To remove foreign keys
Answer: B) To eliminate transitive dependencies
Explanation:
VEHICLE1 separates Model, Manufacturer, and Engine_Size to remove non-key dependencies,
satisfying 3NF.
Q58. Which of the following is a key reason for creating separate tables during normalization?
A) To slow down database queries
B) To remove redundant or repeating data
C) To reduce the number of users
D) To eliminate primary keys
Answer: B) To remove redundant or repeating data
Explanation:
Normalization divides complex tables into simpler ones to reduce redundancy and prevent
anomalies.
Q59. Which of the following is NOT an anomaly addressed by normalization?
A) Insertion anomaly
B) Update anomaly
C) Deletion anomaly
D) Formatting anomaly
Answer: D) Formatting anomaly
Explanation:
Normalization addresses data anomalies like insertion, update, and deletion errors; formatting
issues are unrelated.
Q60. In interface design, why is highlighting used conservatively?
A) It increases memory usage
B) Excessive highlighting may confuse users and reduce effectiveness
C) It violates 3NF
D) It creates partial dependencies
Answer: B) Excessive highlighting may confuse users and reduce effectiveness
Explanation:
Highlighting should emphasize critical information without overwhelming the user, ensuring
clarity and attention to priority items.
Q61. Which of the following is a correct definition of a foreign key?
A) An attribute that only exists in one table
B) An attribute that uniquely identifies a record in another table
C) An attribute that has no dependency
D) An attribute that can store arrays
Answer: B) An attribute that uniquely identifies a record in another table
Explanation:
A foreign key links one table to another, maintaining referential integrity by pointing to a
primary key in the related table.
Q62. In interface design, what is the purpose of prompting cues?
A) To save system memory
B) To guide the user with specific instructions for data entry
C) To prevent database normalization
D) To automatically update primary keys
Answer: B) To guide the user with specific instructions for data entry
Explanation:
Prompting cues ensure that users provide the correct type of information, reducing errors and
confusion during input.
Q63. Which of the following is NOT a guideline for designing tables and lists?
A) Use meaningful labels
B) Right-justify numeric data
C) Redisplay labels if data extends beyond a screen
D) Store multiple values in a single cell
Answer: D) Store multiple values in a single cell
Explanation:
Relational design requires atomic values in each cell; multi-valued cells violate 1NF principles.
Q64. Which of the following types of anomalies occurs if data must be entered in multiple
places?
A) Deletion anomaly
B) Update anomaly
C) Insertion anomaly
D) Formatting anomaly
Answer: C) Insertion anomaly
Explanation:
Insertion anomalies occur when adding a new entry requires inserting data in multiple places,
risking incomplete or inconsistent entries.
Q65. Which step in physical database design involves choosing key indexes?
A) Logical normalization
B) Determining record structure
C) Selecting structures for efficient data access
D) Designing forms
Answer: C) Selecting structures for efficient data access
Explanation:
Indexes are created to speed up queries and searches, improving database performance.
Q66. Which of the following is TRUE regarding 3NF?
A) All non-key attributes are functionally dependent only on the primary key
B) Partial dependencies are allowed
C) Transitive dependencies between non-key attributes are allowed
D) Rows may have duplicate primary key values
Answer: A) All non-key attributes are functionally dependent only on the primary key
Explanation:
3NF eliminates transitive dependencies; non-key attributes should only depend on the primary
key.
Q67. In the EMPLOYEE1 relation, which of the following caused redundancy?
A) Emp_ID was used as a foreign key
B) Attributes Name, Department, Salary depended only on part of the primary key
C) Course was stored in a separate table
D) The relation had no primary key
Answer: B) Attributes Name, Department, Salary depended only on part of the primary key
Explanation:
Partial dependency on Emp_ID caused repeated data; normalization to 2NF resolved this.
Q68. Which of the following is NOT a purpose of normalization?
A) Reduce redundancy
B) Eliminate anomalies
C) Ensure atomicity of fields
D) Design the graphical layout of forms
Answer: D) Design the graphical layout of forms
Explanation:
Normalization focuses on data structure and integrity; form layout is part of interface design.
Q69. Which technique helps detect missing data during input?
A) Self-checking digits
B) Picture/templates
C) Expected values
D) All of the above
Answer: D) All of the above
Explanation:
All these methods validate that fields are properly populated and conform to expected formats,
reducing input errors.
Q70. In interface design, which navigation rule is correct?
A) Users should move only in one direction through forms
B) Navigation should be consistent and flexible across all forms
C) Navigation does not affect usability
D) Users must memorize key sequences for each form
Answer: B) Navigation should be consistent and flexible across all forms
Explanation:
Consistent, flexible navigation reduces errors and improves usability across the system.
Q71. Which type of dependency exists if Date_Completed depends on both Emp_ID and
Course?
A) Partial dependency
B) Transitive dependency
C) Composite functional dependency
D) Foreign key dependency
Answer: C) Composite functional dependency
Explanation:
Date_Completed requires the combination of Emp_ID + Course, making it a composite
dependency on the primary key.
Q72. What is the primary goal when designing reports?
A) Maximize font styles and colors
B) Present data clearly, accurately, and for intended users
C) Merge multiple unrelated tables into one
D) Reduce data normalization
Answer: B) Present data clearly, accurately, and for intended users
Explanation:
Reports should provide actionable, readable information for users without introducing
redundancy or confusion.
Q73. Which of the following is considered atomic in relational design?
A) A list of courses in a single cell
B) A single course code in a cell
C) Multiple phone numbers separated by commas in one field
D) Employee name and department combined in one field
Answer: B) A single course code in a cell
Explanation:
Atomicity means a cell contains only one indivisible value, ensuring compliance with 1NF.
Q74. Which of the following is TRUE about referential integrity?
A) Foreign key values must exist in the referenced primary key
B) Primary keys can have null values
C) Foreign keys may violate domain constraints
D) Referential integrity only applies to physical storage
Answer: A) Foreign key values must exist in the referenced primary key
Explanation:
Referential integrity ensures that relationships between tables are consistent; foreign keys must
match existing primary key values.
Q75. When creating forms, why is providing default values recommended?
A) To satisfy 3NF
B) To reduce user input errors and save time
C) To create composite keys
D) To bypass functional dependencies
Answer: B) To reduce user input errors and save time
Explanation:
Defaults speed up data entry and prevent mistakes for predictable fields like dates or standard
prices.
Q76. Which type of anomaly occurs when deleting an old record causes unintended loss of
related information?
A) Update anomaly
B) Deletion anomaly
C) Insertion anomaly
D) Transitive anomaly
Answer: B) Deletion anomaly
Explanation:
Deletion anomalies happen when removal of a record inadvertently deletes other important data
that shouldn’t be lost.
Q77. In physical database design, which factor is NOT typically considered?
A) Attribute data types
B) Table storage structures
C) Key indexes for fast access
D) Color scheme of the user interface
Answer: D) Color scheme of the user interface
Explanation:
Physical design focuses on database storage and efficiency, not UI aesthetics.
Q78. Which of the following defines a primary key?
A) Attribute that may be null
B) Attribute that uniquely identifies each row in a table
C) Attribute that stores multiple values
D) Attribute dependent on a non-key attribute
Answer: B) Attribute that uniquely identifies each row in a table
Explanation:
Primary keys ensure uniqueness of records and are essential for relational database integrity.
Q79. Which normalization step removes partial dependencies?
A) 1NF
B) 2NF
C) 3NF
D) 4NF
Answer: B) 2NF
Explanation:
2NF ensures that all non-key attributes depend on the entire primary key, eliminating partial
dependencies.
Q80. Which is TRUE regarding highlighting information in interface design?
A) Use blinking text for all fields
B) Highlight sparingly to emphasize critical information
C) Highlight every column header
D) Avoid using highlighting altogether
Answer: B) Highlight sparingly to emphasize critical information
Explanation:
Excessive highlighting overwhelms users; it should only draw attention to important or critical
messages.
Q81. Which of the following is NOT a method to control data input errors?
A) Class/composition checks
B) Pictures/templates
C) Hyphenation
D) Reasonableness tests
Answer: C) Hyphenation
Explanation:
Hyphenation is a text formatting rule, not a technique to validate input data integrity.
Q82. Which describes a report as opposed to a form?
A) Active document used for data entry
B) Passive document used for reading and viewing
C) Always editable by the user
D) Typically based on a single record only
Answer: B) Passive document used for reading and viewing
Explanation:
Reports summarize or display information from multiple records and are not meant for user
input.
Q83. Why should column labels be meaningful in tables and lists?
A) To reduce disk storage
B) To improve readability and user comprehension
C) To enforce 1NF
D) To allow multi-valued cells
Answer: B) To improve readability and user comprehension
Explanation:
Meaningful labels guide users in interpreting table data correctly.
Q84. Which of the following is a partial dependency in the EMPLOYEE1 table?
A) Emp_ID + Course → Date_Completed
B) Emp_ID → Name, Department, Salary
C) Emp_ID → Course
D) Course → Date_Completed
Answer: B) Emp_ID → Name, Department, Salary
Explanation:
Name, Department, and Salary depend only on part of the composite key (Emp_ID), violating
2NF.
Q85. In 3NF, which is allowed?
A) Non-key attributes depending on other non-key attributes
B) Non-key attributes depending only on the primary key
C) Partial dependencies on a composite key
D) Repeating groups in columns
Answer: B) Non-key attributes depending only on the primary key
Explanation:
3NF eliminates transitive dependencies; attributes should depend solely on the primary key.
Q86. Which step is involved in physical database design?
A) Normalizing tables to 3NF
B) Selecting data types and indexes
C) Creating E-R diagrams
D) Designing report layouts
Answer: B) Selecting data types and indexes
Explanation:
Physical design specifies storage, data types, indexing, and optimization; normalization is part of
logical design.
Q87. Which of the following is true about composite keys?
A) They consist of a single attribute
B) They are never allowed in relational databases
C) They uniquely identify records using multiple attributes
D) They replace all foreign keys
Answer: C) They uniquely identify records using multiple attributes
Explanation:
Composite keys combine multiple attributes to ensure uniqueness when no single attribute
suffices.
Q88. In interface design, what is the purpose of context-sensitive help?
A) To replace default values
B) To provide guidance relevant to the user’s current field or task
C) To enforce foreign key constraints
D) To normalize database tables
Answer: B) To provide guidance relevant to the user’s current field or task
Explanation:
Context-sensitive help reduces user errors and improves efficiency by giving targeted assistance.
Q89. Which of the following is a key principle of first normal form (1NF)?
A) Allow multi-valued fields
B) Remove repeating groups
C) Create transitive dependencies
D) Allow duplicate rows
Answer: B) Remove repeating groups
Explanation:
1NF requires atomic values and no repeating groups to ensure simple, consistent data storage.
Q90. Why should forms use adequate spacing and margins?
A) To comply with 3NF
B) To enhance readability and usability for users
C) To create multi-valued attributes
D) To increase database redundancy
Answer: B) To enhance readability and usability for users
Explanation:
Well-formatted forms reduce user errors and make data entry and reading easier.
Q91. Which of the following is a main objective of interface design?
A) To enforce 3NF on all database tables
B) To ensure users can efficiently and accurately interact with the system
C) To determine physical storage structures
D) To create multi-valued fields in forms
Answer: B) To ensure users can efficiently and accurately interact with the system
Explanation:
Interface design focuses on usability, guiding users to enter, access, and understand information
correctly.
Q92. In relational databases, what is atomicity?
A) The ability of a table to store multiple values per cell
B) Each cell in a table contains only one indivisible value
C) All columns must be numeric
D) A table can have duplicate rows
Answer: B) Each cell in a table contains only one indivisible value
Explanation:
Atomicity ensures data integrity by keeping each value in a cell simple and non-divisible, which
is required for 1NF.
Q93. What type of dependency is represented by Emp_ID → Name in the EMPLOYEE table?
A) Partial dependency
B) Transitive dependency
C) Functional dependency
D) Foreign key dependency
Answer: C) Functional dependency
Explanation:
Name depends solely on Emp_ID. This is a functional dependency because one value of
Emp_ID uniquely determines the Name.
Q94. Which method helps ensure reasonableness in user input?
A) Provide default values
B) Check ranges and expected values
C) Use multiple forms for the same data
D) Create multi-valued fields
Answer: B) Check ranges and expected values
Explanation:
Range and expected value checks validate that data entries make logical sense for the given field.
Q95. Which of the following best describes transitive dependency?
A) A non-key attribute depends on part of a composite key
B) A non-key attribute depends on another non-key attribute
C) A primary key depends on a foreign key
D) A table has no repeating groups
Answer: B) A non-key attribute depends on another non-key attribute
Explanation:
Transitive dependency occurs when one non-key attribute depends on another non-key attribute,
violating 3NF.
Q96. In designing forms, which of the following improves usability?
A) Consistent layout and navigation
B) Multi-valued fields
C) Random key assignments
D) Complex formatting for all fields
Answer: A) Consistent layout and navigation
Explanation:
Consistency in form design reduces errors and makes the interface intuitive for users.
Q97. What is the purpose of using foreign keys in relational databases?
A) To eliminate 1NF violations
B) To enforce relationships and maintain referential integrity between tables
C) To combine multiple tables into one
D) To normalize text formatting
Answer: B) To enforce relationships and maintain referential integrity between tables
Explanation:
Foreign keys link tables, ensuring that related data remains consistent across the database.
Q98. Which of the following is TRUE about the EMP_COURSE table in 2NF?
A) Non-key attributes depend only on part of the key
B) Each row is unique for the combination of Emp_ID and Course
C) Name and Department are part of the primary key
D) There is still transitive dependency between Name and Course
Answer: B) Each row is unique for the combination of Emp_ID and Course
Explanation:
The composite key (Emp_ID + Course) ensures uniqueness of each record; all non-key attributes
depend on the entire key, satisfying 2NF.
Q99. Which of the following best reduces update anomalies?
A) Using multi-valued attributes
B) Normalizing tables to at least 3NF
C) Combining unrelated entities into one table
D) Avoiding primary keys
Answer: B) Normalizing tables to at least 3NF
Explanation:
Normalization eliminates redundancy and transitive dependencies, reducing the risk of
inconsistencies during updates.
Q100. In physical database design, which of the following decisions is made?
A) Determining which forms users will use
B) Choosing data types for attributes
C) Creating DFDs for processes
D) Normalizing tables to 3NF
Answer: B) Choosing data types for attributes
Explanation:
Physical design focuses on how the database is implemented, including data types, storage
structure, and indexing for efficient access.