Exam Details
| Subject | database management system – ii (paper – ii) | |
| Paper | ||
| Exam / Course | b.sc. – i (ecs) | |
| Department | ||
| Organization | solapur university | |
| Position | ||
| Exam Date | October, 2018 | |
| City, State | maharashtra, solapur |
Question Paper
B.Sc. (Part III) (Entire Computer Science) (Semester VI) (CGPA)
Examination, 2018
DATABASE MANAGEMENT SYSTEM II (Paper ii)
Day and Date Tuesday, 30-10-2018 Total. Marks 70
Time 10.30 a.m. to 1.00 p.m.
Instructions All questions are compulsory.
Figures to the right indicate full marks.
1. Choose an correct alternatives 14
A transaction must be
Atomic Small
Large All of these
A list of actions from a set of transactions is known as
Statement Schedule
Transaction set None of these
Timestamp has a property of
Monotonicity Irreducibility
Atomicity None of these
When transaction never progresses then we say that it is
Aborted Starved
Shared Locked
The blocks residing on the disk are called as
Physical blocks Buffer blocks
Disk buffer None of these
Shadow paging is used for
Creating shadow
Writing same item it different location
Writing same item at same location
None of these
The point of synchronization between the database and the transaction log
file is called as
Checkpoint Fuzzy checkpoint
UNDO and REDO None of these
Two actions on same data object are conflict if one of them is
a
Read Write
Read/Write None of these
A phase during which all locks are requested is known as
Growing phase Shrinking phase
Aborted phase None of these
10) The major factor for concurrency control is
Locking Time stamping
Granularity None of these
11) The process of restoring the database to a correct state in the event of a
failure is known as
Database recovery Database modification
Reliability of database None of these
12) A sequence of log record is called as a
File Database
Log file None of these
13) Triggers are supported in
Delete Update
Views All of these
14) Shadow paging was introduced by
Boehm E. F. Codd
Lorie None of these
2. Solve any seven of the following 14
What is %type and %row type in PL/SQL
What are the states of transaction
Define upgrade and downgrade.
Define cascading rollback.
What is meant by log-based recovery
What is deadlock
What is trigger
Write a syntax of stored procedure.
List data types in PL/SQL.
3. Attempt any two of the following 10
Explain locking techniques for concurrency control.
What is shadow paging scheme Where it is used
Write structure of PL/SQL block.
What is transaction What are its ACID properties 4
4. Attempt any two of the following 14
Explain two phase locking protocol with an example.
Write a PL/SQL function for reverse number.
Explain Recovery schemas in detail.
5. Attempt any two of the following 14
What is serializability Explain conflict and view serializable schedule.
Explain timestamp ordering protocol.
What is cursor Explain with an example.
Examination, 2018
DATABASE MANAGEMENT SYSTEM II (Paper ii)
Day and Date Tuesday, 30-10-2018 Total. Marks 70
Time 10.30 a.m. to 1.00 p.m.
Instructions All questions are compulsory.
Figures to the right indicate full marks.
1. Choose an correct alternatives 14
A transaction must be
Atomic Small
Large All of these
A list of actions from a set of transactions is known as
Statement Schedule
Transaction set None of these
Timestamp has a property of
Monotonicity Irreducibility
Atomicity None of these
When transaction never progresses then we say that it is
Aborted Starved
Shared Locked
The blocks residing on the disk are called as
Physical blocks Buffer blocks
Disk buffer None of these
Shadow paging is used for
Creating shadow
Writing same item it different location
Writing same item at same location
None of these
The point of synchronization between the database and the transaction log
file is called as
Checkpoint Fuzzy checkpoint
UNDO and REDO None of these
Two actions on same data object are conflict if one of them is
a
Read Write
Read/Write None of these
A phase during which all locks are requested is known as
Growing phase Shrinking phase
Aborted phase None of these
10) The major factor for concurrency control is
Locking Time stamping
Granularity None of these
11) The process of restoring the database to a correct state in the event of a
failure is known as
Database recovery Database modification
Reliability of database None of these
12) A sequence of log record is called as a
File Database
Log file None of these
13) Triggers are supported in
Delete Update
Views All of these
14) Shadow paging was introduced by
Boehm E. F. Codd
Lorie None of these
2. Solve any seven of the following 14
What is %type and %row type in PL/SQL
What are the states of transaction
Define upgrade and downgrade.
Define cascading rollback.
What is meant by log-based recovery
What is deadlock
What is trigger
Write a syntax of stored procedure.
List data types in PL/SQL.
3. Attempt any two of the following 10
Explain locking techniques for concurrency control.
What is shadow paging scheme Where it is used
Write structure of PL/SQL block.
What is transaction What are its ACID properties 4
4. Attempt any two of the following 14
Explain two phase locking protocol with an example.
Write a PL/SQL function for reverse number.
Explain Recovery schemas in detail.
5. Attempt any two of the following 14
What is serializability Explain conflict and view serializable schedule.
Explain timestamp ordering protocol.
What is cursor Explain with an example.
Other Question Papers
Subjects
- advanced java (paper – iii)
- advanced microprocessor
- compiler construction (paper – iv)
- computer graphics
- core java (old cgpa) (paper – iii)
- data communication and networking – i
- data communication and networking – ii (paper – i)
- data communications and networking – i (paper – i)
- data structures (paper – iv)
- data structures algorithms enginering – ii
- database management system – i (paper – ii)
- database management system – ii (paper – ii)
- dbms using oracle
- descriptive statistics – i
- descriptive statistics – ii
- digital electronics – i
- digital electronics and microprocesor – ii
- discrete structure
- embedded system – i
- embedded system – ii (paper – v)
- english (compulsory) (new) (cbcs)
- fundamental of computer
- golden petals
- introduction to programming using c – ii (paper – iii)
- introduction to web designing (paper – ii)
- linear electronics – i
- linear electronics – ii
- linux operating system (new)
- literary quest
- mathematical algebra
- mathematics(numerical methods)
- microprocesor – ii
- object oriented programming using c++
- object oriented programming using java (paper – i)
- on track – english skills for success
- oop using c++ – ii
- operating system
- operating system – ii (paper – i)
- operations research
- organization of pc – ii
- peripherals and interfacing – ii
- pr obabili ty theory – ii
- probability theory – i (paper – ix)
- programming using “c”
- python – i (paper – v)
- software engineering
- software enginering – ii
- theory of computer science
- theory of computer science (paper – iv)
- visual programming – i
- visual programming and aplication software – i (old)
- visual programming and aplication software – ii(paper – vi)
- web technology and e-commerce – i
- web technology and e-commerce – i (paper – v)
- web technology and e-commerce – ii (paper – v)