M.Sc. (Semester III) (CBCS) Examination Nov/Dec-2018
Bioinformatics
BIOLOGICAL DATABASE MANAGEMENT SYSTEM
Time: 2½ Hours Max. Marks: 70
Instructions: All questions are compulsory
Figures to the right indicate full marks.
Q.1 Complete the sentences by selecting correct answer fm the given
alternatives:-
14
In the relational modes, cardinally is termed as
Number of tuples Number of attributes
Number of tables Number of constraints
Cartesian product in relational algebra is
A Unary operator A Binary operator
A Ternary operator Not defined
DML is provided for
Description of logical structure of database
Addition of new structures in the database system
Manipulation processing of database
Definition of physical structure of database system
In a relational model, relations are termed as
Tuples Attributes
Tables Rows
An entity set that does not have sufficient attributes to form a primary key
is a
Strong entity set Weak entity set
Simple entity set Primary entity set
In a Hierarchical model records are organized as
Graph List
Links Tree
Related fields in a database are grouped to form a
Data file Data record
Menu Bank
In an E-R diagram an entity set is represent by a
Rectangle Ellipse
Diamond box Circle
A table joined with itself is called
Join Self join
Outer join Equi join
10) Which of the following is used to declare a record?
%ROWTYPE %TYPE
%CHAR %DATE
Page 2 of 2
SLR-VC-56
11) is a particular property, which describes the entity.
Table Relation
CHAR Attribute
12) A with respect to DBMS relates to user commands that are used
to interact with a data base.
Command Query
Function Database
13) You communicate with a RDBMS using
Java Perl
C SQL
14) While working at IBM, created the relational database model.
Dennis Ritchie Larry Ellison
E.F. Codd E. Kanh
Q.2. Answer of the following (Any Four) 08
What is mean by Sub query?
Name and describe three types of binary relationships.
Define Aggregation.
Write components of DBMS.
What is Relationship?
Write notes on (Any Two) 06
Write a note on Relational Algebra.
Explain in detail Functional Dependency.
Write a short note on RDBMS KERNEL.
Q.3. Answer the following (Any Two) 08
Write a note on 'Database Trigger'.
Describe in detail SQL and its Statements.
Explain in detail data types in PLSQL.
Answer the following (Any One) 06
Create table using DCL commands.
Write a note on three schema architecture in DBMS.
Q.4. Answer the following (Any Two) 10
What are partial, alternate, artificial, compound and natural key?
Write a simple program on DDL statements.
Describe Data mining tools in detail.
Answer the following (Any One) 04
Write a short note on OLAP.
Explain in detail domain constraints.
Q.5. Answer the following (Any Two) 14
Give brief account on features of DBMS.
Write a note on Data Normalization.
Explain in detail account on Data Model.