More Midterm Practice - Info to IT

__________ databases organize data in rows and columns like a flat file, but they do so across many tables of related data using unique keys to identify each row. (example: Facebook)

______ databases combine data into a single object instead of using tables, rows, and columns to break data up. The fields of engineering, telecommunications, physics, and molecular biology use these databases heavily. (often application dependent)

The most appropriate database to be able to track the relationships between different types of data, such as company customer lists, sales tracking, and employee commissions would be ....

• object

• flat data

• relational

• SQL

Answer explanation

key phrase - track the relationships

flat data - just a collection of data, so NO

object - combine data into a single object, NO

SQL - Structured Query Language - used to maintain and query or search the database, so NO

Fill in the blank...

The DBMS is typically described based on the _________ of the database it manages.

• content

• complexity

• structure

• size

Answer explanation

module 4 lesson 3 - 1st paragraph READ: Unlocking the Data

A __________ database management system models the relationships between data files forming a web-like network database.

• relational

• network

• Hierarchical

• Object-Oriented

A _______________ DBMS is a series of descending levels of data coming off a single root. Multiple child nodes branch off from the root, and each branch acts as the parent to extra child nodes that branch from them. This type of DBMS describes a type of real-world index

• Dysfunctional Family

• Relational

• Hierarchical

• Object-Oriented

most flexible type of database in terms of overall structure and have the advantage of being able to handle large volumes of diversely formatted data

• Hierarchical

• Relational

• Object-Oriented

• Network

One critical flaw with this type of database --- as the network of nodes becomes more complex, it becomes harder to insert, delete, or update date records without causing issues in related nodes

• Network

• Relational

• Object-Oriented

• Hierarchical

Many social media companies use a popular NoSQL database called _____________.

• HierarchicalDB

• MongoDB

• DynamoDB

• GoDaddyDB

_________________ is an example of a desktop based relational DBMS that can support small business or personal databases

• All of the examples are correct

• Microsoft Access

• FileMaker Pro

• LibreOffice Base