Overview of Database Management Systems

Question 02
What are the primary features of a Database Management System (DBMS)?
• A)
  Data modeling, Concurrency control, Backups
• B)
  Data retrieval, File storage, Index management
• C)
  Data redundancy, Query optimization, Manual processes
• D)
  Data migration, Document handling, Server configuration
Question 03

What are the two main types of Database Management Systems (DBMS)?

Question 04
What is the relationship between sub-classes and super-classes in the EER model?
• A)
  Sub-classes cannot inherit attributes from super-classes.
• B)
  Sub-classes inherit attributes from their super-class.
• C)
  Sub-classes and super-classes are unrelated entities.
• D)
  All attributes of a sub-class are disjoint from its super-class.
Question 05

What is the significance of specialization and generalization in the Enhanced Entity-Relationship model?

Question 06

What is an Enhanced Entity-Relationship (EER) model?

Question 07
In a binary relationship with 1:1 cardinality and total participation, what happens to the tables of the entities involved when they are combined?
• A)
  They must remain separate due to their unique keys.
• B)
  They can be merged into one table with unique, not null attributes.
• C)
  They are deleted once merged.
• D)
  They must be indexed separately.
Question 08

What does mapping from an ER model to a relational model involve?

Question 09

What does the INNER JOIN keyword do in SQL?

Question 10
What does a LEFT JOIN in SQL return when there is no matching row on the right table?
• A)
  It returns an empty result set.
• B)
  It returns all rows from the right table with NULL values.
• C)
  It returns all rows from the left table with NULL values for the right table.
• D)
  It returns only the matching rows from both tables.