M.Sc. (Semester III) (CBCS) Examination Oct/Nov-2017
Bioinformatics
BIOLOGICAL DATABASE MANAGEMENT SYSTEM
Day Date: Thursday, 16-11-2017 Max. Marks: 70
Time: 02.30 PM to 05.00 PM
Instructions: Part-1, Question 1 is compulsory.
Attempt any four questions from Part-II.
Figures to the right indicate full marks.
Draw neat and labeled diagram.
All questions carry equal marks.
PART I
Q.1 Rewrite the sentence after choosing the correct answer from the
given alternatives:
07
is a collection of recorded data.
Data Software
Database Scheme
Relational model was invented by
Chris Date Hugh Darwen
E. F. Codd Bill Gates
statement makes 'permanent' all changes performed in
the current transaction.
Rollback Truncate
Commit None of these
E
DML is provided
Description of logical structure of database.
Manipulation processing of database.
Addition of new structures in the database system.
Definition of physical stricture 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 is a query that retrieves rows from more than one table
or view:
Start End
Join All of the mentioned
product is returned in a join query have no join condition:
Equijoins Cartesian
Both None of the mentioned
Page 2 of 2
SLR-MC-75
Definitions. 07
Table
Foreign Key.
Data Independence.
Cardinality.
Procedure.
Rollback
View.
PART II
Answer any four of the following.
Q2 Explain Limitations of traditional file processing system Advantages of
DBMS?
14
Q3 Explain Components of DBMS. 14
Q4 Explain Data mining with Types of Data mining techniques and different types
of application.
14
Q5 Answer any two of the following. 14
Users of DBMS.
ER Symbols.
Normalization.
Q6 Answer any two of the following. 14
DML Commands.
Join Operations.
What is PL/SQL? Features of PL/SQL?