BSc CS Sem 3 BSc CS Semester 3 (2014 2015) 2015 Comp III Question Paper - Mumbai University | munotes

Questions asked in this paper

• ii) Figures to the right indicate full marks

1. Q1 Attempt any Four. 20 marks
   • a) What are the disadvantages of file management system?
   • b) Explain Normalization with 3NF and BCNF
   • c) What do you mean by a Weak entity set?
   • d) Explain the terms
   • i) Entity Set i
   • iii) Attributes
   • e) Explain cardinality constraint
   • f) Write a short note on — Generalization
   • g) What do you mean by DBMS? What are its applications? What do you mean by total participation and partial participation?
2. Q2 Attempt any Four. 20 marks
   • a) Explain select and projection operators
   • b) Explain DDL statements used in SQL? Give example of each What do you mean by constraints? What are different types of constraints used in
   • d) Explain domain relational calculus
   • e)- What do you mean by correlated subquery? Explain with example
   • f) What do you mean by join? Explain Right join and Full Outer Join with suitable example
   • g) Explain any five string functions used in SQL
   • h) Consider following tables of book whose order is placed having the author ‘Henry Korth’ and
   • ii) Find out minimum of ordered quantity, maximum of ordered quantity, total number of orders placed by each distributor
   • iii) Write a query to display number of books from each category
3. Q3 Attempt any Four. 20 marks
   • a) Create a stored procedure to calculate factorial of a given number. Write PL/SQL block to execute the same
   • b) Explain the types of indexes with suitable example
   • c) Differentiate between a table and a view
   • d) Explain Row Level trigger with appropriate example
   • e) Write a short note on — Hash index: What is a view? Explain the syntax of creating and altering a view. Also give example
   • g) What are the advantages and disadvantages of stored procedure?
   • h) Write a short note on — Heap File
4. Q4 Attempt any three. 15 marks
   • a) Explain all three levels of abstraction
   • b) Write a short note on — Aggregation
   • c)Explain the following operation with appropriate examples:
   • i) SELECT INTO
5. Q11 UNION
   • d) Explain following clauses with suitable example:
   • i) HAVING clause ORDER BY clause ili) GROUP BY clause
   • e) Explain Tree index with example
   • f) What do you mean by a trigger? Explain statement level trigger with suitable example

Read from the scan above, so a character or two may differ. The scan is the original.