BSc CS Sem 1 BSc CS Semester 1 (2018 2019) Dec 2019 DATABASE SYSTEMS Question Paper - Mumbai University | munotes

Questions asked in this paper

• 2) Figures to the right indicate marks

1. Q3 Illustrations, in-depth answers and diagrams will be appreciated
2. Q4 Mixing of sub-questions is not allowed
3. Q5 Assume suitable data if necessary and state it clearly
4. Q1 Attempt All. (15M)
   • (a) Multiple Choice Questions 1)The level of data abstraction which describes how the data is actually stored
   • A) conceptual level
   • B) physical level
   • C) file level
   • D) none of these
5. Q2 IS Called as top-down approach
   • A) Generalization
   • B) Specialization
   • C) Aggregation
   • D) Synthesization
6. Q3 Which of the following is the syntax for views where v is view name ?
   • A)Create view v as “query name”;
   • B) Create “query expression” as view;
   • C) Create view v as “query expression”;
7. Q4 A record in the table is also knows as
   • A) column
   • C) Field
   • D) data 18 used to find absolute value of a number
   • A) ABSOLUTE
   • C) CEIL
   • D) FLOOR
   • (b)Fill in the blanks. [use following answer pool to fill the correct answer.]
8. Q1 Database Architecture
9. Q2 Primary key should be
10. Q3 A transactions completes its execution is
11. Q4 one of the string handling function in mysql
12. Q5 ALTER command is
    • (c) Answer in one line
    • a) Define DBMS
    • b) Write syntax for updating a row in a table
    • c) Write syntax of projection operator in Relational Algebra
    • d) Define subquery
    • e) Give one example of derived attribute
13. Q2 Attempt the following(Any THREE) [15 M]
    • a) What are the disadvantages of file processing system?
    • b) Explain Relational model
    • c) What do you mean by Binary Relationship and Ternary Relationship? Explain with suitable
    • d) Write a note on Specialization
    • e) Define following terms:
    • i) Value Set
    • v) Entity Type
    • f) Construct an ER Diagram for Airline Reservation System [Assume suitable data and mapping cardinalities exists.] Attempt the following(Any THREE) [15 M]
    • a) Explain following operations of Relational Algebra with algebraic query example
14. Q1 Projection
    • ii) Join
    • b) What do you mean by Functional Dependency?
    • c) How do you Backup and Restore Database in MySQL?
    • d) Explain Group BY and Having Clause of MySQL with suitable query example
    • e) Explain all Aggregate Functions used in MySQL
    • f) Perform following using
15. Q1 Create a table Supplier(suppno,sname,city) with suitable data types “Suppno” columns is primary Key
16. Q11 Insert 2 records
    • iii) Delete a record who lives in city starts with letter ‘M’
17. Q4 Attempt the following(Any THREE) [15 M]
    • a) What security mechanism is used to secure database?
    • b) What do you mean by Join? Explain Left outer join and Right outer join with suitable query
    • c) What are the different threats to the databases?
    • d) What do you mean by privileges with respect to databases? How to grant and revoke
    • e) Write short note on correlated subqueries. Give example of it
    • f) Consider following tables Solve following queries and trace the output —
18. Q1 Find out the name of customer who has placed the orders it) Create a view showing the details of customer living in same city How many orders placed by each customer? (Solve with subquery) Attempt the following (Any THREE) [15 M]
    • a) Explain architecture of DBMS
    • c) What is the use of keyword ‘Distinct’ and ‘all’ in MySQL? Explain with query example
    • d) How to create and drop a user in MySQL?
    • e) What do you mean by views? What are its types?

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