Answer any seven out of ten. દશમ ાથી કોઇપણ સ તન જવ બ આપો. 1. Explain commit and savepoint. ૧. commit અન savepoint સમજાવો. 2. Explain shared and exclusive lock. ૨. shared અન exclusive lock સમજાવો. 3. How can we delete sequence? ૩. Sequence delete કવી રીત કરી શક ય? 4. What is numbered exception? ૪. numbered exception શ ાછ? 5. Differentiate Implicit and Explicit cursor. ૫. Implicit અન Explicit cursor નો તફ વત આપો. 6. Differentiate Procedures and Functions. ૬. Procedures અન Functions નો તફ વત આપો. 7. What is fully functional dependency? ૭. fully functional dependency શ ાછ? 8. Explain levels of Normalization. ૮. Normalization ન levels સમજાવો. 9. What is concurrency control? ૯. concurrency control શ ાછ? 10. What is trivial and non trivial dependency? ૧૦. trivial અન non trivial dependency શ ાછ?
Explain TCL commands. પરશન. ર (અ) TCL commands સમજાવો.
[3 marks]Explain DCL commands. (અ) DCL commands સમજાવો.
[3 marks]Explain Implicit locks. (બ) Implicit locks સમજાવો.
[3 marks]Explain Explicit locks. 1/3 (બ) Explicit locks સમજાવો.
[3 marks]What is view? Explain types of views. How can we create view? (ક) View શ ાછ? types of views સમજાવો. View create કવી રીત કરી શક ય?
[4 marks]Explain types of Indexes. How can we create an Index? (ક) types of Indexes સમજાવો. Index create કવી રીત કરી શક ય?
[4 marks]How can we use sequence? How can we delete a sequence? (ડ) Sequence કવી રીત ઉપયોગ મ ાલવ ય? Sequence delete કવી રીત કરી શક ય?
[4 marks]Create a sequence and explain all its parameters. (ડ) Sequence Create કરો અન તન બધ parameters સમજાવો.
[4 marks]Explain user defined Exceptions. (ડ) user defined Exceptions સમજાવો.
[4 marks]Give advantages of PL/SQL. પરશન. 3 (અ) PL/SQL ન advantages આપો.
[3 marks]Explain generic PL/SQL block. (અ) generic PL/SQL block સમજાવો.
[3 marks]How can we display message and write comment in PL/SQL block. (બ) PL/SQL block મ ાmessage display અન comment કવી રીત લખ ય?
[3 marks]Explain conditional control in PL/SQL. (બ) PL/SQL મ ાconditional control સમજાવો. (c ) Explain steps required to manage explicit cursor and manipulate data. (ક) to manage explicit cursor and manipulate data મ ટ ન જરરી પગથીય સમજાવો.
[4 marks]Explain cursor for LOOP with example. (ક) cursor for LOOP ઉદ હરણ આપી સમજાવો.
[4 marks]Explain types of triggers. (ડ) types of triggers સમજાવો.
[4 marks]Explain 2NF and 3NF (ક) 2NF and 3NF સમજાવો. 2/3
[7 marks]Explain 1NF પરશન. ૪ (અ) 1NF સમજાવો.
[3 marks]Explain Armstrong’s Axioms for Functional Dependencies. (અ) Armstrong’s Axioms for Functional Dependencies સમજાવો.
[3 marks]Explain dependency Preserving decomposition. (બ) dependency Preserving decomposition સમજાવો.
[4 marks]Explain Functional Dependency Diagram. (બ) Functional Dependency Diagram સમજાવો.
[4 marks]Explain structure of package in PL/SQL. પરશન. ૫ (અ) structure of package in PL/SQL સમજાવો.
[4 marks]Explain ACID property of transaction. (બ) ACID property of transaction સમજાવો.
[4 marks]Explain Two – Phase locking protocol. (ક) Two – Phase locking protocol સમજાવો.
[3 marks]How can we create and destroy trigger? (ડ) create અન destroy trigger કવી રીત કરી શક ય? 3/3
[3 marks]