Today's Topic Data Integrity and Normalization DataBase Solved MCQs

Q1) A relation that contains minimal redundancy and allows easy use called:

1. Clean
2. Simple
3. Complex
4. Well Structured

Answer:well-structured

Explanation:A relation that contains minimal redundancy and allows easy use is considered to be: well-structured.

Q2) A row of relation is called:

1. Attribute
2. Entity
3. Tuple
4. Relation

Answer:Tuple

Explanation:In the context of a relational database, a row—also called a Tuple A Tuple represents a single, implicitly structured data item in a table.

Q3) Data inconsistency is caused by:

1. Organized data
2. Independent
3. Integrated data
4. Redundant data

Answer:Redundant data

Explanation:Data redundancy occurs when the same data exists in multiple places, whereas data inconsistency is when the same data exists in different formats in multiple tables.

Q4) A primary key value cannot be null is what kind of integrity?

1. Referential integrity
2. Data integrity
3. Entity integrity
4. Security integrity

Answer:Referential integrity

Explanation:Referential integrity Or Entity Integrity Constraint is used to ensure that the primary key cannot be null.

Q5) Referential integrity is applied on:

1. Foreign key
2. Composite key
3. Primary key
4. Sart key

Answer:Primary key

Explanation:Referential integrity refers to the relationship between different tables based on the Primary key

Q6) In 3 NF (Third Normal Form), a non- key attribute must not depend on a:

1. key attributes
2. Non- key attributes
3. Composite key
4. Sort key

Answer:Non- key attributes

Explanation:To be 3NF the relation must be in second normal form. So that all transitive dependencies must be removed; a Non-key Attribute may not be functionally dependent on another non-key attribute.

Q7) A constraint between two attributes is called:

1. Functional Relation
2. Attribute Dependency
3. Functional Dependency
4. Relation Constraint

Answer:Functional Dependency

Explanation:Functional Dependency. A constraint between two attributes is called a: functional dependency.

Q8) Transitive dependency is removed in:

1. 1st Normal Form
2. 2nd Normal Form
3. 3rd Normal Form
4. 4th Normal Form

Answer:3rd Normal Form

Explanation:By nature, a transitive dependency requires three or more attributes. To achieve the normalization standard of Third Normal Form (3NF),

Q9) The Goal of Normalization is to:

1. Increase
2. Increase Inconsistency Redundancy
3. Get Stable
4. Increasing Anomalies Data Structure

Answer:Get Stable

Explanation:Get Stable. The two main goal of Normalization are eliminate redundant data and ensure data dependencies make sense.

Q10) Which one refers to the correctness and consistency of data?

1. Data independence
2. Data integration
3. Data integrity
4. Data made!

Answer:Data integrity

Explanation:Data integrity is the overall accuracy, completeness, and consistency of data.

Q11) Why are Validation rules used in a database?. (BWP-14)

1. Ensure correct data is entered
2. To avoid typing errors
3. Both A and B
4. neither A or B

Answer:Ensure correct data is entered

Explanation:A validation rule is one way to restrict input in a table field or a control (such as a text box) on a form. Ensure correct data is entered Referance

Q12) Multiple copies of the same data is referred to as:

1. Data integrity
2. Data inconsistency
3. Data redundancy
4. Data isolation

Answer:Data redundancy

Explanation:Data redundancy refers to the practice of keeping data in two or more places within a database or data storage system.

Q13) Which of the following is a correct association?

1. File = column
2. Record = row
3. Field = row
4. Record = table

Answer:Record = row

Explanation:Conceptual girp. Records are also known as a row of interrelated data. A collection of interrelated records is also called a database

Q14) Two or more attributes having different names but same meaning are called:

1. Homonyms
2. Aliases
3. Synonyms
4. Altemate Attributes

Answer:Synonyms

Explanation:Synonyms: is two or more attributes that have different names.

Q15) In 3NF, which form of dependency is removed?

1. Functional
2. Non-Functional
3. Associative
4. Transitive

Answer:Transitive

Explanation:When normalizing a 2NF relation to 3NF, we remove these transitive dependencies.

Q16) A Referential integrity constraint is a rule that maintain consistency among the:

1. Columns of two tables
2. Two columns of same table
3. Rows of two table
4. Attribute of two tables

Answer:Two columns of same table

Explanation:Two columns of same table. It is used to maintain the integrity of the relationships between different tables belonging to one database.

Q17) In relational database, a table is also called:

1. Tuple
2. Relation
3. File
4. Schema

Answer:Relation

Explanation:Each table, sometimes called a Relation, in a relational database contains one or more data categories in columns or attributes.

Q18) Every relation must have key.

1. Candidate
2. Foreign
3. Primary
4. All of these

Answer:Primary

Explanation:Each data record, which corresponds to a tuple of a relation, in a table must be distinct. Every relation has at least one Primary key by default,

Q19) When two different names are used for the same information or attribute creates a problem known as

1. Synonym
2. Acronym
3. Homonym
4. Antonym

Answer:Synonym

Explanation:When two different names are used for the same information or attribute creates a problem known as Synonym.

Q20) In 2NF, which form of dependency is removed?

1. Functional
2. Associative
3. Transitive
4. Partial

Answer:Partial

Explanation:The 2nd Normal Form (2NF) eliminates the Partial Dependency

Q21) Different Attributes in two different tables having same name are referred to as:

1. Synonym
2. Homonym
3. Acronym
4. Mutually exclusive

Answer:Homonym

Explanation:Different Attributes in two different tables having same name are referred to as Homonym