Advanced Database Management System — Winter 2020

oQ.5. 2. Make Suitable assumptions wherever necessary. 3. Figures to the right indicate full marks. 4. Use of programmable & Communication aids are strictly prohibited. 5. Use of only simple calculator is permitted in Mathematics. 6. English version is authentic.

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

Explain types of LOCK. પરશન. ર (અ) Types of LOCK સમજાવો.

Explain commit, rollback and savepoint commands. (અ) commit, rollback and savepoint commands સમજાવો.

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

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

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

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

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

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

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

Explain variables in PL/SQL. (અ) variables in PL/SQL સમજાવો.

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

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

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

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

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

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

Explain Functional Dependency and fully Functional Dependency with example. (અ) Functional Dependency and fully Functional Dependency ઉદાહરણ આપી સમજાવો.

What is decomposition? Explain non loss decomposition. (બ) Decomposition શ છ? non loss decomposition સમજાવો..

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

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

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

Explain Transaction Log in detail . (બ) Transaction Log ઊડાણથી સમજાવો.

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

Explain structure of package. (ડ) structure of package સમજાવો. 3/3