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

FirstRanker.com

A Firstranker's choice

B.Sc. (Part—IIT) Semester—VI Examination

--- Content provided by FirstRanker.com ---

BIOINFORMATICS

(Advanced Bio-Computing)

Time : Three Hours] [Maximum Marks : 80

Note :— (1) All questions are compulsory.

(2) Draw diagrams wherever necessary.

--- Content provided by‌ FirstRanker.com ---

1. (a) Fill in the blanks :
   1. The row of a relation is called a ___________. 2
   2. BCNF stands for ___________. 2
   3. When a function calls itself again and again, it is called ___________. 2
   4. To modify the structure of an existing table __________ statement is used. 2

--- Content provided by‍ FirstRanker.com ---

2. (b) Choose the correct alternative :
   1. Which datatype is not allowed in the definition of PL/SQL record ?
      1. (a) collection
      2. (b) scalar
      3. (c) Both (a) and (b)
      4. (d) None of the above

   --- Content provided by‍ FirstRanker.com ---

   2. Which operator performs pattern matching ?
      1. (a) BETWEEN
      2. (b) LIKE
      3. (c) EXISTS
      4. (d) None of the above

   --- Content provided by⁠ FirstRanker.com ---

   3. Which member can never be accessed by inherited classes ?
      1. (a) Private
      2. (b) Public
      3. (c) Protected
      4. (d) All can be accessed

   --- Content provided by​ FirstRanker.com ---

   4. Which function is used by PERL for displaying the length of a string ?
      1. (a) String
      2. (b) Len
      3. (c) Split
      4. (d) Length

   --- Content provided by​ FirstRanker.com ---

   2
3. (c) Define the following :
   1. Class
   2. Constructor
   3. Encapsulation
   4. Joins. 4

   --- Content provided by‍ FirstRanker.com ---

2. (a) What is OOPS ? Explain its features. 6
3. (b) Explain the structure of C++ with example. 6

   OR

3. (a) Explain inline function with suitable example. 6

--- Content provided by‌ FirstRanker.com ---

4. (b) Explain the various datatypes in C++. 6

4. (a) Explain the following terms :
   1. Data abstraction
   2. Encapsulation. 6
5. (b) Explain the concept of constructor with suitable example. 6

   OR

   --- Content provided by⁠ FirstRanker.com ---

5. (a) What is operator overloading ? Explain. 6
6. (b) Define inheritance and explain its types with example. 6

6. (a) What is normalisation ? Explain 1NF and 2NF with example. 6
7. (b) Explain hierarchical model of database with suitable example. 6

   OR

   --- Content provided by‌ FirstRanker.com ---

7. (a) Explain the following DML commands :
   1. SELECT
   2. INSERT. 6
8. (b) Explain BCNF with example. 6

--- Content provided by‌ FirstRanker.com ---

8. (a) What is PL/SQL ? Explain its features in detail. 6
9. (b) Explain the various types of Joins with example. 6

   OR

9. (a) Explain the block structure of PL/SQL. 6
10. (b) What is transaction ? Explain Rollback and Commit with respect to transaction. 6

--- Content provided by⁠ FirstRanker.com ---

10. (a) Explain the following privileges
    1. GRANT
    2. REVOKE. 6
11. (b) Explain the role of object privilege with example. 6

    OR

--- Content provided by‌ FirstRanker.com ---

11. (a) Explain the concept of system and object privilege with example. 6
12. (b) Explain role and needs of system privilege on SQL reports. 6

12. (a) Explain the procedure for installing PERL on system. 6
13. (b) Discuss the benefits of PERL programming in web-based applications. 6

    OR

--- Content provided by FirstRanker.com ---

13. (a) Discuss the various individual approaches related to programming in PERL. 6
14. (b) Explain the working environment of PERL with example. 6

FirstRanker.com