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
Which of the following anomalies result from a transitive dependency ?
Choose an answer
Insertion
Modification
Deletion
All
Previous
Skip
Next
Question # 2
The 1NF describes the tabular format in which:
Choose an answer
All the key attributes are defined
No repeating groups in the table
All attributes are dependent on primary key
All
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
Which format specific is used for integer data type?
Choose an answer
%d
%S
%C
%f
Previous
Skip
Next
Question # 5
Which is a possible value of flag?
Choose an answer
-
+
Space
All of these
Previous
Skip
Next
Question # 6
Different attributes in two different tables having same name are called:
Choose an answer
Synonym
Homonym
Acronym
Mutually exclusive
Previous
Skip
Next
Question # 7
The columns of a table correspond to:
Choose an answer
Table
Record
Field
Cell
Previous
Skip
Next
Question # 8
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 # 9
------------- 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 # 10
Which of the following is a decision making statement
Choose an answer
break
getch ( )
if
all
Previous
Skip
Next
Question # 11
Which form of dependency is removed n 3NF?
Choose an answer
Functional
Non-functional
Associative
Transitive
Previous
Skip
Next
Question # 12
Which form of dependency is removed in 2NF?
Choose an answer
Functional
Transitive
Associative
Partial
Previous
Skip
Next
Question # 13
A constraint between two attributes is called:
Choose an answer
Functional relation
Attribute dependency
Functional dependency
Functional relation constaint
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
------------ 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 # 16
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 # 17
We can make two way decisions with the help of
Choose an answer
if
nested
if-else
all
Previous
Skip
Next
Back