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
A relation is in 2NF if it is in 1NF and all its non-key attributes are:
Choose an answer
Dependent on part of the primary key
Dependent on the entire primary key
Independent on the primary key
Independent of any other relation
Previous
Skip
Next
Question # 2
Which can be previewed on the screen before printing?
Choose an answer
Report
Form
Sub-form
None
Previous
Skip
Next
Question # 3
The scope of a variable refers to its:
Choose an answer
Length
Name
Accessibility
Data type
Previous
Skip
Next
Question # 4
The conditional part of if statement consists of expression
Choose an answer
arithmetic
logical expression
relational
both b and c
Previous
Skip
Next
Question # 5
Which of the following are anomalies that can be caused by redundancy in tables?
Choose an answer
Insertion
Deletion
Modification
All
Previous
Skip
Next
Question # 6
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 # 7
Different attributes in two different tables having same name are called:
Choose an answer
Synonym
Homonym
Acronym
Mutually exclusive
Previous
Skip
Next
Question # 8
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 # 9
------------------- 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 # 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 format specific is used for integer data type?
Choose an answer
%d
%S
%C
%f
Previous
Skip
Next
Question # 12
The case block ends with:
Choose an answer
End Select
End case
Break
Case else
Previous
Skip
Next
Question # 13
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 # 14
Every relation should have :
Choose an answer
Primary key
Candidate key
Secondary key
Mutually exclusiveness
Previous
Skip
Next
Question # 15
Storing the same information in two different ways or forms is called
Choose an answer
database integrity
redundant information
homonyms
mutually exclusive data
Previous
Skip
Next
Question # 16
Which of the following is a decision making statement
Choose an answer
break
getch ( )
if
all
Previous
Skip
Next
Question # 17
We can make two way decisions with the help of
Choose an answer
if
nested
if-else
all
Previous
Skip
Next
Back