Download SGBAU BSc 2019 Summer 6th Sem Bioinformatics Advanced Biocomputing Question Paper

Download SGBAU (Sant Gadge Baba Amravati university) BSc 2019 Summer (Bachelor of Science) 6th Sem Bioinformatics Advanced Biocomputing Previous Question Paper

AW?1783
B.Sc. (Part?III) Semester?Vl Examination
BIOINFORMATICS
(Advanced Bio-Computing)
'l?imc : Three Hours] [Maximum Marks : 80
Note :?( 1) All questions are compulsory.
(2) Draw diagrams wherever necessary.
1. (3) Fill in the blanks :
(b)
(C)
2 (a)
(b)
3. (a)
(b)
4. (a)
G) The row of a relation is called a
(1i) BCNF stands for
(iii) When a function calls itself again and again, it is called _.
(iv) To modify the structure of an existing table _ statement is used. 2
Choose the correct alternative :
(1) Which datatype is not allowed in the de?nition of PL/SQL record ?
(a) X collection (b) X scalar
(c) Both (a) and (b) (d) None of the above
(ii) Which operator performs pattern matching ?
(a) BETWEEN (b) LIKE
(c) EXISTS (d) None of the above
(iii) Which member can never be accessed by inherited classes ?
(a) Private (b) Public
(c) Protected (d) All can be accessed
(iv) Which function is used by PERL for displaying the length of a string ?
(a) Suing (b) 1m
(c) Split (d) Length 2
De?ne the following :
(i) Class
(ii) Constructor
(iii) Encapsulation
(iv) Joins. 4
What is OOPS ? Explain its features. 6
Explain the structure of OH with example. 6
0R
Explain inline function with suitable example. 6
Explain the various datatypes in C++. 6
Explain the following terms :
(1) Data abstraction
(ii) Encapsulation. 6
(b) Explain the concept of constructor with suitable example. 6
OR
YBC?l6928 1 (Contd.)

10.
11.
12.
13.
(a)
(b)
(a)
(b)
(a)
(b)
(a)
(b)
(a)
(b)
(a)
(b)
(a)
(b)
(a)
(b)
(a)
(b)
What is operator overloading ?? Explain.
De?ne inheritance and explain its types with example.
What is normalisation ? Explain HF and 2MP with example.
Explain hierarchical model ofdambase with suitable example.
OR
Explain the following DNEL commands :
(i) SELECT
(ii) INSERT.
Explain BCNF with example.
What is PUSQL ? Explain its features in detail.
Explain the various types ofloins with example.
0R
Explain the block structure 0pr "SQL
W hat is transaction '? Explain Rollback and Commit with respect to ransaction.
Explain the following privileges :
(i) GRANT
(ii) REVOKE.
Explain the role ot'object privilege with example.
0R
Explain the concept of system and object privilege with example.
Explain role and needs ofsystem privilege on SQL reports.
Explain the procedure for installing PERL on system.
Discuss the bene?ts of PER; pro gramming in web?based applications.
OR
Discuss the various individual approaches related to programming in PERL.
Explain the working environment of PER L with example.
YBG?l 6928 7
O\O?O\C?
6
6
6
6
IE