M.Sc. DEGREE EXAMINATION, APRIL 2016
Second Semester
Bioinformatics
Lab III MYSQL AND PERL PROGRAMMING
(2013 onwards)
Time 3 Hours Maximum 75 Marks
Part A (10 2 20)
Answer all questions.
All questions carry equal marks.
1. What are the technical features of MySQL?
2. What are the different tables present in MySQL?
3. Define SQL Index?
4. Write the purpose MySQL operators?
5. What is Hash function?
6. Define Variable
7. What is subroutines?
8. Define Bioperl?
9. What is CGI interface?
10. What is Data Definition Language?
Sub. Code
502205
RW-10868
2
Ws15
Part B 5 25)
Answer all questions.
All questions carry equal marks.
11. Write about Data Definition Language statements.
Or
Explain basic commands to create, modify and
delete the table.
12. How to join a multiple tables by using SQL join?
Or
Write about Data Manipulation statements?
13. Write short notes on String and Aggregate
functions.
Or
Write notes on Lists and Arrays.
14. Discuss the features of subroutines in Perl.
Or
State the features of DBM Databases and DBM
Hashes.
15. Write any one simple CGI program.
Or
Write short notes on Split and Joint functions.
RW-10868
3
Ws15
Part C 10 30)
Answer any three of the following.
16. Explain the Control structures with suitable examples?
17. Discuss DBM database? Write about opening and closing
DBM Hashes?
18. Briefly explain the MySQL operators with suitable
examples.
19. Explain regular expressions with suitable examples and
also write the use of regular expression?
20. Define Bioperl? Write about installation procedures and
uses of Bioperl.