×
4th Chapter

### 12th Class Computer Science Chapter 4 Test

Here you can prepare 12th Class Computer Science Chapter 4 Data Integrity and Normalization Test. Click the button for 100% free full practice test.

## 2nd Year Computer Science Chapter 4 Online MCQ Test for 12th Class Computer Science Chapter 4 (Data Integrity and Normalization)

This online test contains MCQs about following topics:

- Overview
- Data Integrity

ICS Part 2 Computer Sci Ch. 4 Test

### 2nd Year Computer Science Chapter 4 Online MCQ Test for 12th Class Computer Science Chapter 4 (Data Integrity and Normalization)

1 Which of the following are anomalies that can be caused by redundancy in tables?
• A. Insertion
• B. Deletion
• C. Modification
• D. All
2 The type of expression x &gt; y is
• A. arithmetic
• B. logical
• C. relational
• D. conditional
3 In 3NT which form of dependency is removed ?
• A. functional
• B. non-functional
• C. associative
• D. transitive
4 The program structure that executes program statements in order is
• A. selection
• B. sequence
• C. repetition
• D. iteration
5 A relation is in third normal form if it is in second normal form and:
• A. Dependent on part of the key
• B. Dependent on the whole key
• C. Independent of the key
• D. Has no transitive dependencies
6 The operator that is used in decision making is
• A. increment operator
• B. decrement operator
• C. condition operator
• D. none
7 Two or more attributes with different name but same meaning create a problem:
• A. Homonyms
• B. Synonyms
• C. Aliases
• D. Alternate attributes
8 The 1NF describes the tabular format in which:
• A. All the key attributes are defined
• B. No repeating groups in the table
• C. All attributes are dependent on primary key
• D. All
9 ------------------- is created when two different names are used for the same information
• A. synonyms
• B. homonyms
• C. mutually exclusive data
• D. redundant information
10 Which is a possible value of flag?
• A. -
• B. +
• C. Space
• D. All of these

### Top Scorers of Computer Science Ics Part 2 Chapter 4 Online Test

Z

#### Zainab Imtyaz

Lahore22 - Nov - 2021

15/17
03 Mins 26 Sec
F

#### Farhan Abbasi

Lahore02 - Nov - 2021

12/17
01 Mins 55 Sec
F

#### Farhan Abbasi

Lahore02 - Nov - 2021

11/17
02 Mins 28 Sec
M

Lahore16 - Jan - 2022

11/17
03 Mins 47 Sec
W

#### Waseem Aijaz

Lahore06 - Dec - 2021

10/17
05 Mins 20 Sec
F

#### Farhan Abbasi

Lahore18 - Nov - 2021

9/17
03 Mins 25 Sec

Sort By:

## Find the best institute for yourself!

We need a few details from you to suggest you relevant institutes & create your free profile

## Online Famous Poets of Pakistan Quiz

##### 10 Questions
Start Quiz
X

to continue to ilmkidunya.com

X