Model question of Paper: DSE3T (BCA)
Paper Name: Advance DBMS
(2 mark question)
1.What is data integrity?
2. What is acid property?
3. Explain the concept of data security?
4. What do you mean by the term aggregation?
5. Explain the concept of dependency preservation?
6. What is the purpose of concurrency control?
7. What is data redundancy?
8. What is foreign key?
9. Write down the similarities of candidate and primary key?
10. What is atomicity?
11. What is DKNF?
12. What do you mean by structure that analysis?
13.what do you mean by the term specialisation?
14.what is the transaction?
15.What is distributed database?
16. Write down the difference between higher secure and network database?
17. What do you mean by no-sql database?
18. What is DBA?
19. Write down the short note of access control in database security?
20. What is the encryption database security?
( 5 .no mark question )
1.Difference between rollback and commit?[5]
2.Difference among DDL,DML,DCL?[5]
3.Difference between DBMS and RDBMS?[5]
4.Describe the ACID property?[5]
5.What is normalization?why 4NF preferable to BCNF.[2+3]
6.the difference types of decomposition.
Given relation R(A,B,C,D) and FD is {A->B,A->C,C->D} R is decomposed in two tables one is
R1(A,B,C) and R2(C,D).check whether this decomposition is loss or lossy.[2+3]
7.Describe the binary relationship?what is mapping?[4+1]
8.Describe the transaction processing.[5]
9.Write down the problem with concurrent execution.[5]
10.What is lock base protocol? Define primary key,foreign key, composite key with example [2+3
11. write down the advantage and disadvantage of redundant data? what is time stamp protocol?(4+1)
12. Explain multivalued dependency with example?what is deadlock?(3+2)
13. Write down the short note- serialzability,recoverability
14. What is data integrity? Describe the difference type of integrity constant?(2+3)
15. What are assertions?How to create assertion statement?(2+3)
16. 16.Explain the following terms in the context of DBMS:
a .Checkpoint
b. Embedded SQL [2½+2½]
17. What is object oriented database and why it is important? [2+3]
18. How dml has been effected by data analysis? Define DML. [3+2]
19. Briefly describe the database sequrity?[5]
20. Explain about livelock with example. Define DKNF. [4+1]
21. Difference between centralized database vs distributed database? What is interference control? [3+2]
(10 no. Mark question )
1.(a) Discuss about Lossless Losy decomposition and explain with example.
(b)How DML work on DBMS? 6+4
2.(a) Explain multivalued dependency with example.
(b) Write a Shont on note on:
(i)Serializability
(ii)Recoverability. 5+5
3. What do you mean by Normalzation? Explain varius types of Normalization with
example. 2+8
4.Explain primary key, candidate key,super key, foreign key with example.Difference between delete and
truncate command. 7+3
5. what is transaction Processing? Explain briefly various types of transaction processing.3+7
6. Explain concurrency control? write down the problem with concurrent execution.3+7
7. Write down the advantage and disadvantage of distributed data base management system? Explain
about 4Nf with example.5+5
8. Explain ACID property. What is the purpose of two phase locking protocol?5+5
9.Explin the object oriented database and why is it important?What is a view in SQL and why it is
used? 5+5
10.Define specialization and aggregation with the help of an example and explain its purpose.Difference
between temporal database vs regular database.
5+5
