22521 - -Sample-question-paper Advanced Database Management System I Scheme 5th Semester Computer MSBTE Sample Paper
Scheme- I
Sample Question Paper
Program Name :
Computer Engineering Program Group
Program
Code : CO/CM/CW
Semester : Fifth
Course Title
|
: Advanced Database
Management System
|
||
Marks
|
: 70
|
Time: 3 Hrs.
|
Q1)
Attempt any FIVE of the following. 10
Marks
a) State
the use of concurrency control (any two)
b) Enlist
any four types of join
c) Write
any four benefits of NoSQL
d) Enlist
any four application of Data Mining
e) Define
Big Data.
f) Give
any four characteristics of XML
g) State
the use of Single Purpose Aggregation(any two)
Q2)
Attempt any THREE of the following. 12
Marks
a) Explain
Client Server database model with diagram
b) Compare
between Structured and Unstructured data(any four)
c) explain
With example any four operation with MongoDB
d) Explain
structured types and inheritance in SQL.
Q3)
Attempt any THREE of the following. 12
Marks
a) Compare
between OLTP vs OLAP
b) Compare
SQL and NoSQL database system(any four points)
c) Explain
steps used to perform data analysis in R programming
d) Draw
and explain Data Warehousing Lifecycle
Q4)Attempt
any THREE of the following. 12
Marks
a) Compare
between parallel and Distributed database (any four points)
b) List
and explain any four basic datatype of MongoDB
c)
Describe data synchronization in mobile
database.
d) Explain
Oracle Cloud technology.
e) Describe
the features of BI components
Q5)
Attempt any TWO of the following. 12
Marks
a) Write
query to execute find() function on Collection: Inventory
i) To display all documents in the collection ii) To
display all documents where the status equals "D" iii) To display all
documents where status equals either "A"or "D": iv) To
display all documents where the status equals "A" and qty is less than 30: v) To display
all documents where the status equals "A" or qty is less than 30: vi) To display all documents where the status equals "A" and either
qty is less than 30 or item starts with the character p:
b) Explain
array and multiset types in sql with example
c) Explain
object and object identity. Write SQL query for the following table
Class: student
|
Name
Age
GPA
Subject
Gender
|
Store Print
Update
|
Q6)
Attempt any TWO of the following. 12
Marks
a) Define
lock. Explain two phase locking protocol with example
b) Consider
the tables given below:
Employees(employee_id,first_name,last_name,job_id,salary,department_d)
Departments(department_id,department_name,location_id)
i) Find
all employees who locate in the location with the id 1700
ii) Finds
all employees who salaries are greater than the average salary of all employees
c) Consider
following input data for your Map Reduce Program
Welcome to Hadoop Class
Hadoop is good
Hadoop is bad
Comments
Post a Comment
If you have any query, please let us know