Total No. of Questions : 8] SEAT No.

7
23
PD-4280 [Total No. of Pages : 2

ic-
tat
[6403]-77

7s
T.E. (Electronics / Electronics & Telecomunication Engineering)

8:2
02 91
DATA BASE MANAGEMENT

9:3
0
(2019 Pattern) (Semester - V) (304183)

50
9/0 13
0
Time : 2½ Hours] 5/2 [Max. Marks : 70
.23 GP

Instructions to the candidates :

1) Solve Q.1 or Q.2, Q.3 or Q.4, Q.5 or Q.6, Q.7 or Q.8.
E
71

7
2) Neat Diagram must be drawn wherever necessary.
C

23
ic-
3) Assume Suitable data if necessary.
16

tat
4) Figure to the right indicates full marks.
8.2

7s
.24

8:2
91
Q1) a) Explain the use of constraints in SQL. List and explain any three constraints
49

9:3
with example. [7]
30
50

b) What are different types of joins in SQL? Explain any one with suitable
01
02

example. [6]
5/2
GP

c) Explain with example any two STRING functions used in SQL. [5]
9/0

OR
CE
71

7
Q2) a) What are some common clauses used with SELECT query in SQL?

23
.23

Explain any two with example. [7]

ic-
16

b) What is Cursor? Explain Implicit and Explicit cursor in PL/SQL with

tat
8.2

suitable example. [6]

7s
.24

c) Explain the use of TRUNCATE, DELETE and DROP statements in SQL?

8:2
91

Explain any one with example. [5]

49

9:3
30
50

Q3) a) Explain briefly different states of transaction with a neat state transition
01
02

diagram. [6]
5/2
GP

b) Define transaction. State and explain in brief the ACID properties of a

9/0

transaction? [5]
CE
71

c) When deadlock occurs? How to prevent them? How to recover if dead

.23

lock occurs. [6]

16
8.2

P.T.O.
.24
49
 OR

7
23
Q4) a) Explain the term i) Conflict Serializability ii) View Serializability [6]

ic-
b) What is Concurrent execution of transaction? Explain any two concurrency

tat
problems occurs during Concurrent execution of transaction with

7s
examples? [5]

8:2
c) Explain Commit and Rollback operations of Transactions. [6]

02 91
9:3
Q5) a) What are performance parameters for parallel database? [6]

0
50
b) 9/0 13
Explain virtualization on Multicore processors with neat schematic
diagram. [6]
0
5/2
c) What is Parallelism? Explain Inter query parallelism. [6]
.23 GP

OR
E

Q6) a) List the parallel database architectures and explain any one
71

7
C

23
architecture. [6]

ic-
b) Explain Oracle Database Architecture. [6]
16

tat
c) Explain client server architecture with suitable example. [5]
8.2

7s
.24

8:2
Q7) a) Explain Homogeneous and Heterogeneous Distributed Databases. [6]
91
49

b) Explain Fragmentation and Replication in Distributed data storage. [6]

9:3
30

c) What is distributed transaction? Explain failure modes of distributed

50

transaction. [6]
01
02
5/2
GP

Q8) a) What is necessity of distributed database management system? What are

9/0

the Factors Encouraging DDBMS. [6]

CE

b) Explain two phase commit protocol in distributed database. [6]

71

7
23
c) Draw and explain client-server architecture for DDBMS. [6]
.23

ic-
16

tat
8.2

JJJ
7s
.24

8:2
91
49

9:3
30
50
01
02
5/2
GP
9/0
CE
71
.23
16
8.2
.24

[6403]-77 2
49
Total No. of Questions : 8] SEAT No. :

8
23
[Total No. of Pages : 2
PB-3816

ic-
[6262]-78

tat
8s
T.E. (Electronics/E&TC)

9:1
DATABASE MANAGEMENT

02 91
9:3
(2019 Pattern) (Semester - I) (304183)

0
40
Time : 2½ Hours]
2/0 13 [Max. Marks : 70
0
Instructions to the candidates:
5/2
.23 GP

1) Answer Q.1 or Q.2, Q.3 or Q.4, Q.5 or Q.6, Q.7 or Q.8 from following
questions.
E
82

8
2) Neat diagrams must be drawn wherever necessary.
C

23
3) Figures to the right indicate full marks.

ic-
4) Assume suitable data, if necessary.
16

tat
8.2

8s
Q1) a) Explain any three SQL data types with example. [6]
.24

9:1
91
b) Explain use of group by having clause and order by clause. [6]
49

9:3
30

c) Explain the any three aggregate functions in MYSQL with suitable

40

example. [6]
01
02
5/2

OR
GP
2/0

Q2) a) Explain any three string functions used in MYSQL with example.[6]
CE
82

8
b) Differentiate between Primary key and Foreign key. [6]

23
.23

ic-
c) Explain three types of outer join. [6]
16

tat
8.2

8s
.24

Q3) a) Explain two phase locking protocol with example. [6]

9:1
91
49

9:3

b) What are the ACID properties of the transaction? [6]

30
40

c) Explain the concept of serial schedule and serializable schedule. [5]

01
02

OR
5/2
GP

Q4) a) Explain when deadlock occurs and how to recover if dead lock takes
2/0

place. [6]
CE
82

b) Explain advantages of concurrent execution of transactions. [6]

.23

c) Explain the concept of recoverable and non recoverable schedules with

16

suitable example. [5]

8.2
.24

P.T.O
49
Q5) a) Explain client server architecture with suitable database application. [6]

8
23
b) Draw and explain memory structure of instance in Oracle architecture.

ic-
[6]

tat
8s
c) Draw and explain 3-tier web architecture. [6]

9:1
02 91
OR

9:3
0
40
Q6) a) Explain virtualization in multicore processor. [6]
2/0 13
b) Explain shared disk architecture with its advantages and disadvantages.
0
5/2
.23 GP

[6]
c) Explain the intra query parallelism query evaluation technique. [6]
E
82

8
C

23
ic-
16

Q7) a) Explain the types of distributed database system. [6]

tat
8.2

8s
b) Draw and explain client-server architecture for DDBMS. [6]
.24

9:1
91
c) Explain data fragmentation types in distributed database design (any two).
49

9:3
[5]
30
40

OR
01
02
5/2

Q8) a) Explain the advantages of distributed database management system?[6]

GP
2/0

b) What is distributed transaction? Explain the types of system failure modes

CE
82

8
(any two). [6]

23
.23

ic-
c) Explain two phase commit protocol in distributed database. [5]
16

tat
8.2

8s
.24

9:1


91
49

9:3
30
40
01
02
5/2
GP
2/0
CE
82
.23
16
8.2
.24
49

[6262]-78 2
Total No. of Questions : 8] SEAT No. :

8
23
P7576 [Total No. of Pages : 2

ic-
[6180]-91
T.E. (Electronics /E& TC)

tat
7s
DATABASE MANAGEMENT

5:4
(2019 Pattern) (Semester - I) (304183)

02 91
9:3
Time : 2½ Hours] [Max. Marks : 70

0
30
4/1 13
Instructions to the candidates:
1) Answer Q.1 or Q.2, Q.3 or Q.4, Q.5 or Q.6, Q.7 or Q.8. from following questions.
0
2) Neat diagram must be drawn wherever necessary.
2/2
.23 GP

3) Figures to the right indicate full marks.

4) Assume suitable data, if necessary.
E
80

8
Q1) a) Consider following schema: [6]
C

23
account (acct - no, branch - name, balance)

ic-
16

tat
Depositor (cust - name, acct - no)
8.2

7s
borrower (cust - name, loan - no)
.24

5:4
loan (loan - no, branch - name, amount)
91
49

9:3
Write following queries using SQL
30

i) Find names of all customers who have a loan at the Swargate branch
30
01

ii) Find all customers who are having an account and loan or both.
02
2/2

b) Explain the difference between SQL & PL/SQL. [6]

GP

c) Explain data types in SQL? [5]

4/1
CE

OR
80

8
23
Q2) a) Explain the following clause, [6]
.23

i) Where
ic-
16

tat
ii) Order By
8.2

7s

iii) Group By
.24

5:4

b) What is meant by Triggers in SQL? Explain with suitable example. [5]

91
49

9:3

c) Explain the basic constraints that can be spcified in SQL as part of table
30
30

creation with example. [6]

01
02
2/2

Q3) State and explain the ACID Properties. During its execution, a transaction
GP
4/1

passes through several states, untill it finally commits or aborts.

CE

a) List all possible sequenices of states through which a transaction may

80

pass. Explain the situations when each state transaction occurs. [6]
.23

b) Explain the concept of Serializability? Explain conflict serializability with

16

example. [6]
8.2
.24

P.T.O.
49

[6180]-91 1
 c) Consider the Transaction (T3), Transaction (T4) are any hypothetical

8
23
transactions working on data item Q. Schedule explaining the execution

ic-
of T3, T4 are given below. Decide whether following schedule is conflict

tat
serializable or not? Justify your answer: [6]

7s
T3 T4

5:4
Read (Q)

02 91
9:3
Write (Q) Write (Q)

0
OR

30
Q4) a) 4/1 13
What do you mean by isolation? Why it is important? Give an example.[6]
0
b) Explain the concept of concurrent execution? [6]
2/2
.23 GP

c) Explain commit and role back operation of transactions? [6]

E
80

8
C

Q5) a) Explain in detail Oracle Architecture. [6]

23
ic-
b) What are different parallel database architectures? Explain any two with
16

tat
their advantages & disadvantages? [6]
8.2

7s
c) Explain the terms speed-up and scale-up in parallel database? [5]
.24

5:4
91
49

OR
9:3
30

Q6) a) Write short note on:

30

i) Visulaization on multiore processors

01
02

ii) Evaluating parallel Query in Parallel Databases. [6]

2/2
GP

b) Explain concept of multi-user DBMS architecture. [6]

4/1

c) Why is a shared - nothing architecture attractive for parallel database

CE
80

8
systems? [5]

23
.23

ic-
16

Q7) a) What is difference between synchronous and asychronous replication?[6]

tat
8.2

b) Describe the phase commit (ZPC) protocal? Explain how (ZPC) protocol
7s

respond in different ways to different types of failures like site failure,

.24

5:4
91

coordinator failure, network partition? [6]

49

9:3

c) Explain Data Replication in Distributed Data Storage? [6]

30
30

OR
01
02
2/2
GP

Q8) a) Discuss in dtail about Single-Lock-Manager Approach and Distributed

4/1

Lock Manage in concurrency control? [6]

CE
80

b) What are the types of distributed databases? [6]

c) Explain Data Fragmentation in Distributed Data Storage? [6]
.23
16
8.2

  
.24
49

[6180]-91 2
Total No. of Questions : 8] SEAT No. :

8
23
P298 [Total No. of Pages : 2

ic-
[6003]-377

tat
T.E. (Electronics/E&T.C.)

2s
DATABASE MANAGEMENT

2:1
(2019 Pattern) (Semester - I) (304183)

02 91
0:3
Time : 2½ Hours] [Max. Marks : 70

0
31
0/0 13
Instructions to the candidates:
1) Answer Q.1 or Q.2, Q.3 or Q.4, Q.5 or Q.6, Q.7 or Q.8 from following questions.
0
2) Neat diagram must be drawn wherever necessary.
6/2
.23 GP

3) Figures to the right indicate full marks.

4) Assume suitable data, if necessary.
E
81

8
C

23
ic-
Q1) a) Explain with example: Aggregate functions, Builtin functions. [6]
16

tat
8.2

b) Describe role of Primary key, Foreign key, Uruque key. [6]

2s
.24

2:1
c) Explain any two transaction control commands. [6]
91
49

0:3
OR
30
31

Q2) a) Explain with example, sub-queries and correlated subqueries. [6]

01
02
6/2

b) Explain use of group by, having, order by, join and its types. [6]
GP
0/0

c) How stored procedures, stored functions, database triggers work in

CE
81

SQL, explain with example. [6]

8
23
.23

ic-
16

tat
Q3) a) What is database transaction management? List properties of transaction.
8.2

2s

[5]
.24

2:1
91

b) In database transaction management. What is the role of schedule? Explain

49

0:3

serial schedule in details. [6]

30
31

c) In serializability, explain conflict and view with example. [6]

01
02
6/2

OR
GP
0/0

Q4) a) Explain with example, recoverable and non recoverable schedules. [6]
CE
81

b) What is need of concurrency control in database management? Explain

.23

locking methods and deadlock handling. [6]

16

c) Explain need and role of Time-Stamp based protocols in database

8.2

management control. [5]

.24

P.T.O.
49

[6003]-377 1
Q5) a) Explain in detail an architecture of a parallel database. [5]

8
23
b) Explain multiuser DBMS architecture. [6]

ic-
tat
c) With schematic diagram, explain the architecture of Oracle Database.[6]

2s
OR

2:1
02 91
Q6) a) What are performance parameters in parallel database. [5]

0:3
0
31
b) Explain in detail, types of architectures of parallel databases. [6]
0/0 13
c) Explain virtualization in multicore processor. [6]
0
6/2
.23 GP
E

Q7) a) What is necessity of distributed database management system? What

81

8
C

23
are advantages of distributed database. [6]

ic-
16

b) What are types of distributed database? Explain with schematic diagram,

tat
8.2

architecture of distributed databases. [6]

2s
.24

2:1
c) With suitable example, explain design of distributed database. [6]
91
49

0:3
OR
30
31

Q8) a) Explain how data is stored in distributed database. [6]

01
02
6/2

b) What is distributed transaction? Explain failure modes of distributed

GP

transaction. [6]
0/0
CE
81

c) Explain in short: Comment protocols and concurrency control in

8
23
distributed database. [6]
.23

ic-
16

tat
8.2

2s
.24

2:1

  
91
49

0:3
30
31
01
02
6/2
GP
0/0
CE
81
.23
16
8.2
.24
49

[6003]-377 2
Total No. of Questions : 8] SEAT No. :

8
23
PA-1486 [Total No. of Pages : 3

ic-
[5926]-105

tat
T.E. (Electronics / E & TC)

0s
DATABASE MANAGEMENT

6:0
02 91
(2019 Pattern) (Semester - I) (304183)

3:4
0
31
Time : 2½ Hours] [Max. Marks : 70
6/0 13
Instructions to the candidates:
0
1) Attempt Q.1 or Q.2, Q.3 or Q.4, Q.5 or Q.6, and Q.7 or Q.8.
1/2
.23 GP

2) Figures to the right indicate full marks.

3) Assume suitable data, if necessary.
E
81

8
C

23
ic-
Q1) a) Consider the following database:
16

tat
Student (Roll_no; Name, motrine_no; Address)
8.2

0s
Subject (Sub_Code, Sub_name)
.24

6:0
Marks ( Roll_no; Sub_code, marks)
91
49

3:4
Write following queries in SQL. [6]
30
31

i) Average marks of each student along with Roll_no. of student.

01
02

ii) Find how many students have failed in the subject “DBM”.
1/2
GP

b) Write the syntax for following SQL commands. [5]

6/0

i) Create Table
CE
81

8
ii) Alter Table

23
.23

iii) Drop Table

ic-
16

iv) DELETE
tat
8.2

0s

v) UPDATE
.24

6:0

c) Explain following terms with examples. [6]

91
49

3:4

i) Procedure
30

ii) Function
31
01

OR
02
1/2

Q2) a) With the help of block diagram, describe PL/SQL block structure. [5]
GP
6/0

b) What are the different types of joins in SQL? Explain any one join with
CE

example. [6]
81

c) Explain the following operations with suitable queries. [6]

.23

i) Set operations (any two)

16

ii) Aggregate functions (any two)

8.2
.24

P.T.O.
49

[5926]-105 1
Q3) a) Explain commit and Roll back operations of transaction. [6]

8
23
b) Explain how beadlock occurs? Which are the actions required for the

ic-
deadlock recovery process? [6]

tat
0s
c) Define the following terms. [5]

6:0
i) Concurrency

02 91
3:4
ii) Timestamp

0
31
iii) 6/0 13
Timestamp ordering
0
iv) Schedule
1/2
.23 GP

v) Transaction
E
81

8
OR
C

23
ic-
Q4) a) What are ACID properties of a transaction? [6]
16

tat
b) Identify the following schedule is view serializable or not. Justify your
8.2

0s
answer. [5]
.24

6:0
91
T1 T2 T3
49

3:4
30

R(X)
31
01

W(X)
02
1/2

W(Z)
GP
6/0

W(Y)
CE
81

8
23
W(X)
.23

W(X) ic-
16

tat
8.2

c) Explain the transaction states with state diagram. [6]

0s
.24

6:0
91
49

3:4

Q5) a) Explain client server architecture with suitable database application. [6]
30
31

b) Draw two tier architecture and describe its advantages. [6]

01
02

c) Draw and explain memony structure of instance in oracle architecture.[6]

1/2
GP

OR
6/0
CE

Q6) a) Describe speed up attribute in parallel database architecture. [6]

81
.23

b) List the parallel database architectures and explain shaved disk

architecutre. [6]
16
8.2

c) Explain the intra query parallelism query evaluation technique. [6]

.24
49

[5926]-105 2
Q7) a) List and explain advantages and disadvantages of distributed databases.[6]

8
23
b) Compare homogeneous and heterogeneous distributed database. [6]

ic-
tat
c) Draw and explain client-server architecutre for DDBMS. [6]

0s
OR

6:0
02 91
Q8) a) Write the types of data fragmentation and explain horizontal fragmentation

3:4
with one example. [6]

0
31
b)
6/0 13
Explain the distributed database system failure modes (any two). [6]
0
1/2
.23 GP

c) Explain two phase commit protocol in distributed database. [6]

E
81

8
C

23


ic-
16

tat
8.2

0s
.24

6:0
91
49

3:4
30
31
01
02
1/2
GP
6/0
CE
81

8
23
.23

ic-
16

tat
8.2

0s
.24

6:0
91
49

3:4
30
31
01
02
1/2
GP
6/0
CE
81
.23
16
8.2
.24
49

[5926]-105 3