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 constraint between two attributes is called:
Choose an answer
Functional relation
Attribute dependency
Functional dependency
Functional relation constaint
Previous
Skip
Next
Question # 2
Which form of dependency is removed n 3NF?
Choose an answer
Functional
Non-functional
Associative
Transitive
Previous
Skip
Next
Question # 3
In 2NF, which form of dependency is removed ?
Choose an answer
associative
transitive
partial
functional
Previous
Skip
Next
Question # 4
Which form of dependency is removed in 2NF?
Choose an answer
Functional
Transitive
Associative
Partial
Previous
Skip
Next
Question # 5
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 # 6
Every relation should have :
Choose an answer
Primary key
Candidate key
Secondary key
Mutually exclusiveness
Previous
Skip
Next
Question # 7
A relation is in third normal form if it is in second normal form and:
Choose an answer
Dependent on part of the key
Dependent on the whole key
Independent of the key
Has no transitive dependencies
Previous
Skip
Next
Question # 8
The type of expression x > y is
Choose an answer
arithmetic
logical
relational
conditional
Previous
Skip
Next
Question # 9
Which is a possible value of flag?
Choose an answer
-
+
Space
All of these
Previous
Skip
Next
Question # 10
Which are basic data distribution strategies?
Choose an answer
Centralized
Partitioned
Replication
All
Previous
Skip
Next
Question # 11
A functional dependency between two or more non-key attributes is called:
Choose an answer
Partial functional dependency
Partial non-key dependency
Transitive dependency
None
Previous
Skip
Next
Question # 12
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 # 13
Which of the following anomalies result from a transitive dependency ?
Choose an answer
Insertion
Modification
Deletion
All
Previous
Skip
Next
Question # 14
In relational database, table is also called:
Choose an answer
Table
Relation
File
Schema
Previous
Skip
Next
Question # 15
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 # 16
How many types of loop structure are available in C?
Choose an answer
4
3
2
6
Previous
Skip
Next
Question # 17
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 # 18
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
Back