Exam Mod 1,2
The hierarchical data model was developed in the _____. 1960s 1970s 1990s 1980s
1960s
The relational data model was developed in the _____. 1960s 1990s 1980s 1970s
1970s
The object-oriented data model was developed in the _____. 1990s 1980s 1960s 1970s
1980s
Which of the following types of HDFS nodes acts as the interface between the user application and the HDFS? Data node Map node Name node Client node
Client node
_____ exists when different versions of the same data appear in different places. Conceptual dependence Poor data security Data inconsistency Structural dependence
Data inconsistency
_____ is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions. Data anomaly Data ubiquity Data quality Data integrity
Data integrity
An implementation-ready data model needn't necessarily contain enforceable rules to guarantee the integrity of the data. True False
False
An operational database is sometimes referred to as an enterprise database. True False
False
Data and information are essentially the same thing. True False
False
Data anomaly is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions. True False
False
Database programming languages receive all application requests and translate them into the complex operations required to fulfill those requests. True False
False
Even when a good database blueprint is available, an applications programmer's view of the data should match that of the manager and the end user. True False
False
Field refers to a collection of related records. True False
False
In Chen notation, entities and relationships have to be oriented horizontally; not vertically. True False
False
One disadvantage of the DBMS is that it increases the risk of data security breaches. True False
False
The external model is the representation of the database as "seen" by the DBMS. True False
False
When data are entered into a form and saved, they are placed in the underlying database as knowledge. True False
False
_____ is the result of revealing the meaning of raw facts. An encoded sample Information An encrypted bit End-user data
Information
Which of the following types of HDFS nodes stores all the metadata about a file system? Client node Map node Name node Data node
Name node
_____ are the result of formatting disorganized data in order to facilitate storage, use and generation of information. Structured data Obsolete data Unstructured data Raw data
Structured data
Which of the following is true of spreadsheet applications? They are a better alternative to databases. They enhance the user's ability to understand the data. They do not allow manipulation of data once entered. They provide enhanced security and robust data sharing features.
They enhance the user's ability to understand the data.
Business rules must be rendered in writing. True False
True
Data constitute the building blocks of information. True False
True
Each row in the relational table is known as an entity instance or entity occurrence in the ER model. True False
True
In an SQL-based relational database, rows in different tables are related based on common values in common attributes. True False
True
In the context of data models, an entity is a person, place, thing, or event about which data will be collected and stored. True False
True
M:N relationships are not appropriate in a relational model. True False
True
Metadata describe the data characteristics and the set of relationships that links the data found within the database. True False
True
One disadvantage of a database system over previous data management approaches is increased costs. True False
True
Today, most relational database products can be classified as object/relational. True False
True
_____ data exist in a format that does not lend itself to processing that yields information. Structured Historical Semistructured Unstructured
Unstructured
Oracle 12c, MS SQL Server, and Tamino are examples of _____ data models. relational XML Hybrid file system hierarchical
XML Hybrid
A(n) _____ might be written by a programmer or it might be created through a DBMS utility program. database management system query operating system application
application
The database structure in a DBMS is stored as a _____. collection of files collection of queries set of key/value pairs single file
collection of files
A(n) _____ is a restriction placed on the data. constraint relationship entity attribute
constraint
A noun in a business rule translates to a(n) _____ in the data model. constraint entity relationship attribute
entity
A(n) _____ represents a particular type of object in the real world. relationship attribute node entity
entity
VMS/VSAM is an example of the _____. relational data model XML data model hierarchical model file system data model
file system data model
Accurate, relevant, and timely information is the key to ____. good decision making understanding data management knowledge
good decision making
In the _____ model, each parent can have many children, but each child has only one parent. entity relationship network hierarchical relational
hierarchical
The organization of data within folders in a manual file system is determined by _______. the title of the documents in the folder its expected use the data processing specialist its date of creation
its expected use
A(n) _____'s main function is to help one understand the complexities of the real-world environment. database entity node model
model
A workgroup database is a(n) _____ database. single-user desktop distributed multiuser
multiuser
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 object-oriented hierarchical entity relationship
network
The _____ data model is said to be a semantic data model. entity relationship object-oriented network relational
object-oriented
End-user data is _____. information about a specific subject knowledge about the end users raw facts of interest to the end user accurate, relevant and timely information
raw facts of interest to the end user
A verb associating two nouns in a business rule translates to a(n) _____ in the data model. relationship attribute constraint entity
relationship
An XML database supports the storage and management of _____ XML data. fullystructured structured multistructured semistructured
semistructured
A desktop database is a _____ database. distributed workgroup single-user multiuser
single-user
Data is said to be verifiable if: the data cannot be changed or manipulated. the data always yields consistent results. the data is obtained from trusted sources. the data is stored in different places within the database.
the data always yields consistent results.
