M.Sc. DEGREE EXAMINATION, APRIL 2017
Second Semester
Bioinformatics
Lab III MYSQL AND PERL PROGRAMMING
(2016 onwards)
Time 3 Hours Maximum 75 Marks
Part A (10 x 2 20)
Answer all questions.
1. Give any two reasons for the popularity of MySQL.
2. How can you drop a database using MySQL admin?
3. What is the use of like clause?
4. What do you mean by unique index?
5. What are the ways available to start Perl?
6. What is the use of unless statement?
7. How can you delete an existing file?
8. What is conditional operator?
9. Give the syntax for getc function.
10. Give any two uses of Bioperl.
Sub. Code
502205
RW-192
2
Ws7
Part B 5 25)
Answer all questions.
11. How can you create a database?
Or
Describe the SELECT query with an example.
12. Describe the logical operators.
Or
How can you use MySQL LEFT JOIN?
13. Write the features of Perl.
Or
What are Hash variables?
14. How can you open and close a file?
Or
Write the procedure to create object.
15. Create a table for PROTEIN details and store five
records in that file.
Or
Write a CGI Perl program to perform the
translation process for user given sequence.
RW-192
3
Ws7
Part C 10 30)
Answer any three questions.
16. How can you modify and delete a table? Give an example.
17. Describe the aggregate functions available in MySQL.
18. Explain the split and join functions with examples.
19. Explain the fixed length random access databases and
variable length databases with suitable examples.
20. Write a program to translate a RNA sequence to protein
sequence using Hash.
———————