Answer any seven out of ten. દશમ થા ી કોઇપણ સ તન જવ બ આપો. 1. What is the purpose of transaction log. ૧. transaction log નો ઉપયોગ શ છ? 2. What is dependency preserving decomposition? ૨. dependency preserving decomposition શ છ? 3. Draw state transition diagram of transaction. ૩. Transaction નો state transition diagram દોરો. 4. Explain If else statement in PL/SQL. ૪. PL/SQL મ ાIf else statement સમજાવો. 5. Differentiate shared lock and exclusive lock. ૫. shared lock અન exclusive lock નો તફ વત આપો. 6. What is deadlock? ૬. Deadlock શ છ? 7. What is normalization? Which are the advantages of normalization? ૭. Normalization શ છ? Normalization ન ફ યદ ઓ કય છ? 8. Explain package. ૮. Package સમજાવો. 9. Explain FOR loop. ૯. FOR loop સમજાવો. 10. Explain GOTO statement ૧૦. GOTO statement સમજાવો.
Explain two-phase locking protocol. પરશન. ર (અ) two-phase locking protocol સમજાવો.
[3 marks]03 Explain time-stamp method of concurrency control. (અ) time-stamp method of concurrency control સમજાવો.
[3 marks]Explain closures of a set of functional dependency. (બ) closures of a set of functional dependency સમજાવો.
[3 marks]Define and explain with example: FFD, trivial FD, non-trivial FD 1/3 (બ) વય ખય આપો અન ઉદ હરણ આપી સમજાવો: FFD, trivial FD, non-trivial FD
[3 marks]What is Functional dependency? Explain FD diagram with example. (ક) Functional dependency શ છ? FD diagram ઉદ હરણ આપી સમજાવો.
[4 marks]Explain Armstrong’s Axioms for functional dependency. (ક) Armstrong’s Axioms for functional dependency સમજાવો.
[4 marks]What is transaction? Explain ACID property of transaction. (ડ) Transaction શ છ? ACID property of transaction સમજાવો.
[4 marks]Write down three problems of concurrency control. Explain any one of them in detail. (ડ) concurrency control ન તરણ problems લખો. તમ થા ી કોઇ એક ઊડ ણથી સમજાવો.
[4 marks]Write short note on synonym. પરશન. 3 (અ) ટ ાકનોધ લખો: synonym ૦
[3 marks]Explain DCL commands. (અ) DCL commands સમજાવો.
[3 marks]What is sequence? How can we create a sequence? (બ) Sequence શ છ? Sequence કવ ી રીત create કરી શક ય.
[3 marks]Explain transaction control commands. (બ) transaction control commands સમજાવો.
[3 marks]Explain different levels of lock. (ક) different levels of lock સમજાવો.
[4 marks]Explain Explicit locking in detail. (ક) Explicit locking ઊડ ણથી સમજાવો.
[4 marks]What is Index? Explain different types of index with example. (ડ) Index શ છ? જદ જદ પરક રની Index ઉદ હરણ આપી સમજાવો.
[4 marks]Explain lossy and non-loss decomposition with example. પરશન. ૪ (અ) lossy અન non-loss decomposition ઉદ હરણ આપી સમજાવો.
[3 marks]Explain 1NF with example. (અ) 1NF ઉદ હરણ આપી સમજાવો.
[3 marks]What is trigger? How can we create a trigger ? Explain with example. (બ) Trigger શ છ? Trigger કવ ી રીત create કરી શક ય? ઉદ હરણ આપી સમજાવો.
[4 marks]Explain different types of triggers with example. (બ) જદ જદ પરક રની triggers ઉદ હરણ આપી સમજાવો.
[4 marks]Explain 2NF and 3NF with example. (ક) 2NF અન 3NF ઉદ હરણ આપી સમજાવો. 2/3
[7 marks]Explain PL/SQL block structure. પરશન. ૫ (અ) PL/SQL block structure સમજાવો.
[4 marks]Explain cursor attributes with example. (બ) cursor attributes ઉદ હરણ આપી સમજાવો.
[4 marks]Explain user defined exception handling with example. (ક) user defined exception handling ઉદ હરણ આપી સમજાવો.
[3 marks]Explain WHILE loop with syntax and example. (ડ) WHILE loop syntax અન ઉદ હરણ આપી સમજાવો. 3/3
[3 marks]What is view? How can we create a view? Which are the advantages of view. (ડ) View શ છ? View કવ ી રીત create કરી શક ય? View ન ફ યદ ઓ કય છ?