TY.BSc - Computer Science (PL/SQL) Sem 5- 6 Question Paper 2016-17

Question bank PIV ( PL/SQL) -2016/17

SEM 5

Unit 1

1. What are ACID properties? Define all the four characteristics and explain how they
are different from each other
2. Why do two actions on the same data object conflict? define dirty read,unrepeatable reads
3. Describe WR,WW and RW conflicts.
4. What is multivalued and join dependency? In which normalization forms they occur?
5. explain how multivalued dependency is different from join dependency along with their occurrence in respective normal forms
6. what are the characteristics of lossless join decomposition?
7. Explain the any 5 Armstrong's Axioms for reasoning about FDs
8. The problem will be given and find which Armstrong axioms will be applied here...
9.Define these terms: atomicity, consistency, isolation, durability, schedule, blind
write, dirty read, unrepeatable read, serializable schedule, recoverable schedule,
avoids-cascading-aborts schedule.

Unit 2

1. what are thr two types of locks? how to give the queries for the same
2. Explain the phases occuring in Two Phase Locking Protocol
3. What is Thomas Write Rule?
4. explain the terms optimistic concurrency control, pessimistic concurrency control
5. what are the two phases which we have come across in 2PC?
6. What are the three types of operations which occur in 2PC?
7. What do you mean by the growing phase and the shrinking phase in context with locks?
8. Explain ARIES algorithm.
9. Describe No-Force Steal Approach
10. Explain the concept behind the Trail or Journal.
11.what are the contents of log record? what is the need of keeping log?
12. what is CLR? explain in brief
13. Elaborate on the concept of checkpointing.

Unit 3

1. explain the different types of datatypes in Pl/SQL by giving brief example.
2. Pl/SQL block
3. write down the role of exit statement in loops.
4. what is the idea behind using nested tables?
5. Pl/SQL block
6.how is if then...elsif...else stmt is different case stmt
7. Pl/sql block
8. write down the use of loop.. end loop ? where and how is it used? give an example
9. what is role of null values in sql and pl/sql? how such values are handled

Unit 4

1. what is metadata? what metadata is stored in the system catalog?
2. what are the three techniques are commonly used in algo to evaluate relational operators?
3. what is the goal of query optimization? what is the need of finding the best plan?
4. what is a query evaluation plan for given relational algebric expression
5. describe the relational operators used as three common techniques?
6.what are the cursor attributes? list all and explain any2
7 discuss why cursor %ISOPEN and CLOSE not used in implicit cursors?
8. what is the diff. in implicit and explicit cursor? explain syntax too
9 write down the use of loop.. end loop ? where and how is it used? give an example
10. what is the use of cursor for loop?
11. what is the diff and similaritiesexpalo in cursor for and for loop?
12. what are parameterized cursors? explain syntax with an example
13. What is the difference in implicit and explicit cursor? give an example
14. Elaborate the use of Commit, Rollback and savepoint in SQL queries.


--------------------------------------------------------------------------------------------------------------
                                                                       
 SEM 6


Unit I

1. State the properties of decomposition. Explain any one in detail.
2. Explain dependencies occur in Fourth and fifth normal form.
3. What is closure set of functional dependencies?
4. Explain Conflict Serializability and View Serializability
5. What is transaction? Which are the functions of Commit and Rollback?
6. What do you understand by Concurrency control? Explain various Concurrency problems with the help of an example.
7. With respect to schedule define: Conflict equivalent and Conflict serializable.
8. Explain ACID properties of transaction.

Unit II

1. Write short note on :Time stamp ordering protocol
2. What is Two phase locking?
3. Explain Thomas Write Role.
4. What is Lock Manager? How granting and rejection of locks works?
5. Explain ARIES algorithm.
6. What is Checkpoint? How Checkpointing works in ARIES algorithm.
7. Describe Shadow Paging Recovery Technique.
8. Differentiate between : a) Rollforward Vs Rollback b) System Crash and Media Failure

Unit III

1. Explain Decision making statements with the help of an example.
2. Explain the concept of NULL values.
3. Explain how data conversion is done in PL/SQL
4. How Date data type is use in PL/SQL explain with the help of an example.
5. Write short note on : Nested Relations
6. How CASE statement works is explain with the example.
7. Write a PL/SQL Block to assign the salary increment of given employee based on his hire date.

Unit IV

1. How Sequence is created and modified.
2. Write short note on : a) Nested loop join b) Merge join
3. What is Query Optimization? Discuss it’s approaches.
4. What is Explicit cursor explain with the help of an example.
5. Explain Cursor variables in detail.
6. What is Locking? Explain Locking parameters.
7. Write short note on : Explicit Locking
8. Discuss ACID properties of transaction





Post a Comment

0 Comments