Answer any seven out of ten. દશમ ાથી કોઇપણ સ તન જવ બ આપો. 1. Explain COMMIT and ROLLBACK COMMAND. ૧. COMMIT and ROLLBACK COMMAND સમજાવો. 2. Explain UNIQUE index with example. ૨. UNIQUE index ઉદ હરણ આપી સમજાવો. 3. What is deadlock? ૩. Deadlock શ ાછ? 4. What is stored function? ૪. Stored function શ ાછ? 5. What is user defined exception? Why it is used? ૫. User defined exception શ ાછ? ત કમ વપર ય છ? 6. Explain GOTO statement with example. ૬. GOTO statement ઉદ હરણ આપી સમજાવો. 7. What is functional dependency? Give an example. ૭. Functional dependency શ ાછ? ઉદ હરણ આપો. 8. Trivial v/s nontrivial dependencies. ૮. Trivial v/s nontrivial dependencies. 9. List out problems of concurrency control. ૯. Concurrency control ન problems લખો. 10. Give advantages of PL/SQL block. ૧૦. PL/SQL blocks ન ફ યદ આપો.
Give the difference between sorting and indexing. (બ) sorting and indexing વચચનો તફ વત આપો.
[3 marks]1/3
[ marks]Explain GRANT, REVOKE and SAVEPOINT with example. પરશન. ર (અ) GRANT, REVOKE and SAVEPOINT ઉદ હરણ આપી સમજાવો.
[3 marks]What is view? Write advantages of view. Which are the restrictions on view. (બ) View શ ાછ? View ન ફ ય દ લખો. View પરન restrictions કય છ?
[3 marks]What is Sequence? How can we create sequence? Explain with example. (ક) Sequence શ ાછ? Sequence કવી રીત create કર ય? ઉદ હરણ આપી સમજાવો.
[4 marks]What is synonym? How can we create synonym? (ક) Synonym શ ાછ? Synonym કવી રીત create કર ય?
[4 marks]What is ROWID? Explain in detail with example. (ડ) ROWID શ ાછ? ઉદ હરણ આપી વવસત રથી સમજાવો.
[4 marks]What is LOCK? Explain types of LOCK. (અ) LOCK શ ાછ? જ દ જ દ પરક રન LOCK સમજાવો.
[3 marks]How can we create and destroy view? Explain types of view. (ડ) View ન create and destroy કવી રીત કર ય? જ દ જ દ પરક રન view સમજાવો.
[4 marks]Explain exceptional handling with example. (બ) Exceptional handling ઉદ હરણ આપી સમજાવો.
[3 marks]Differentiate : SQL vs PL/SQL પરશન. 3 (અ) તફ વત આપો : SQL vs PL/SQL
[3 marks]Explain WHILE loop with example. (અ) WHILE loop ઉદ હરણ આપી સમજાવો.
[3 marks]Explain attributes of implicit cursor. (બ) Implicit cursor ન attributes સમજાવો.
[3 marks]Write short note on packages. (ક) ટ ાકનોધ લખો: packages
[4 marks]Explain types of trigger with example. (ક) જ દ જ દ પરક રન trigger ઉદ હરણ આપી સમજાવો.
[4 marks]Write short note on stored procedure. (ડ) ટ ાકનોધ લખો: stored procedure
[4 marks]Explain deadlock detection and prevention. પરશન. ૪ (અ) Deadlock detection and prevention સમજાવો.
[3 marks]Write short note on Two phase locking. (અ) ટ ાકનોધ લખો: Two phase locking
[3 marks]Explain closures of a set of functional dependencies. (બ) Closures of a set of functional dependencies સમજાવો.
[4 marks]Explain Armstrong’s Axioms for Functional dependencies. (બ) Armstrong’s Axioms fro Functional dependencies સમજાવો.
[4 marks]What is Normalization? Explain 1NF and 2 NF with example. (ક) Normalization શ ાછ? 1NF and 2 NF ઉદ હરણ આપી સમજાવો. 2/3
[7 marks]Explain Lossy and Nonloss decomposition with example. પરશન. ૫ (અ) Lossy and Nonloss decomposition ઉદ હરણ આપી સમજાવો.
[4 marks]Explain ACID properties of transaction. (બ) ACID properties of transaction સમજાવો.
[4 marks]Explain 3 NF with example. (ક) 3 NF ઉદ હરણ આપી સમજાવો.
[3 marks]Differentiate procedure and function. (ડ) Procedure and function વચચ નો તફ વત આપો. 3/3
[3 marks]What is trigger? How can we create a trigger? Explain with example. (ડ) Trigger શ ાછ? Trigger કવી રીત create થ ય? ઉદ હરણ આપી સમજાવો.
