0 votes
117 views
in DataBase Management System by
edited
DataBase Management System viva question

1 Answer

0 votes
by (98.9k points)
selected by
 
Best answer
  • What are the characteristics of databases?
  • What is the difference between a file system and a database system?
  • What is data abstraction and data independence?
  • What is DBMS system architecture?
  • What is a Database Administrator?
  • What is the Entity-Relationship (ER) Model?
  • What are the different types of entity sets?
  • What are the different types of attributes?
  • What are the different types of keys?
  • What are the different types of relationship constraints?
  • What is the Extended Entity-Relationship (EER) Model?
  • What is Generalization in the EER Model?
  • What is Specialization in the EER Model?
  • What is Aggregation in the EER Model?
  • What is the Relational Model?
  • What is a relational schema?
  • What is the concept of keys in the Relational Model?
  • How is the ER and EER Model mapped to the Relational Model?
  • What are the different operators in Relational Algebra?
  • What are Relational Algebra queries?
  • What is SQL?
  • What are Data Definition Commands in SQL?
  • What are Integrity constraints in SQL?
  • What are Data Manipulation commands in SQL?
  • What are Data Control commands in SQL?
  • What are Set and string operations in SQL?
  • What are aggregate function-group by, having in SQL?
  • What are Views in SQL?
  • What are joins in SQL?
  • What are Nested and complex queries in SQL?
  • What are Triggers in SQL?
  • What are the pitfalls in Relational-Database designs?
  • What is the concept of normalization?
  • What are Function Dependencies?
  • What is First Normal Form?
  • What is Second Normal Form?
  • What is Third Normal Form?
  • What is Boyce-Codd Normal Form?
  • What is the Transaction concept?
  • What are Transaction states?
  • What are the ACID properties?
  • What are Transaction Control Commands?
  • What are Concurrent Executions?
  • What is Serializability?
  • What is Conflict and View in Serializability?
  • What are Lock-based protocols in Concurrency Control?
  • What are Timestamp-based protocols in Concurrency Control?
  • What is the Recovery System?
  • What is Log-based recovery?
  • What is Deadlock handling?

Related questions

0 votes
1 answer 99 views
0 votes
2 answers 133 views
0 votes
1 answer 113 views

Doubtly is an online community for engineering students, offering:

  • Free viva questions PDFs
  • Previous year question papers (PYQs)
  • Academic doubt solutions
  • Expert-guided solutions

Get the pro version for free by logging in!

5.7k questions

5.1k answers

108 comments

561 users

...