Scribd
Upload
46 views3 pages

Viva Questions DBMS

The document contains a comprehensive list of viva voce questions related to Database Management Systems (DBMS), covering fundamental concepts such as definitions of databases, types of keys, normalization forms, SQL features, and transaction properties. It also addresses advantages and disadvantages of DBMS, data integrity, and various operations in relational algebra. This resource serves as a study guide for understanding key DBMS principles and practices.

Uploaded by

AD PLAYZ
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
46 views3 pages

Viva Questions DBMS

The document contains a comprehensive list of viva voce questions related to Database Management Systems (DBMS), covering fundamental concepts such as definitions of databases, types of keys, normalization forms, SQL features, and transaction properties. It also addresses advantages and disadvantages of DBMS, data integrity, and various operations in relational algebra. This resource serves as a study guide for understanding key DBMS principles and practices.

Uploaded by

AD PLAYZ
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

VIVA VOCE QUESTIONS (DBMS)

1. What is a database?

2. Whatis DBMS?

3. Give an example for an RDBMS.

4. List the benefits of DBMS.

5. Disadvantage in File Processing System

6. What is a key? what are different keysin database?

7. What is a primary key?

8. What is a secondary key?

9. What is a candidate key?

10. What is an alternate key?

11. What is a super key?

12. What is a composite key?

13. What is a relation?

14. What is a table?

15. What is an attribute?

16. What is a domain?

17. What is a tuple?

18. What is a selection?

19. what is a join operation?

20. What are base operations in relational algebra?

21. What are different DBMS facilities? How many types of facilities are provided by a DBMS?

22. What is Data Definition Language?

23. What is Data Dictionary?

24. What is a DML?

25. What is a query?

26. What is a query language?

27. What are the advantages of DBMS?

28. What is a SQL?

29. What are the features of SQL?

30. How SQL organizesthe data?

31. What is data definition?


32. Whatis data retrieval?

33. What is data sharing?

34. What is a view?

35. What is normalization?

36. What is a first normal form?

37. What is a second normal form?

38. Whatis a third normal form?

39. Whatis BCNF?

40. What isfifth normal form?

41. What is Functional Dependency?

42. What is Losslessjoin property?

43. What are the commands to delete, modify and insert a record in the table?

44. What is time stamping?

45. Whatis data base schema?

46. What is a self join?

DBMS LAB MANUAL Page 61

47. What are the different aggregate functionsin SQL?

48. Whatis data integrity?

49. What is data independence?

50. What is dead locking?

51. What is decryption?

52. What is a distributed database?

53. What is an entity?

54. What is a conceptual data model?

55. Whatistwo phase locking?

56. What is projection?

57. What are the different phases of transaction?

58. What is Relational Algebra?

59. What is Relational Calculus

60. What is normalization?

61. What is Functional Dependency?

62. What is 1 NF (Normal Form)?


63. What is Fully Functional dependency?

64. What is 2NF?

65. What is 3NF?

66. What is BCNF (Boyce-Codd Normal Form)?

67. What is a transaction?

68. List the ACID properties?

69. What is Atomicity?

70. What is Consistency?

71. What is Isolation?

72. What is Durability?

73. When two operations in a Schedule Rollbacks?

74. Define recoverable schedule.

You might also like