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
Computer Science Ics Part 2 Chapter 4 Online Test MCQs With Answers
Question # 1
The type of expression x > y is
Choose an answer
arithmetic
logical
relational
conditional
Previous
Skip
Next
Question # 2
In 2NF, which form of dependency is removed ?
Choose an answer
associative
transitive
partial
functional
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
Different attributes in two different tables having same name are called:
Choose an answer
Synonym
Homonym
Acronym
Mutually exclusive
Previous
Skip
Next
Question # 5
A rule that states each foreign key value must match a primary key value in the other relation is called:
Choose an answer
Referential integrity constraints
Key match rule
Entity key group rule
Foreign/ primary match rule
Previous
Skip
Next
Question # 6
The value of expression in switch statement must be type of
Choose an answer
int
char
float
both a and b
Previous
Skip
Next
Question # 7
The operator that is used in decision making is
Choose an answer
increment operator
decrement operator
condition operator
none
Previous
Skip
Next
Question # 8
The number of bytes used by 'int' data type in C are:
Choose an answer
2
8
12
16
Previous
Skip
Next
Question # 9
Two or more attributes with different name but same meaning create a problem:
Choose an answer
Homonyms
Synonyms
Aliases
Alternate attributes
Previous
Skip
Next
Question # 10
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 # 11
Which are basic data distribution strategies?
Choose an answer
Centralized
Partitioned
Replication
All
Previous
Skip
Next
Question # 12
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 # 13
The case block ends with:
Choose an answer
End Select
End case
Break
Case else
Previous
Skip
Next
Question # 14
The columns of a table correspond to:
Choose an answer
Table
Record
Field
Cell
Previous
Skip
Next
Question # 15
------------- 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 # 16
------------------- is created when two different names are used for the same information
Choose an answer
synonyms
homonyms
mutually exclusive data
redundant information
Previous
Skip
Next
Question # 17
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 # 18
A constraint between two attributes is called:
Choose an answer
Functional relation
Attribute dependency
Functional dependency
Functional relation constaint
Previous
Skip
Next
Back