BSc CS Sem 3 ATKT 2016-17 ATKT COMPUTER III Question Paper - Mumbai University | munotes

Questions asked in this paper

1. Q1 Write a short note on ~ Generalization What do you mean by DBMS? What are its
   • h) What do you mean by total participation and partial
2. Q2 Attempt any 120]
   • a) Explain select and projection operators
   • b) Explain DDL statements used in SQL? Give-example of each What ‘mean by constraints? What are different types of constraints used in SOL?
   • d) Explain domain relational calculus,
   • e) What do you mean by correlated subquery? Explain with example What do you mean by join? Explain Right and Full Outer Join with suitable example ‘g) Fxplain any five string functions used in SQL
   • h) Consider following tables the details of book whose order is placed having 7 nd out minimum of ordered quantity, maximum Orders Placed by each distributor. ony Write a query to display number of books from each ca y Four. ber, Write PL/SQL block to ‘Teale a stored procedure to calculate factorial of a given Xplain the types of indexes with suitable example Differentiate between a table and a view
   • d) Explain Row Level trigger with appropriate example Write a short note on - Hash index What is a view? Explain the syntax of creating and altering a view. Also give St ij example of each
   • g) What are the advantages and disadvantages of stored procedure? i Write a short note on - Heap File
3. Q4 Attempt any-three. 15 marks
   • a) Explain all three levels of abstraction
   • b) Write a short note on
   • c)Explain the following operation with appropriate examples:
   • d) Explain following clauses with suitable example:
   • i) HAVING clause
   • ii) ORDER BY clause ‘iii) 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.