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
ICS Part 2 Computer Science Chapter 2 Online Test MCQs With Answers
Question # 1
A two-dimensional table of data is called a
Choose an answer
group
set
declaration
relation
Previous
Skip
Next
Question # 2
In relational database a table is also called a:
Choose an answer
Tuple
Relation
File
Schema
Previous
Skip
Next
Question # 3
Which of the following is not a valid variable name ?
Choose an answer
Roll No
Roll No
Roll-No
Roll #
Previous
Skip
Next
Question # 4
A table most has
Choose an answer
primary key
secondary key
composite key
sort key
Previous
Skip
Next
Question # 5
Format specifier is started with:
Choose an answer
'?
&
%
None
Previous
Skip
Next
Question # 6
Microsoft Access saves the database file with the extension:
Choose an answer
.mdb
.msdb
.madb
None of these
Previous
Skip
Next
Question # 7
The symbol '=' represents:
Choose an answer
Comparison operator
Assignment operator
Equal to operator
None of these
Previous
Skip
Next
Question # 8
A row of a relation is called:
Choose an answer
Attribute
Entity
Tuple
a and c
Previous
Skip
Next
Question # 9
An index can be used to :
Choose an answer
Improve the performance of the database
Document the structure of the database
Reduce data dependency for application programs
All
Previous
Skip
Next
Question # 10
The last statement of each case in switch must be a:
Choose an answer
Default statement
If-else statement
Break statement
Else statement
Previous
Skip
Next
Question # 11
The columns of a table correspond to
Choose an answer
table
record
field
cell
Previous
Skip
Next
Question # 12
A row of relation is called
Choose an answer
attribute
entity
tuple
both a & c
Previous
Skip
Next
Question # 13
Insert command is used to insert:
Choose an answer
New table
New record
View
Dependences
Previous
Skip
Next
Question # 14
All the intersection of rows and columns must have:
Choose an answer
Single value
Constant value
Multiple values
No value
Previous
Skip
Next
Question # 15
Which type of variable can store real value
Choose an answer
int
long int
char
Float
Previous
Skip
Next
Question # 16
The foreign key is found in:
Choose an answer
Parent table
Dependent table
Pivot table
Index table
Previous
Skip
Next
Question # 17
Which is a loop statement?
Choose an answer
If
If-else
Switch
None of these
Previous
Skip
Next
Question # 18
Which of the following are properties of relations?
Choose an answer
Each attribute has a unique name
No two rows in a relation are identical
There are no multivalued attributes in a relation
All of the above
Previous
Skip
Next
Question # 19
SQL is used for:
Choose an answer
Data definition
Data manipulaton
Data control
All
Previous
Skip
Next
Question # 20
SQL is used for
Choose an answer
data definition
data manipulation
a and b
searching record
Previous
Skip
Next
Question # 21
A form that contains the sub-form is called:
Choose an answer
Form
Main form
Report
None of these
Previous
Skip
Next
Question # 22
Which loop statement executes the body of loop at least once?
Choose an answer
do-white
While
For
None of these
Previous
Skip
Next
Back