Master of Science II (Bioinformatics) Examination:
Oct Nov 2016 Semester III (New CBCS)
SLR No. Day
Date Time Subject Name Paper
No. Seat No.
SLR SR
80
Wednesday
16/11/2016
2:30 P.M
to
5:00 P.M
Biological Database
Management System
C
IX
Instructions: Section I is compulsory.
Attempt any four questions from section II.
All questions carry equal marks.
Figures to the right indicate full marks.
Draw neat and labeled diagrams.
Total Marks: 70
Section I
Q.1 Complete the sentences by selecting correct answers from given
alternatives:
07
For each attribute of a relation, there is a set of permitted values, called
the of that attribute.
Domain Relation
Set Schema
Relational model was invented by
Chris Date Hugh Darwen
E. F. Codd Bill Gates
makes 'permanent' all changes performed in the
current transaction.
Rollback Truncate
Commit None of these
DML is provided for
Description of logical structure of database.
Manipulation processing of database.
Addition of new structures in the database system.
Definition of physical structure of database system.
combines the data manipulating power of SQL with the data
processing power of Procedural Languages.
PL/SQL SQL
Advanced SQL PQL
A a query that retrieves rows from more than one table or
view.
Start End
Join All of the mentioned
is returned in a join query have no join condition.
Equijoins Cartesian
Both None of the mentioned
Definitions: 07
Table
Foreign Key
Data Independence
Cardinality
Procedure
Rollback
View
PART II
Answer any four of the following:
Q.2 Explain limitations of traditional file processing systems advantages of
DBMS.
14
Q.3 Explain components of DBMS. 14
Q.4 Explain Data mining with types of Data mining techniques and different types
of application.
14
Q.5 Answers any two from the following: 14
Users of DBMS
ER Symbols
Normalization
Q.6 Write short notes on any two: 14
DML Commands
Join Operations
What is PL/SQL. Features of PL/SQL.