Home
News
Colleges
Courses
Admission
Lectures
Online Test
Past Papers
Date Sheets
Results
Study Abroad
Jobs
Tutors
More
Apps
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
ICS Part 2 Computer Science Chapter 4 Online Test
00:00
Question # 1
How many table views are available in MS Access?
Question # 2
Which of the following anomalies result from a transitive dependency ?
Question # 3
A relation is in 2NF if it is in 1NF and all its non-key attributes are:
Question # 4
A relation is in third normal form if it is in second normal form and:
Question # 5
In 3NF, a non-key attribute must not depend on a :
Question # 6
In 3NT which form of dependency is removed ?
Question # 7
The entity integrity rule states that:
Question # 8
Every relation should have :
Question # 9
Which can be previewed on the screen before printing?
Question # 10
The number of bytes used by 'int' data type in C are:
Question # 11
The operator that is used in decision making is
Question # 12
The case block ends with:
Question # 13
The value of expression in switch statement must be type of
Question # 14
The goal of normalization is to:
Question # 15
Which form of dependency is removed n 3NF?
Question # 16
Which of the following are anomalies that can be caused by redundancy in tables?
Question # 17
In relational data base, a table is also called:
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 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
|
| 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 | Which can be previewed on the screen before printing? |
A. Report
B. Form
C. Sub-form
D. None
|
| 4 | In 3NT which form of dependency is removed ? |
A. functional
B. non-functional
C. associative
D. transitive
|
| 5 | Which form of dependency is removed n 3NF? |
A. Functional
B. Non-functional
C. Associative
D. Transitive
|
| 6 | The goal of normalization is to: |
A. Get stable data structure
B. Increase number of relation
C. Increase redundancy
D. Remove constraints
|
| 7 | Which are basic data distribution strategies? |
A. Centralized
B. Partitioned
C. Replication
D. All
|
| 8 | Storing the same information in two different ways or forms is called |
A. database integrity
B. redundant information
C. homonyms
D. mutually exclusive data
|
| 9 | 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
|
| 10 | In 3NF, a non key attribute must not depend on a |
A. non key attribute
B. key attribute
C. composite key
D. sort key
|
Test Questions
