×
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
ic

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

Sr. # Questions Answers Choice
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 > 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

Muhammad Asif

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

Share your comments questions here
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

Sign in

to continue to ilmkidunya.com

X

Forgot Password

to continue to ilmkidunya.com

X

Register Type

Please Provide following information to Register

  • Student
  • Tutor
  • Consultant
  • Employer