BSc CS Sem 3 BSc CS Semester 3 (2019 2020) Oct 2020 DATABASE MANAGEMENT SYSTEMS Question Paper - Mumbai University | munotes

Questions asked in this paper

• (2) Figures to the right indicate marks

1. Q1 Attempt All (Each of 5 Marks) LA
   • (A) Multiple choice questions
2. Q1 Which of the following is true to create an index in your own schema’?
   • A. The table or cluster to be indexed is in another schema
   • B. You don’t have INDEX privilege on the table to be indexed
   • C. Youhave CREATE ANY INDEX system privilege
   • D. None of the above
3. Q2 PL/SQL is a procedural language that has the advantages
   • C. Application written in PL/SQL is fully portable
   • D. All of the above
4. Q3 A transaction that it completes its execution successfully is said to be
   • A. Rollback
   • C. Aborted
   • A. Identifiers
   • C. Delimiters
   • D. Lexical Units
5. Q5 In Aries algorithm log records contain
   • A. Old Value
   • C. Both A and B
   • D. Error value
   • (B). in the Blanks (GOTO, concurrency control, afier, drop index, rollback) , --------trigger is executes the trigger action the triggering statement is executed
6. Q2 The--------- statement changes the flow of control within PL/SQL block
7. Q3 To drop an index we
8. Q4 The technique employed by the Oracle engine to protect table data when people are accessing it is ca!led
9. Q5 In ease of any shut down during before commit -------- statement is done
   • (C). Answer in 1 —2 sentences What is a procedure?
10. Q2 What is the use of Exit statement? \ 3, Define rollback statement
11. Q4 State down types of file organization
12. Q5 When does deadlock happen?
13. Q2 Attempt any three of the following (Attempt Any Three):
    • a) Explain the benefits of Stored Procedure
    • b) What do you mean by trigger? How trigger enforcing data integrity”? Write a note on cluster index
    • d) Create a trigger to insert the name of the student in UPPERCASE in the table student (rno, name)
    • e) What is mean by file organization? Explain heap file organization
    • f) How to alter and drop a sequence?
14. Q3 the following (Any Three): 15 marks
    • a) Explain in brief the benefits of PL/SQL
    • b) What are the data types supported by PL/SQL?
    • c) Write a CASE statement with suitable example
    • d) Explain GOTO and NULL statement with an example
    • e) Write a PL/SQL block to calculate area of circle till radius greater than 10. Insert the radius and area in an empty table rame aoc(racius, area)
    • f) Explain IF-THEN-ELSE statement in with example
15. Q4 Attempt the fellowing (Any Three): 15 marks
    • a) Explain Two Phase Commit Protocol
    • b) Describe ACID Properties for transaction,
    • c) Explain Write-ahead log protocol
    • d) Write a note on Conflict Serializability
    • e) Explain deadlock prevention scheme
    • f) Write a note on Redo phase 5, Attempt the following (Any Three): i
    • a) Explain hash base index
    • b) Write a note on for loop statement
    • c) What is concurrent execution? Explain advantages of it
    • d) Explain the use of % type and % type row attribute in Oracle with suitable example
    • e) How to create and execute stored procedure?

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