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

Which are basic data distribution strategies?

Question # 2

The entity integrity rule states that:

Question # 3

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

Question # 4

Which object of database is used to retrieve data from database?

Question # 5

A rule that states each foreign key value must match a primary key value in the other relation is called:

Question # 6

Every relation should have :

Question # 7

In relational data base, a table is also called:

Question # 8

Which of the following anomalies result from a transitive dependency ?

Question # 9

In 2NF, which form of dependency is removed ?

Question # 10

The conditional part of if statement consists of expression

Question # 11

Which format specific is used for integer data type?

Question # 12

The goal of normalization is to:

Question # 13

Which of the following are anomalies that can be caused by redundancy in tables?

Question # 14

The value of expression in switch statement must be type of

Question # 15

C was developed in the year:

Question # 16

Which is a possible value of flag?

Question # 17

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

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
  • A
    Ahmad 28 - Apr - 2024 02 Min 25 Sec 16/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
  • T
    Taiba Usman 09 - Jun - 2024 03 Min 18 Sec 13/17
  • Z
    Zafeer ul Hassan 06 - Jul - 2024 00 Min 45 Sec 12/17
  • A
    asad 28 - Apr - 2024 01 Min 13 Sec 12/17
  • A
    Alina Sarwar 08 - Jun - 2024 02 Min 40 Sec 12/17

ICS Part II Computer Science Chapter 0 Important MCQ's

Sr.# Question Answer
1 The operator that is used in decision making is
A. increment operator
B. decrement operator
C. condition operator
D. none
2 Which of the following anomalies result from a transitive dependency ?
A. Insertion
B. Modification
C. Deletion
D. All
3 A relation is in 2NF if it is in 1NF and all its non-key attributes are:
A. Dependent on part of the primary key
B. Dependent on the entire primary key
C. Independent on the primary key
D. Independent of any other relation
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 In relational database, table is also called:
A. Table
B. Relation
C. File
D. Schema
6 Database integrity refers to the
A. correctness of data
B. consistency of data
C. both a and b
D. none of these
7 The value of expression in switch statement must be type of
A. int
B. char
C. float
D. both a and b
8 Any array script should be:
A. Int
B. Float
C. Double
D. Array
9 Storing the same information in two different ways or forms is called
A. database integrity
B. redundant information
C. homonyms
D. mutually exclusive data
10 Which object of database is used to retrieve data from database?
A. Queries
B. Forms
C. Reports
D. Tables

Test Questions

Is this page helpful?

Share your comments & questions here

Guest
  • No comments yet. Be the first to comment!