Free Databases MCQs with Answers
210 Databases MCQs from Computer Science and IT, each with the correct answer and a written explanation of why it is correct. Free and unlimited, with no account needed.
Databases cover tables, records, fields, keys and relationships, together with database management systems and relational database design. The subject includes primary and foreign keys, normalization, SQL commands such as SELECT, INSERT, UPDATE and DELETE, queries, forms and reports, while distinguishing a database from a spreadsheet used for simple tabular data.
Last updated
210 questions · page 9 of 11
- A. Modification anomaly
- B. Update anomaly
- C. Insertion anomaly
- D. Deletion anomaly
Explanation: In this scenario, the student's monthly fee represents a single piece of information that applies to all their course enrollments.
Correct answer: Update anomaly- A. Partial dependency
- B. Transitive dependency
- C. Determinant
- D. Manually Exclusive
Explanation: Determinant is the term used in relational databases to describe a single attribute (part of a composite key) that can be used to uniquely…
Correct answer: Determinant- A. Key dependencies
- B. Relation dependencies
- C. Database dependencies
- D. View
Explanation: Functional dependencies are a fundamental concept in relational database design.
Correct answer: Key dependencies- A. Seldom
- B. Never
- C. Always
- D. Commonly
Explanation: In relational database design, a multivalued dependency (MVD) occurs when a single value in one attribute determines a set of possible…
Correct answer: Always- A. Primary key
- B. Foreign key
- C. Secondary key
- D. Candidate key
Explanation: Referential integrity is a concept in relational databases that ensures the consistency and accuracy of data between linked tables.
Correct answer: Foreign key- A. 1NF (First Normal Form)
- B. 2NF (Second Normal Form)
- C. 3NF (Third Normal Form)
- D. BCNF (Boyce-Codd Normal Form)
Explanation: Partial dependency occurs in a relational database table when a non-key attribute is dependent on only a part of the composite primary…
Correct answer: 2NF (Second Normal Form)- A. All the key attributes are defined
- B. No repeating groups in the table
- C. All attributes are dependent on the primary key
- D. All of the above
Explanation: First Normal Form (1NF) is a fundamental concept in database normalization.
Correct answer: All of the above- A. Good data
- B. Data integrity
- C. Update anomaly
- D. Normalization
Explanation: Update anomaly refers to a situation in a database where modifying a record can lead to data inconsistency or redundancy.
Correct answer: Update anomaly- A. Eliminate redundancy
- B. Minimize data modification errors
- C. Simplify the query process
- D. All of the above
Explanation: Normalization is a process in relational database design that aims to reduce data redundancy and improve data integrity.
Correct answer: All of the above- A. Clean
- B. Simple
- C. Well-structured
- D. Complex
Explanation: Well-structured is the most appropriate term to describe a relation (table) in a database that minimizes redundancy and is user-friendly.
Correct answer: Well-structured- A. Candidate Key
- B. Determinant
- C. Foreign Key
- D. Primary Key
Explanation: In a functional dependency (FD), denoted by an arrow (->), the attribute(s) on the left side of the arrow determine the attribute(s) on…
Correct answer: Candidate Key- A. First
- B. Second
- C. Third
- D. Fourth
Explanation: First Normal Form (1NF) is the foundational level of database normalization.
Correct answer: First- A. 1NF (First Normal Form)
- B. 2NF (Second Normal Form)
- C. 3NF (Third Normal Form)
- D. BCNF (Boyce-Codd Normal Form)
Explanation: In First Normal Form (1NF), a relational database table must adhere to the following rules:Atomic Values: Each cell (intersection of a row…
Correct answer: 1NF (First Normal Form)- A. 1NF
- B. 2NF
- C. 3NF
- D. BCNF
Explanation: First Normal Form (1NF) is the most basic level of normalization in a relational database.
Correct answer: 1NF- A. Functional tables
- B. Partial dependencies
- C. Data groups
- D. Transitive tables
Explanation: First Normal Form (1NF) is the most basic level of database normalization.
Correct answer: Functional tables- A. Synonym
- B. Homonym
- C. Acronym
- D. Manually Exclusive
Explanation: In the context of relational databases, a homonym refers to attributes in different tables that share the same name but represent distinct…
Correct answer: Homonym- A. Table
- B. Query
- C. Anomaly
- D. Normalization
Explanation: Normalization is a systematic process of organizing a database to minimize redundancy and improve data integrity.
Correct answer: Normalization- A. No primary key attribute can be null
- B. Each entity must have a primary key
- C. Referential integrity must be maintained across all entities
- D. A primary key must have only one attribute
Explanation: Each entity must have a primary key is the core principle of the entity integrity rule.
Correct answer: Each entity must have a primary key- A. Insertion anomaly
- B. Deletion anomaly
- C. File anomaly
- D. Modification anomaly
Explanation: File anomaly is not a standard type of anomaly in relational databases.
Correct answer: File anomaly- A. Homonyms
- B. Synonyms
- C. Aliases
- D. None of these
Explanation: Synonyms are words or phrases that have the same or similar meaning. In the context of attributes, synonyms refer to different names used…
Correct answer: Synonyms