CS/B.Sc. (H)/BT/Gen./Micro.-Bio./Mol.-Bio./SEM-4/CA-401/2013
2013
INTRODUCTION TO DBMS COMPUTER NETWORK
AND NUMERICAL ANALYSIS
Time Allotted : 3 Hours Full Marks : 70
The figures in the margin indicate full marks.
Candidates are required to give their answers in their own words
as far as practicable.
GROUP – A
( Multiple Choice Type Questions )
1. Choose the correct alternatives for the following : 10 × 1 = 10
i) In a DBMS, SQL is used to
a) retrieve stored data
b) removing records
c) define database schema
d) all of these.
ii) In ER diagram, the derived attribute is graphically
represented as
a) Pentagon b) Ellipse
c) Dotted ellipse d) Triangle.
iii) A transaction is said to be in committed state only after
a) final statement has been executed
b) successful completion
c) it has been rolled back
d) none of these.
iv) The logical structure of a database is termed as
a) schema b) instance
c) table d) atomicity.
v) The task of data encryption belongs to
a) application layer b) presentation layer
c) data-link layer d) session layer.