OIM 471 Exam 2
What is the difference between a DBMS and a database?
A DBMS is software; a database is a collection of tables, relationships, and metadata
Traditional database management systems (i.e., SQL Server) support the acronym ____________ to help ensure that either all of a transaction is processed or none of it is, and that transactions are consistent, isolated, and permanently stored.
ACID
Changing the configuration of a database falls under which category of database administration?
Adaptation
According to the text, why is the NoSQL DBMS acronym misleading?
It really should be nonrelational DBMS
After comparing alternatives for data storage, management at eHermes selected ______________ as their database.
Microsoft SQL Server
Which process operation is utilized to edit data that is already stored in the database?
Modify
eHermes could use a new NoSQL DBMS such as ________ to store its security video footage in the same database as the metadata
MongoDB
____________ is an example of a NoSQL DBMS
MongoDB
Security management falls under which category of database administration?
Operation
All of the following are examples of nonrelational databases EXCEPT ________.
Oracle DBMS
Which of the following describes the purpose of a query?
Searching the database based on data values provided by the user
A database consists of the following components
Tables + Relationships+ Metadata
It is said that a DBMS and a database are not the same thing. Which of the following statements best justifies this position?
The DBMS is a software package that you would use to build and manage the database
In a database of telephone customers, which would be the best primary key?
The account number for each customer
Which of the following is an example of metadata?
The data type of a field
The fictional public television station described in the text would like to track all of the following facts about its volunteers EXCEPT which one?
The length of a fund-raising campaign in days
Using SQL Server, how was eHermes planning on storing images in the database?
Using metadata and storing URLs of the file
You are building a database for a class survey you are conducting. One of the questions is as follows: "Are you participating in this survey of your own free will?" What type of database field is the best in which to store the response to this question?
Yes/No
The columns in a database are also called ________.
fields
A __________ is another name for a database table.
file
Relational databases store data in the tables of columns and rows by placing the primary key in another table where it becomes a ____________.
foreign key
A limitation of the relational data model that contributed to the development of nontraditional DBMS products is _______.
fundamental ACID transaction processing
By choosing to store video footage on a file server and using Access to keep metadata about the footage, eHermes achieves all of the following benefits EXCEPT ____________.
gaining experience with a new DBMS product
The purpose of a database is to ___________.
keep track of things
A special challenge encountered when many users access and process a database is the ____________.
lost-update problem
A database includes __________, which is data within itself that describes its contents
metadata
As Jack explains to Kate, _____ describe the characteristics of each field in a database table; thus, they are data that describe data.
metadata
The data in a database management system that identifies the structure of the database including names of tables, fields in each table, and the properties of each of the fields, as well as which fields are primary and foreign keys, etc., is called ____________.
metadata
Ultimately, eHermes decided to modify SQL Server ____________ to store URLs of the file server location that contained the images needed for the project.
metadata
Every record in a table in a database must have a ____________, which is a column or group of columns that identifies a unique record in the table
primary key
Database applications include a(n) ____________ element to search the database based on data values provided by the user.
query
Joshua's supervisor requests information on video game console sales from the Midwest region. Joshua should use what type of database element?
report
According to information presented in this video, each _____ in a relational database table is a unique record of something that users want to track.
row
The records in a database table are generally visualized as ________.
rows
As Jack explains to Kate, a _____ is effective for managing information about one thing, such as items for sale in a retail store.
spreadsheet
A ____________ or file includes a group of similar rows or records that represent a single theme
table
The primary purpose of a database is ______
to keep track of things
The lost-update problem occurs when ________.
two users in a multi-user environment attempt to make the same updates to the database at the same time, so that one erases the effect of the other
Data maintained in a database describing volunteers for the fictional public television station described in the text is LEAST likely to include ________.
volunteer financial status
eHermes used ____________ image classifier to speed up the process of inventorying new items by automatically recognizing them.
Google's
____________ is a standardized language for querying databases
SQL
____________ is a popular database management system (DBMS) developed by Microsoft.
SQL Server
The fund-raising drives used by the fictional public television station described in the text are important because ____% of the operating budget is based on donated funds.
40
Which is an example of a database?
A cellphone contact list
Which best describes the purpose of a primary key?
A unique identifier
The term ACID transactions refers to which of the following?
Atomic, consistent, isolated, durable
Which of the following is a task using a thin-client?
Checking Gmail
A popular DBMS product created by IBM is _________________.
DB2
In this video, Jack describes a(n) _____ as a software program for creating, processing, and administering a database.
DBMS
According to information presented in this video, which of the following is best for managing information about more than one thing, such as inventory, suppliers, customers, and sales?
Database
What type of software tracks very large amounts of related data?
Database
Which process operation is utilized to remove a record that is already stored in the database?
Delete
Specification of database requirements falls under which category of database administration?
Development
____________ is a NoSQL DBMS developed by Amazon to overcome the limitations of a traditional relational DBMS
Dynamo
Which category of nonrelational databases consists of DBMS products that process databases in main memory?
In-memory DBMS
Which function of a database management system (DBMS) allows data to be read, inserted, modified, and deleted
Processing the database
Two tables in a database contain a common field, say StudentID. This field is the primary key of the Student table and is a non-key field in the OFFICE_VISIT table. Which of the following elements of the definition of a database does this illustrate?
Relationships among rows
The code "INSERT INTO STUDENT (StudentNumber) VALUES (1);" is an example of ____________.
SQL
__________ is an international standard language for database development and querying
SQL
Who knows if a database needs to be updated or changed?
The user
Which of the following statements is true regarding the rise of nontraditional DBMSs?
There is a need to process less structured data such as business documents and nontraditional data types (e.g., free-form text, audio, and video) in distributed environments
What is the purpose of a DBMS?
To create, process, and administer databases
A database ________ is a collection of forms, reports, queries, and applications programs that make data more accessible, informative, and useful to users.
application
Another word for field is ________.
column
StudentNumber, StudentFirstName, and StudentLastName are likely ____________ in a database table.
columns
A database administrator (DBA) has all of the following tasks EXCEPT to _________________.
create and staff programming functions
What was the goal of eHermes' use of Google's image classifier system?
eHermes wanted to speed up the process of inventorying new items.
A ____________ is a self-describing collection of integrated records
database
A(n) _______ is a program used to create, process, and administer a database
database management system
