Chapter 4 Data Integrity And Normalization Computer Science 12th Class Punjab MCQ Tests
12th Class Computer Science Chapter 4 MCQ Tests
Chapter 4 of 12th Class Computer Science has 14 questions. If you take an online MCQ test, the system will randomly choose the questions. If you want to take the quiz by chapter then click the start test button.
Total Questions: 14
Total Marks: 14
Time: 15 Mins
Total Questions: 14
Total Marks: 14
Time: 15 Mins
15Min : 00 Sec Remaining
Question # 1
A teacher attribute in a Score table, is most closely associated with:
Question # 2
Which normal form is considered enough for relational database design?
Question # 3
if a table has more then one candidate key then it needs to be transformed in:
Question # 4
A teacher attribute in a Score table, is most closely associated with:
Question # 5
If there is a duplicate value in Primary Key then it is a violation of:
Question # 6
if an attribute is dependent upon composite primary key then this dependency will be:
Question # 7
Each record of a relation is dependent upon:
Question # 8
if a table has more then one candidate key then it needs to be transformed in:
Question # 9
Which normal form is considered enough for relational database design?
Question # 10
The Alphabetical order of names does not matter in First normal form.
Question # 11
The employee salary should not be greater than Rs. 2000. This is:
Question # 12
The first major problem comes when Tables are not Normalized is:
Question # 13
If composite key is used as primary key in a table then remaining attributes are dependent on part of composite key. It is an example of:
Question # 14
In a university,The Head of Department of Computer Science Department is changed but our database is still showing contact number of ex head of department. The following complication is due to:
Total Questions
1234567891011121314
Question # 1
A teacher attribute in a Score table, is most closely associated with:
Question # 2
Which normal form is considered enough for relational database design?
Question # 3
if a table has more then one candidate key then it needs to be transformed in:
Question # 4
A teacher attribute in a Score table, is most closely associated with:
Question # 5
If there is a duplicate value in Primary Key then it is a violation of:
Question # 6
if an attribute is dependent upon composite primary key then this dependency will be:
Question # 7
Each record of a relation is dependent upon:
Question # 8
if a table has more then one candidate key then it needs to be transformed in:
Question # 9
Which normal form is considered enough for relational database design?
Question # 10
The Alphabetical order of names does not matter in First normal form.
Question # 11
The employee salary should not be greater than Rs. 2000. This is:
Question # 12
The first major problem comes when Tables are not Normalized is:
Question # 13
If composite key is used as primary key in a table then remaining attributes are dependent on part of composite key. It is an example of:
Question # 14
In a university,The Head of Department of Computer Science Department is changed but our database is still showing contact number of ex head of department. The following complication is due to:
Total Questions
1234567891011121314
Computer Science MCQ Test by Topics
Computer Science
- Data Basics
- Basic Concepts and Terminology of Databases
- Database Design Process
- Data Integrity and Normalization
- Introduction to Microsoft Access
- Table and Query
- Microsoft Access-Forms and Reports
- Getting Started with C
- Elements of C
- Input/Output
- Decision Constructs
- Loop Constructs
- Functions in C
- File Handling
12th Class Online Classes 2026
Updated on: 17-10-2026
12th Class Online Preparation
12th Class 2026 Online
12th Class 2026
Add a Comment
Comments will be shown after admin approval.
Spam comments will not be approved at all.
Matric Result 2026 Punjab
10th Class Result 2026 Punjab
9th Class Result 2026 Punjab Boards
10th Class Result Gazette 2026 Punjab
Punjab Past Papers Matric 9th 10th
Primary Results 5th & 8th Class
BISE Results Intermediate & Matric
BISE Punjab Boards
Sindh Educational Boards
KPK Examination Boards
Technical Boards
Public Service Commission
University Results Gruaduation, Masters Classes
Subscribe by Email
Subscribe by Email
Subscribe to Rss Feed
Position Holders Matric 2026
Position Holders 9th Class 2026
Position Holders Inter 2026
Position Holders 11th Class 2026
Punjab 12th Class Computer Science