Databases Quiz#2
A disadvantage of the relational database management system (RDBMS) is its inability to hide the complexities of the relational model from the user. (T/F)
False
Business rules apply to businesses and government groups, but not to other types of organizations such as religious groups or research laboratories. (T/F)
False
Database designers determine the data and information that yield the required understanding of the entire business. (T/F)
False
Which of the following types of HDFS nodes stores all the metadata about a file system?
Name node
A(n) _____ is a collection of similar objects with a shared structure and behavior.
class
A(n) _____ is a restriction placed on the data.
constraint
The _____ model uses the term connectivity to label the relationship types.
entity relationship
The _____ model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text.
entity relationship
VMS/VSAM is an example of the _____.
file system data model
One of the limitations of the _____ model is that there is a lack of standards.
hierarchical
The term _____ is used to refer to the task of creating a conceptual data model that could be implemented in any DBMS.
logical design
Students and classes have a _____ relationship.
many-to-many
The _____ data model is said to be a semantic data model.
object-oriented
Which of the following is true of NoSQL databases?
They are not based on the relational model.
An implementation-ready data model should contain a description of the data structure that will store the end-user data. (T/F)
True
Today, most relational database products can be classified as object/relational. (T/F)
True
A data model is usually graphical. (T/F)
True
The relational data model was developed in the _____.
1970s
The hierarchical data model was developed in the _____.
1990s
In an SQL-based relational database, each table is dependent on every other table.
False
_____ are normally expressed in the form of rules.
Constraints
An implementation-ready data model needn't necessarily contain enforceable rules to guarantee the integrity of the data. (T/F)
False
In Chen notation, entities and relationships have to be oriented horizontally; not vertically. (T/F)
False
The external model is the representation of the database as "seen" by the DBMS. (T/F)
False
The relational model is hardware-dependent and software-independent. (T/F)
False
Business rules must be rendered in writing. (T/F)
True
In the context of data models, an entity is a person, place, thing, or event about which data will be collected and stored. (T/F)
True
Within the database environment, a data model represents data structures with the purpose of supporting a specific problem domain. (T/F)
True
Oracle 12c, MS SQL Server, and Tamino are examples of _____ data models.
XML Hybrid
A(n) _____ is the equivalent of a field in a file system.
attribute
Each column in a relation represents a(n) _____.
attribute
A(n) _____ is a brief, precise, and unambiguous description of a policy, procedure, or principle within a specific organization.
business rule
A(n) _____ enables a database administrator to describe schema components.
data definition language (DDL)
A(n) _______ enables a database administrator to describe schema components.
data definition language (DDL)
A(n) _____ is a relatively simple representation of more complex real-world data structures.
data model
A noun in a business rule translates to a(n) _____ in the data model.
entity
In the _____ model, the basic logical structure is represented as an upside-down tree.
hierarchical
The _____ is the representation of a database as "seen" by the DBMS.
internal model
In object-oriented terms, a(n) _____ defines an object's behavior.
method
A(n) _____'s main function is to help one understand the complexities of the real-world environment.
model
In the _____ model, the user perceives the database as a collection of records in 1:M relationships, where each record can have more than one parent.
network
The relational model's foundation is a mathematical concept known as a(n) _____.
relation
A verb associating two nouns in a business rule translates to a(n) _____ in the data model.
relationship
A(n) _____ is bidirectional.
relationship
A(n) _____ in a hierarchical model is the equivalent of a record in a file system.
segment
