Important Question for ICS Computer Science Part-2
Chapter-01+ 02(Data
Basics + Basic concepts and Terminologies of Databases)
|
Q-1: Chose the correct option.
1x14=14
|
||||
|
1
|
The process of arranging data in a logical
sequence is called.
|
|||
|
|
Sorting
|
Summarizing
|
Data capturing
|
classifying
|
|
2
|
A collection of related fields is
|
|||
|
|
File
|
Record
|
Database
|
None
|
|
3
|
DPMS stands for:
|
|||
|
|
Database modeling system
|
Database Management System
|
Data business model system
|
Data business Management services
|
|
4
|
Which of the following is handled by DBMS?
|
|||
|
|
Data integrity
|
Data security
|
Data independence
|
All
|
|
5
|
The major components of DBMS is called
|
|||
|
|
Database manager
|
File manager
|
Data manager
|
All
|
|
6
|
SQL is a (n)
|
|||
|
|
Unstructured language
|
Structured language
|
Object oriented programming
|
Software
|
|
7
|
DBA stands for:
|
|||
|
|
Database administrator
|
Data basic Administration
|
Database Application
|
Database authority
|
|
8
|
A primary key that consists of more than one
attribute is called a:
|
|||
|
|
Foreign key
|
Composite key
|
Multimedia key
|
Global key
|
|
9
|
Which of the following describes the primary
key?
|
|||
|
|
It must be unique
|
It helps in indexing of a large database
|
It makes sorting quicker
|
All
|
|
10
|
An attribute is also known as :
|
|||
|
|
Table
|
Relation
|
Row
|
Field
|
|
11
|
A relation is also known as:
|
|||
|
|
Table
|
Tuple
|
Relationship
|
Attribute
|
|
12
|
SQL is used for:
|
|||
|
|
Data definition
|
Data manipulation
|
Data definition and manipulation
|
Searching records
|
|
13
|
An index can be used to:
|
|||
|
|
Improve the performance of the database
|
Document the structure of the database itself
|
Reduce data dependencey for application program
|
All
|
|
14
|
A key that is used strictly for data retrieval purposes:
|
|||
|
|
Secondary key
|
Candidate key
|
Composite key
|
Primary key
|
Q-2: Write short answers any TEN, each question
carry 2 marks. 2x10=20
i.
Define Database.
ii.
Who is data administrator?
iii.
What you know about foreign key.
iv.
Define Candidate key / alternate key?
v.
What is primary key.
vi.
Write the names of different keys which use in
database,
vii.
What is entity? Give an example.
viii.
What is secondary key?
ix.
Write 3 advantages of DBMS.
x.
Define consistency constraints?
xi.
What is DBMS?
xii.
Describe Data manipulation.
xiii.
Define Data processing.
Q-3: Write detail answers of the following
questions. 2x8=16
i.
What is a key? Describe different types of keys
used in databases.
ii.
What is DBMS? Briefly describe the advantages and
disadvantages of DBMS.
ICS Part-1 notes for:
FBISE Islamabad ICS Part-2 computer science notes
BISE Lahore ICS Part-2 computer science notes
BISE Multan ICS Part-2 computer science notes
BISE Gujranwala ICS Part-2 computer science notes
BISE Rawalpindi ICS Part-2 computer science notes
BISE Bahawalpur ICS Part-2 computer science notes
BISE Peshawar ICS Part-2 computer science notes
BISE Abbottabad ICS Part-2 computer science notes
BISE Kohat ICS Part-2 computer science notes
BISE Bannu ICS Part-2 computer science notes
BISE Mardan ICS Part-2 computer science notes
BISE Swat ICS Part-2 computer science notes
BISE Malakand ICS Part-2 computer science notes
BISE Hyderabad ICS Part-2 computer science notes
BISE Sukkur ICS Part-2 computer science notes
BIE Karachi ICS Part-2 computer science notes