Q2. Explain TCL commands. પરશન. ર (અ) TCL commands સમજાવો.

This is question 2 (3 marks) from the GTU Advanced Database Management System DI Winter 2023 question paper. Subject code: 3340701.

Q2. Explain DCL commands. (અ) DCL commands સમજાવો.

This is question 2 (3 marks) from the GTU Advanced Database Management System DI Winter 2023 question paper. Subject code: 3340701.

Q2. Explain levels of locks. (બ) levels of locks સમજાવો.

This is question 2 (3 marks) from the GTU Advanced Database Management System DI Winter 2023 question paper. Subject code: 3340701.

This is question 2 (null marks) from the GTU Advanced Database Management System DI Winter 2023 question paper. Subject code: 3340701.

Advanced Database Management System | Diploma Semester 4 Winter 2023 | GTU Papers

Q: Q1. Answer any seven out of ten. દશમ ાથી કોઇપણ સ તન જવ બ આપો. 1. Explain shared અન exclusive lock. ૧. shared and exclusive lock સમજાવો 2. Explain GRANT AND REVOKE command. ૨. GRANT AND REVOKE command સમજાવો 3. What is numbered exception? ૩. numbered exception શ ાછ? 4. What is package? ૪. package શ ા છ? 5. Differentiate before and after trigger. ૫. before and after trigger વચચનો તફ વત સમજાવો. 6. What is cursor? ૬. cursor શ ા છ? 7. What is fully functional dependency? ૭. fully functional dependency શ ાછ? 8. Explain levels of Normalization. ૮. Normalization ન levels સમજાવો. 9. What is transaction? ૯. transaction શ ાછ? 10. What is trivial and non trivial dependency? ૧૦. trivial અન non trivial dependency શ ાછ?

This is question 1 (14 marks) from the GTU Advanced Database Management System DI Winter 2023 question paper. Subject code: 3340701.

Q: Q2. Explain types of Indexes. (ડ) જ દ જ દ પરક રની Indexes સમજાવો.

This is question 2 (4 marks) from the GTU Advanced Database Management System DI Winter 2023 question paper. Subject code: 3340701.

Q: Q2. What is view? Explain view with example. (ક) View શ ા છ? View ઉદ હરણ આપી સમજાવો.

This is question 2 (4 marks) from the GTU Advanced Database Management System DI Winter 2023 question paper. Subject code: 3340701.

Q: Q2. What is Index? Explain Index with example. (ડ) Index શ ા છ? Index ઉદ હરણ આપી સમજાવો.

This is question 2 (4 marks) from the GTU Advanced Database Management System DI Winter 2023 question paper. Subject code: 3340701.

Q: Q2. Create a sequence and explain all its parameters. (ક) Sequence Create કરો અન તન બધ parameters સમજાવો.

This is question 2 (4 marks) from the GTU Advanced Database Management System DI Winter 2023 question paper. Subject code: 3340701.

Questions26

Q114 marks

Answer any seven out of ten. દશમ ાથી કોઇપણ સ તન જવ બ આપો. 1. Explain shared અન exclusive lock. ૧. shared and exclusive lock સમજાવો 2. Explain GRANT AND REVOKE command. ૨. GRANT AND REVOKE command સમજાવો 3. What is numbered exception? ૩. numbered exception શ ાછ? 4. What is package? ૪. package શ ા છ? 5. Differentiate before and after trigger. ૫. before and after trigger વચચનો તફ વત સમજાવો. 6. What is cursor? ૬. cursor શ ા છ? 7. What is fully functional dependency? ૭. fully functional dependency શ ાછ? 8. Explain levels of Normalization. ૮. Normalization ન levels સમજાવો. 9. What is transaction? ૯. transaction શ ાછ? 10. What is trivial and non trivial dependency? ૧૦. trivial અન non trivial dependency શ ાછ?

Explain types of Indexes. (ડ) જ દ જ દ પરક રની Indexes સમજાવો.

[4 marks]

Explain TCL commands. પરશન. ર (અ) TCL commands સમજાવો.

[3 marks]

Explain DCL commands. (અ) DCL commands સમજાવો.

[3 marks]

Explain levels of locks. (બ) levels of locks સમજાવો.

[3 marks]

1/3

[ marks]

Explain Synonym with example. (બ) Synonym ઉદ હરણ આપી સમજાવો.

[3 marks]

What is view? Explain view with example. (ક) View શ ા છ? View ઉદ હરણ આપી સમજાવો.

[4 marks]

What is Index? Explain Index with example. (ડ) Index શ ા છ? Index ઉદ હરણ આપી સમજાવો.

[4 marks]

Create a sequence and explain all its parameters. (ક) Sequence Create કરો અન તન બધ parameters સમજાવો.

[4 marks]

Explain different attributes of cursor with example. (ક) Different attributes of cursor ઉદ હરણ આપી સમજાવો.

[4 marks]

What is trigger? Explain advantages of using trigger. Give the difference between trigger and procedure. (ડ) Trigger શ ા છ? Trigger ન ફ યદ સમજાવો. Trigger અન procedure વચચ નો તફ વત સમજાવો.

[4 marks]

Explain generic PL/SQL block. પરશન. 3 (અ) generic PL/SQL block સમજાવો.

[3 marks]

Give advantages of PL/SQL. (અ) PL/SQL ન advantages આપો.

[3 marks]

Explain if else ladder in PL/SQL. (બ) PL/SQL મ ા if else ladder સમજાવો.

[3 marks]

Explain FOR loop in PL/SQL. (બ) PL/SQL મ ા FOR loop સમજાવો. (c ) Explain cursor for LOOP with example. (ક) cursor for LOOP ઉદ હરણ આપી સમજાવો.

[4 marks]

Explain different types of Exceptions. (ડ) જ દ જ દ પરક રન Exceptions સમજાવો.

[4 marks]

Explain dependency Preserving decomposition. (બ) dependency Preserving decomposition સમજાવો.

[4 marks]

Explain 2NF and 3NF with example. (ક) 2NF and 3NF ઉદ હરણ આપી સમજાવો.

[7 marks]

What is normalization? Explain 1NF with example. પરશન. ૪ (અ) normalization શ ા છ? 1NF ઉદ હરણ આપી સમજાવો.

[3 marks]

What is functional dependency ?Explain Armstrong’s Axioms for Functional Dependencies. (અ) functional dependency શ ા છ? Armstrong’s Axioms for Functional Dependencies સમજાવો.

[3 marks]

Explain Functional Dependency Diagram. 2/3 (બ) Functional Dependency Diagram સમજાવો.

[4 marks]

Explain Two – Phase locking protocol. (બ) Two – Phase locking protocol સમજાવો.

[4 marks]

Explain ACID property of transaction. (ડ) ACID property of transaction સમજાવો. 3/3

[3 marks]

Explain procedure and functions in PL/SQL. પરશન. ૫ (અ) Procedure and Functions in PL/SQL સમજાવો.

[4 marks]

Explain time stamp method of concurrency control. (ક) time stamp method of concurrency control સમજાવો.

[3 marks]

Advanced Database Management System — Winter 2023

Questions26

Related Papers