2nd year computer science chapter 4 Important Questions

Preview or download 2nd year computer science Important Questions chapter 4 Data Integrity and Normalization. These important computer  12 mcqs, short and long questions are collected by going through different past papers of all Punjab Board Pakistan.

Why are these questions important?

These Questions are taken from past papers of 2nd year computer science. These questions are top repeated of in previous papers of 2nd year computer science of all Punjab boards as;

      Bahawalpur Board

      D.G.Khan Board

      Faisalabad Board

      Gujranwala Board

      Lahore Board

      Multan Board

      Rawalpindi Board

Content is created and designed with intense care and diligence. Here is only the most important MCQ, short questions and long questions of 2nd year computer science chapter 4 Data Integrity and Normalization.

PDF Download and Print Available

You can easily download in pdf format or view 2nd year computer science mcqs, short questions and long questions  online. You can easily print these files in simple way. Here you find 2nd year computer science chapter 4 Data Integrity and Normalization important mcqs, short and long questions. By Preparing these important questions, you will achieve splendid marks in 2nd year computer science. This content is very helpful for weak students and also helpful for those students that are better at 2nd year computer science exam preparation. These Questions are based on the current 2nd year computer science syllabus according to Punjab Textbook Board.

Great Achievement in Short Time

Generally, students get less time for preparation. If we talk about 2nd year computer science, we need a lot of intensive time to prepare for it. 2nd Year students of face big difficulty while preparation of 2nd year computer science MCQs, Short & Long questions. Good News! mhbeducator.com offers you, the easiest and smartest way to prepare 2nd year computer science by which students can save their time and will able to prepare 2nd year computer science very fast. Here your are provided 2nd year computer science chapter 4 MCQs, important short and long questions. For other chapters click the link below the Post. These Questions are based on the current computer  12 syllabus according to Punjab Textbook Board.

About This Chapter

2nd year computer science Chapter 4 enables the students to learn;

• Data integrity and its types
• Referential Integrity
• Database anomalies
• Normalization and its use in database
• Relation in first normal form
• Partial dependency
• Anomalies due to transitive dependency
• What is 3NF?

This Post "2nd year computer science chapter 4 Important Questions" covers all important mcqs, short and long questions related to above mentioned important  topics of this chapter.

👉Imp MCQs - 2nd year computer science CH # 4

1. In relational database, a table is also called 

(A) File

(B) Field

(C) Relation

(D) Tuple

(C) Relation

2. Different attributes in two different tables having the same names are known as 

(A) Acronym

(B) Homonym

(C) Heteronym

(D) Both A & B

(B) Homonym

3. Which of the following form of dependency is removed  in 2NF ?   

(A) Partial

(B) Complete

(C) Transitive

(D) All of these

(A) Partial

4. Which anomaly result from a transitive dependency:

    

(A) Deletion

(B) Insertion

(C) Modification

(D) All of above

(D) All of above

5. Two or more attributes with different names but same meaning create a problem:

(A) Synonym

(B) Homonym

(C) Aliases

(D) Both A & C

(A) Synonym

6. A Constraint between two attributes is called:

(A) Functional relation

(B) Functional dependency

(C) Attribute dependency

(D) All of above

(B) Functional dependency

👉Next, there is  PDF containing 2nd year computer science chapter 4 important Short and Long Questions covers all important topics of this chapter.

For Answers of these Questions

👉Visit us our YouTube Channel “MHB Academy”. Subscribe and press the bell icon for notifications of updates about 2nd year computer science and other subjects of your concern. 

👉Follow and like our Facebook Page "MHB Educator" for news, FAQs and valuable educational updates.

👉Other Chapters (PDF) of 2nd year computer science Punjab Textbook Board

✅Chapter 1

Data Basics

✅Chapter 2

Basic Concepts and Terminologies of Databases

✅Chapter 3

Database Design Process

✅Chapter 5

Introduction to Microsoft Access

✅Chapter 6

Table and Query

✅Chapter 7

Microsoft Access Forms and Reports

✅Chapter 8

Getting Started With C

✅Chapter 9

Elements of C

✅Chapter 10

Input and Output

✅Chapter 11

Decision Constructs

✅Chapter 12

Loop Constructs

✅Chapter 13

Functions in C

✅Chapter 14

File Handling in C