12th Class ICS Computer Science Chapter 4 Online MCQ Test for (Data Integrity and Normalization)

ICS Part 2 Computer Science Online
Chapter 4 Test

Start Chapter 4 Test

MCQ's Test For Chapter 0 "ICS Part 2 Computer Science Chapter 4 Online Test"

Try The MCQ's Test For Chapter 0 "ICS Part 2 Computer Science Chapter 4 Online Test"

  • Total Questions17

  • Time Allowed20

ICS Part 2 Computer Science Chapter 4 Online Test

00:00
Question # 1

Every relation should have :

Question # 2

------------------- is created when two different names are used for the same information

Question # 3

The goal of normalization is to:

Question # 4

The program structure that executes program statements in order is

Question # 5

In 3NF, a non-key attribute must not depend on a :

Question # 6

Any array script should be:

Question # 7

Which of the following is a decision making statement

Question # 8

C was developed in the year:

Question # 9

The scope of a variable refers to its:

Question # 10

A relation is in third normal form if it is in second normal form and:

Question # 11

We can make two way decisions with the help of

Question # 12

In 3NT which form of dependency is removed ?

Question # 13

Which of the following anomalies result from a transitive dependency ?

Question # 14

Which form of dependency is removed in 2NF?

Question # 15

In 3NF, a non key attribute must not depend on a

Question # 16

The case block ends with:

Question # 17

A functional dependency between two or more non-key attributes is called:

Prepare Complete Set Wise Chapter 0 "ICS Part 2 Computer Science Chapter 4 Online Test" MCQs Online With Answers


Topic Test

00:00
4th Chapter

ICS Part 2 Computer Science Chapter 4 Online Test MCQ's

Top Scorers Of Chapter 0 "ICS Part 2 Computer Science Chapter 4 Online Test" MCQ`s Test

  • D
    Dua Sohail 19 - Jun - 2024 01 Min 39 Sec 17/17
  • A
    Ayesha Khan 04 - Jun - 2024 09 Min 44 Sec 17/17
  • M
    Muhammad Usama 16 - Feb - 2026 01 Min 22 Sec 15/17
  • E
    Ehtisham Arain 29 - Apr - 2024 02 Min 35 Sec 15/17
  • M
    mueez farhan 18 - Sep - 2024 02 Min 45 Sec 15/17
  • H
    Hassaam Haral 04 - Jun - 2024 02 Min 17 Sec 14/17
  • S
    Salman Malik 03 - Dec - 2024 02 Min 18 Sec 14/17
  • R
    Rehan Jarral 30 - Sep - 2025 101 Min 20 Sec 14/17
  • M
    Mariam Saleem 09 - May - 2024 00 Min 03 Sec 13/17
  • A
    ABBASI BEAST 29 - Apr - 2024 00 Min 05 Sec 13/17
  • S
    SYED MUNEEB GILLANI 29 - Apr - 2024 03 Min 03 Sec 13/17
  • M
    Mohammad Sachal Tanveer 18 - Mar - 2026 03 Min 05 Sec 13/17
  • T
    Taiba Usman 09 - Jun - 2024 03 Min 18 Sec 13/17
  • M
    Muhammad Adeel 02 - Apr - 2026 03 Min 19 Sec 13/17
  • Z
    Zafeer ul Hassan 06 - Jul - 2024 00 Min 45 Sec 12/17

ICS Part II Computer Science Chapter 0 Important MCQ's

Sr.# Question Answer
1 Which form of dependency is removed n 3NF?
A. Functional
B. Non-functional
C. Associative
D. Transitive
2 ------------ is a constraint on primary values that states that no attribute of a primary key should contain nulls
A. referential integrity
B. entity integrity
C. normalization
D. acronyms
3 A rule that states each foreign key value must match a primary key value in the other relation is called:
A. Referential integrity constraints
B. Key match rule
C. Entity key group rule
D. Foreign/ primary match rule
4 In 3NF, a non key attribute must not depend on a
A. non key attribute
B. key attribute
C. composite key
D. sort key
5 The scope of a variable refers to its:
A. Length
B. Name
C. Accessibility
D. Data type
6 Which can be previewed on the screen before printing?
A. Report
B. Form
C. Sub-form
D. None
7 Which is a possible value of flag?
A. -
B. +
C. Space
D. All of these
8 The entity integrity rule states that:
A. No primary key attribute can be null
B. Each entity must have a primary key
C. Primary key must have only one attribute
D. None
9 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
10 In 3NT which form of dependency is removed ?
A. functional
B. non-functional
C. associative
D. transitive

Test Questions