DBMS FINAL VIVA

What does DBMS stand for?

• Database Machine System

• Database Management System

• Database Maintenance System

• Database Modeling System

Which is a key advantage of DBMS?

• Data redundancy is increased

• Provides multiple user interfaces

• Data access becomes difficult

• Provides unauthorized access

Which one is not a disadvantage of the File Processing System?

• Data redundancy

• Difficult access to data

• Improved data integrity

• Security problems

Which level of data abstraction describes what data are stored in the database?

• Physical level

• Logical level

• View level

• None of the above

What is Entity Integrity?

• Foreign key cannot be NULL

• Primary key cannot be NULL

• Primary key can have NULL values

• Foreign key must reference a primary key

Which of these is a property of Data Independence?

• Logical level should affect physical level

• Physical changes affect logical schema

• Storage structure affects application

• Physical changes don’t affect logical schema

What is a 'view' in DBMS?

• A stored table

• A temporary data structure

• A virtual table

• A data model

What is the E-R model based on?

• Real world entities and relationships

• Tables and rows

• Only attributes

• Foreign keys

Which of these is an example of an entity?

• Customer name

• Customer address

• Product

• Customer’s purchase history

What is a weak entity set?

• Entity set with a primary key

• Entity set that relies on foreign key

• Entity set without a primary key

• None of the above