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 is a decision making statement
Choose an answer
break
getch ( )
if
all
Previous
Skip
Next
Question # 2
Which object of database is used to retrieve data from database?
Choose an answer
Queries
Forms
Reports
Tables
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 are basic data distribution strategies?
Choose an answer
Centralized
Partitioned
Replication
All
Previous
Skip
Next
Question # 5
In 3NT which form of dependency is removed ?
Choose an answer
functional
non-functional
associative
transitive
Previous
Skip
Next
Question # 6
The conditional part of if statement consists of expression
Choose an answer
arithmetic
logical expression
relational
both b and c
Previous
Skip
Next
Question # 7
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 # 8
The case block ends with:
Choose an answer
End Select
End case
Break
Case else
Previous
Skip
Next
Question # 9
Every relation should have :
Choose an answer
Primary key
Candidate key
Secondary key
Mutually exclusiveness
Previous
Skip
Next
Question # 10
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 # 11
------------ 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 # 12
Which can be previewed on the screen before printing?
Choose an answer
Report
Form
Sub-form
None
Previous
Skip
Next
Question # 13
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 # 14
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 # 15
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 # 16
The program structure that executes program statements in order is
Choose an answer
selection
sequence
repetition
iteration
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
Back