More Classes
5th Class
6th Class
7th Class
8th Class
9th Class
10th Class
11th Class
12th Class
NAT I
NAT II
CSS
IQ
General Knowledge
MDCAT
ECAT
GAT General
GAT Subject
Other Links
Go to Home
Online Tests
ICS Part 2 Computer Science Chapter 4 Online Test MCQs With Answers
Question # 1
------------- is the process of converting complex data structures into simple and stable data structures
Choose an answer
database integrity
homonyms
normalization
mutually exclusive data
Previous
Skip
Next
Question # 2
Database integrity refers to the
Choose an answer
correctness of data
consistency of data
both a and b
none of these
Previous
Skip
Next
Question # 3
How many table views are available in MS Access?
Choose an answer
1
3
2
4
Previous
Skip
Next
Question # 4
In relational database, table is also called:
Choose an answer
Table
Relation
File
Schema
Previous
Skip
Next
Question # 5
In 3NF, a non key attribute must not depend on a
Choose an answer
non key attribute
key attribute
composite key
sort key
Previous
Skip
Next
Question # 6
The goal of normalization is to:
Choose an answer
Get stable data structure
Increase number of relation
Increase redundancy
Remove constraints
Previous
Skip
Next
Question # 7
Which of the following is a decision making statement
Choose an answer
break
getch ( )
if
all
Previous
Skip
Next
Question # 8
The entity integrity rule states that:
Choose an answer
No primary key attribute can be null
Each entity must have a primary key
Primary key must have only one attribute
None
Previous
Skip
Next
Question # 9
In 3NT which form of dependency is removed ?
Choose an answer
functional
non-functional
associative
transitive
Previous
Skip
Next
Question # 10
The attribute on the left side of the arrow in a functional dependency is called:
Choose an answer
Candidate key
Determinant
Foreign key
Primary key
Previous
Skip
Next
Question # 11
Every relation should have :
Choose an answer
Primary key
Candidate key
Secondary key
Mutually exclusiveness
Previous
Skip
Next
Question # 12
Which object of database is used to retrieve data from database?
Choose an answer
Queries
Forms
Reports
Tables
Previous
Skip
Next
Question # 13
We can make two way decisions with the help of
Choose an answer
if
nested
if-else
all
Previous
Skip
Next
Question # 14
------------ is a constraint on primary values that states that no attribute of a primary key should contain nulls
Choose an answer
referential integrity
entity integrity
normalization
acronyms
Previous
Skip
Next
Question # 15
Any array script should be:
Choose an answer
Int
Float
Double
Array
Previous
Skip
Next
Question # 16
The number of bytes used by 'int' data type in C are:
Choose an answer
2
8
12
16
Previous
Skip
Next
Question # 17
A constraint between two attributes is called:
Choose an answer
Functional relation
Attribute dependency
Functional dependency
Functional relation constaint
Previous
Skip
Next
Back