This download link is referred from the post: SGBAU BSc Last 10 Years 2010-2020 Question Papers || Sant Gadge Baba Amravati university
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 ---
- (a) Fill in the blanks :
- The row of a relation is called a ___________. 2
- BCNF stands for ___________. 2
- When a function calls itself again and again, it is called ___________. 2
- To modify the structure of an existing table __________ statement is used. 2
- (b) Choose the correct alternative :
- Which datatype is not allowed in the definition of PL/SQL record ?
- (a) collection
- (b) scalar
- (c) Both (a) and (b)
- (d) None of the above
- Which operator performs pattern matching ?
- (a) BETWEEN
- (b) LIKE
- (c) EXISTS
- (d) None of the above
- Which member can never be accessed by inherited classes ?
- (a) Private
- (b) Public
- (c) Protected
- (d) All can be accessed
- Which function is used by PERL for displaying the length of a string ?
- (a) String
- (b) Len
- (c) Split
- (d) Length
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
- Which datatype is not allowed in the definition of PL/SQL record ?
- (c) Define the following :
- Class
- Constructor
- Encapsulation
- Joins. 4
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
- (a) What is OOPS ? Explain its features. 6
- (b) Explain the structure of C++ with example. 6
OR
- (a) Explain inline function with suitable example. 6
- (b) Explain the various datatypes in C++. 6
--- Content provided by FirstRanker.com ---
- (a) Explain the following terms :
- Data abstraction
- Encapsulation. 6
- (b) Explain the concept of constructor with suitable example. 6
OR
--- Content provided by FirstRanker.com ---
- (a) What is operator overloading ? Explain. 6
- (b) Define inheritance and explain its types with example. 6
- (a) What is normalisation ? Explain 1NF and 2NF with example. 6
- (b) Explain hierarchical model of database with suitable example. 6
OR
--- Content provided by FirstRanker.com ---
- (a) Explain the following DML commands :
- SELECT
- INSERT. 6
- (b) Explain BCNF with example. 6
--- Content provided by FirstRanker.com ---
- (a) What is PL/SQL ? Explain its features in detail. 6
- (b) Explain the various types of Joins with example. 6
OR
- (a) Explain the block structure of PL/SQL. 6
- (b) What is transaction ? Explain Rollback and Commit with respect to transaction. 6
--- Content provided by FirstRanker.com ---
- (a) Explain the following privileges
- GRANT
- REVOKE. 6
- (b) Explain the role of object privilege with example. 6
OR
--- Content provided by FirstRanker.com ---
- (a) Explain the concept of system and object privilege with example. 6
- (b) Explain role and needs of system privilege on SQL reports. 6
- (a) Explain the procedure for installing PERL on system. 6
- (b) Discuss the benefits of PERL programming in web-based applications. 6
OR
--- Content provided by FirstRanker.com ---
- (a) Discuss the various individual approaches related to programming in PERL. 6
- (b) Explain the working environment of PERL with example. 6
--- Content provided by FirstRanker.com ---
This download link is referred from the post: SGBAU BSc Last 10 Years 2010-2020 Question Papers || Sant Gadge Baba Amravati university