BSc Data Science SEM II 2021 2022 May 2022 DS DATABASE MANAGEMENT Question Paper - Mumbai University | munotes

Questions asked in this paper

• 2) Figures to the right indicate marks

1. Q3 Mixing of sub-questions is not allowed
2. Q4 Assume suitable data if necessary and state it clearly
3. Q1 Attempt All. 40 marks
   • a) Multiple Choice Questions Either all actions of a transaction are carried out or none are referring to the property
   • a) Atomicity b) Isolation
   • c) Consistency d) Durability
4. Q2 is a type of data abstraction that is used to provide conceptual representation
   • a) Metadata b) Query
5. Q3 To make the changes permanent, a has to be given at the SQL
   • c) Rollback d) Commit
6. Q4 Foreign key isthe one in which of one relation is referenced in another relation whose effect on any consistent database instance is guaranteed to be identical to that of serial schedule
7. Q6 The effect of a Transaction should persist even if the system crashes before all its changes are reflected on disk. This property refers to
   • a) Atomicity b) Isolation
   • c) d) Durability
8. Q7 Oval shape used to represent in ER Diagram
   • a) Entity b) Data
   • c) Attribute d) Name
9. Q8 clause is used with aggregate functions to retrieve data category wise
   • a) Having b) Order by
   • c) Group by d) Where
10. Q9 Entity types that do not have key attributes of their own is
    • a) Strong b) Weak
    • b) Binary d) Prime consists of atomic values and no repeating group is the process of defining a set of subclasses of an entity type
    • a) Generalization b) Aggregation
    • c) Specialization d) Abstraction
11. Q12 Third Normal Form (3 NF) is based on the concept of represents association among two or more entities
    • a) Entity b) Relationship
    • c) Attribute d) Metadata
12. Q14 A database language used for defining the database structure and schema is called
    • a) DCL b) DTL
    • c) DML d) DDL i5. ail rows from the right table and matching rows from the left table or null if no matching rows found in the left table
13. Q16 SELECT stud_name FROM Student WHERE class_name LIKE * Data Science’: In above query, which of the following can be placed in the query’s blank portion to select “class name” that also contains “Data Science” as its ending string? isa virtual table created by a query by joining one or more tables
    • c) View d) Procedure
14. Q18 function search and replace a substring in a string
    • a) b) PLACE
    • c) REPLACE d) RTRIM Which SQL functic n is used to count the number of rows in a SQL Query?
    • a) COUNT () b) COUNT (*)
    • c) SUM () d) COUNTROWS () function is used to retrieve next value in a sequence
15. Q2 Attempt the following
    • A) Solve any ONE. 4
16. Q1 What are the advantages of DBMS over File System?
17. Q2 Explain the degrees of Data Abstraction
    • B) Solve any ONE. 3
18. Q1 Entity, Derived attribute and Simple attribute
19. Q2 Explain Ternary Relationship with suitable example
20. Q3 Attempt the following
    • A) Solve any ONE. 4
21. Q1 Write a short note on Specialization
22. Q2 What is Primary Key Constraint and Foreign Key Constraint?
    • B) Solve any ONE. {93 Marks]
23. Q1 Explain subclass and superclass with respect to EER
24. Q2 What is Normalization? Explain Second Normal Form
25. Q4 Attempt the following
    • A) Solve any ONE. 4
26. Q1 Consider following tables Solve following queries —
    • i) Find out how many students located in each city? li) Display the names of the students whose marks are in the range of 75 to 90
    • iii) Display the details of students enrolled in the class
27. Q2 Explain any four Aggregate Functions used in MySQL
    • B) Solve any ONE. ) Explain ORDER BY clause with suitable example 3
28. Q2 What do you mean by subquery? Explain with example
29. Q5 Attempt the following
    • A) Solve any ONE. 4
30. Q1 What are views? How to create it?
31. Q2 Briefly explain Database Life Cycle
    • B) Solve any ONE. ) Explain any 3 DDL command used in MySQL with proper syntax 3
32. Q2 What do you mean by Sequence? Explain the syntax of sequence creation
33. Q6 Attempt the following
    • A) Solve any ONE. ) Explain Deadlock detection mechanism 4
34. Q2 Explain Two Phase Locking protocol
    • B) Solve any ONE. ) What is an Index? Explain its syntax and give suitable example 3
35. Q2 Explain ACID properties of transaction

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