DBMS QUIZ

 The description of a particular database (e.g. data structures, types, and constraints) is called

• Catalog

• MetaData

• Physical Schema

• Instance

Allowing changes to data structures and storage organization without having to change the DBMS access programs is called

• Data dependence

• Data abstraction

• Data Independence

• Program Dependence

 The ability to access and manipulate data without needing to know the details of how it is stored is called

• Data Encapsulation

• Data Representation

• Data Isolation

• Data Abstraction

What term is used to refer to a specific record in your music database; for example; information stored about a specific album?

• Relation

• Instance

• Table

• Column

Which of the following refers to a set of rules that define the structure of a database?

• Data Model

• Data Warehouse

• Data Dictionary

• Data Schema

In the context of owner and weak entity sets in the ER (Entity-Relationship) data model, which one of the following statements is TRUE?

• The weak entity set MUST have total participation in the identifying relationship

• The owner entity set MUST have total participation in the identifying relationship

• Both weak and owner entity sets MUST have total participation in the identifying relationship

• Neither weak entity set nor owner entity set MUST have total participation in the identifying relationship

Which one of the following is used to represent the supporting many-one relationships of a weak entity set in an entity-relationship diagram?

• Rectangles with double/bold border

• Diamonds with double/bold border

• Ovals that contain underlined identifiers

• Ovals with double/bold border

Which of the following is NOT a superkey in a relational schema with attributes V , W, X, Y, Z and primary key VY

• VXYZ

• VWXZ

• VWXY

• VWXYZ

Let E1 and E2 and be two entities in an E-R diagram with simple single-valued attributes, and R1 and R2 are two relationships between E1 and E2 , where E1 is one-to-many and E2 is many-to-many and R1 and R2 do not have any attributes of their own. What is the minimum number of tables required represent this situation in the relation model?

• 2

• 3

• 4

• 5

In an Entity-Relationship (ER) model, suppose R is a many-to-one relationship from entity set E1 to entity set E2. Assume that E1 and E2 participate totally in R and that the cardinality of E1 is greater than the cardinality of E2.
Which one of the following is true about R?

• Some entity in E1 is associated with more than one entity in E2.

• Every entity in E2 is associated with exactly one entity in E1.

• Every entity in E1 is associated with exactly one entity in E2.

• Every entity in E2 is associated with at most one entity in E1.