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

ICS Part 2 Computer Science Wise Online
MCQ's 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

Start Test Download PDF

ICS Part 2 Computer Science Chapter 4 Online Test

00:00
Question # 1

Which of the following is a decision making statement

Question # 2

A constraint between two attributes is called:

Question # 3

The type of expression x > y is

Question # 4

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

Question # 5

In 2NF, which form of dependency is removed ?

Question # 6

We can make two way decisions with the help of

Question # 7

Which form of dependency is removed n 3NF?

Question # 8

Which format specific is used for integer data type?

Question # 9

Which can be previewed on the screen before printing?

Question # 10

The case block ends with:

Question # 11

How many table views are available in MS Access?

Question # 12

The entity integrity rule states that:

Question # 13

Which form of dependency is removed in 2NF?

Question # 14

The value of expression in switch statement must be type of

Question # 15

The columns of a table correspond to:

Question # 16

Another term for a conditional operator is:

Question # 17

Which is a possible value of flag?

Submit

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


ic-science-white
Computer Science
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
Sr.# Question Answer
1 In relational data base, a table is also called:
A. Tuple
B. Relation
C. File
D. Schema
2 A constraint between two attributes is called:
A. Functional relation
B. Attribute dependency
C. Functional dependency
D. Functional relation constaint
3 The operator that is used in decision making is
A. increment operator
B. decrement operator
C. condition operator
D. none
4 Which can be previewed on the screen before printing?
A. Report
B. Form
C. Sub-form
D. None
5 How many table views are available in MS Access?
A. 1
B. 3
C. 2
D. 4
6 Another term for a conditional operator is:
A. Ternary
B. Binary
C. Byte
D. Iteration
7 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
8 We can make two way decisions with the help of
A. if
B. nested
C. if-else
D. all
9 Which object of database is used to retrieve data from database?
A. Queries
B. Forms
C. Reports
D. Tables
10 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
11 The conditional part of if statement consists of expression
A. arithmetic
B. logical expression
C. relational
D. both b and c
12 In 3NF, a non-key attribute must not depend on a :
A. Non-key attribute
B. Key attribute
C. Composite key
D. Sort key
13 In 3NF, a non key attribute must not depend on a
A. non key attribute
B. key attribute
C. composite key
D. sort key
14 In 3NT which form of dependency is removed ?
A. functional
B. non-functional
C. associative
D. transitive
15 In relational database, table is also called:
A. Table
B. Relation
C. File
D. Schema
16 Different attributes in two different tables having same name are called:
A. Synonym
B. Homonym
C. Acronym
D. Mutually exclusive
17 Which form of dependency is removed in 2NF?
A. Functional
B. Transitive
C. Associative
D. Partial

Test Questions

Is this page helpful?