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 10 of 11
- A. Dependent on part of the primary key
- B. Dependent on the entire primary key
- C. Independent of the primary key
- D. Independent of any other relation
Explanation: A relation is in Second Normal Form (2NF) if it satisfies two conditions:1.
Correct answer: Dependent on the entire primary key- A. Functional
- B. Partial
- C. Associative
- D. Transitive
Explanation: In a relational database, a partial dependency exists when a non-prime attribute (an attribute that is not part of the primary key) is…
Correct answer: Partial- A. Functional
- B. Non-functional
- C. Associative
- D. Transitive
Explanation: Transitive dependencies occur when one non-key attribute is dependent on another non-key attribute, which in turn is dependent on the…
Correct answer: Transitive- A. Yes, I can write the same information in two different ways
- B. No, I cannot write the same information in two different ways
- C. I cannot write the same information in two different ways
Explanation: The concept of rewriting information in different ways is fundamental to many aspects of communication and data management.
Correct answer: Yes, I can write the same information in two different ways- A. 2
- B. 3
- C. 4
- D. 5
Explanation: Data integrity refers to the accuracy, consistency, and trustworthiness of data in a database or storage system.
Correct answer: 4- A. Constraints
- B. Consistency Rules
- C. Functional Dependency
- D. All of the above
Explanation: ● Data Integrity: Data integrity refers to the accuracy, completeness, and consistency of data over its entire lifecycle.
Correct answer: All of the above- A. Redundancy
- B. Transitive Dependency
- C. Consistency
- D. Relation
Explanation: In a relational database, a transitive dependency occurs when a dependency exists between two attributes indirectly through a third…
Correct answer: Transitive Dependency- A. Get a stable data structure
- B. Increase number of relations
- C. Functional dependency
Explanation: The main goal of normalization is to organize data in a database in a way that reduces redundancy and improves data integrity.
Correct answer: Get a stable data structure- A. Candidate key
- B. Determinant
- C. Foreign key
- D. Primary key
Explanation: In a functional dependency (FD), a determinant is a set of attributes that determines another set of attributes, called the dependent.
Correct answer: Determinant- A. Insertion
- B. Deletion
- C. Modification
- D. All of the above
Explanation: Redundancy in tables refers to the storing of the same data in multiple places within a database.
Correct answer: All of the above- A. Mutually Exclusive
- B. Redundant Information
- C. Homonyms
- D. Determinant
Explanation: Redundant information refers to data that is stored multiple times in a database, even though it can be derived from other stored data.
Correct answer: Redundant Information- A. Referential Integrity
- B. Entity Integrity
- C. Data Integrity
- D. All of the above
Explanation: This constraint ensures that every row in a table can be uniquely identified by its primary key, and that the primary key cannot have a…
Correct answer: Entity Integrity- A. 2NF
- B. 3NF
- C. 4NF
- D. 5NF
Explanation: Ensures minimal data redundancy by eliminating the dependency of attributes on non-key attributes.
Correct answer: 3NF- A. Key dependencies
- B. Relation dependencies
- C. View
- D. Database dependencies
Explanation: Relation dependencies is the correct answer. Functional dependencies are a fundamental concept in relational database theory.
Correct answer: Relation dependencies- A. Functional relation
- B. Attribute dependency
- C. Functional relation constraint
- D. Functional dependency
Explanation: This is the most precise term encompassing the concept of a functional dependency as a rule or restriction applied to a database table
Correct answer: Functional relation constraint- A. TNF
- B. 2NF
- C. 3NF
- D. 4NF
Explanation: 2NF (Second Normal Form) is the correct answer. A table is in 2NF if it adheres to 1NF (all atomic values) and eliminates partial…
Correct answer: 2NF197. Which of the following is the process of analyzing the dependencies of attributes within entities
- A. Anomalies
- B. Merging relation
- C. Normalization
- D. Redundant information
Explanation: Normalization is a process of organizing data in a database to minimize redundancy and improve data integrity.
Correct answer: Normalization- A. Referential integrity
- B. Key match rule
- C. Entity key group rule
- D. Foreign/Primary match rule
Explanation: This is a database constraint that ensures that the foreign key value in a child table either references a valid primary key value in the…
Correct answer: Referential integrity- A. Homonyms
- B. Aliases
- C. Synonyms
- D. Database objects
Explanation: Aliases is the correct answer. An alias is an alternative name for an attribute or table in a database.
Correct answer: Aliases- A. Table must have unique name
- B. A relation must have primary key associated with it
- C. A relation may not have primary key
- D. Should be in zero normalization level
Explanation: A relation must have a primary key associated with it is the correct answer.
Correct answer: A relation must have primary key associated with it