Study sets, textbooks, questions
Upgrade to remove ads
OIM 471 Exam 2
Terms in this set (91)
The primary purpose of a database is ______
to keep track of things
____________ is a standardized language for querying databases
The purpose of a database is to ___________.
keep track of things
Which is an example of a database?
A cellphone contact list
Who knows if a database needs to be updated or changed?
__________ is an international standard language for database development and querying
What type of software tracks very large amounts of related data?
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
A database includes __________, which is data within itself that describes its contents
Another word for field is ________.
Which best describes the purpose of a primary key?
A unique identifier
Which of the following is an example of metadata?
The data type of a field
A database consists of the following components
A ____________ is a self-describing collection of integrated records
The columns in a database are also called ________.
The records in a database table are generally visualized as ________.
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
Relational databases store data in the tables of columns and rows by placing the primary key in another table where it becomes a ____________.
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 ____________.
In a database of telephone customers, which would be the best primary key?
The account number for each customer
A __________ is another name for a database table.
A ____________ or file includes a group of similar rows or records that represent a single theme
StudentNumber, StudentFirstName, and StudentLastName are likely ____________ in a database table.
A(n) _______ is a program used to create, process, and administer a database
database management system
Which function of a database management system (DBMS) allows data to be read, inserted, modified, and deleted
Processing the database
What is the purpose of a DBMS?
To create, process, and administer databases
What is the difference between a DBMS and a database?
A DBMS is software; a database is a collection of tables, relationships, and metadata
A database administrator (DBA) has all of the following tasks EXCEPT to _________________.
create and staff programming functions
A popular DBMS product created by IBM is _________________.
The code "INSERT INTO STUDENT (StudentNumber) VALUES (1);" is an example of ____________.
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
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?
Security management falls under which category of database administration?
Which process operation is utilized to edit data that is already stored in the database?
Which process operation is utilized to remove a record that is already stored in the database?
Changing the configuration of a database falls under which category of database administration?
____________ is a popular database management system (DBMS) developed by Microsoft.
Specification of database requirements falls under which category of database administration?
A database ________ is a collection of forms, reports, queries, and applications programs that make data more accessible, informative, and useful to users.
A special challenge encountered when many users access and process a database is the ____________.
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
Which of the following describes the purpose of a query?
Searching the database based on data values provided by the user
Which of the following is a task using a thin-client?
Joshua's supervisor requests information on video game console sales from the Midwest region. Joshua should use what type of database element?
Database applications include a(n) ____________ element to search the database based on data values provided by the user.
eHermes could use a new NoSQL DBMS such as ________ to store its security video footage in the same database as the metadata
Ultimately, eHermes decided to modify SQL Server ____________ to store URLs of the file server location that contained the images needed for the project.
What was the goal of eHermes' use of Google's image classifier system?
eHermes wanted to speed up the process of inventorying new items.
After comparing alternatives for data storage, management at eHermes selected ______________ as their database.
Microsoft SQL Server
Using SQL Server, how was eHermes planning on storing images in the database?
Using metadata and storing URLs of the file
eHermes used ____________ image classifier to speed up the process of inventorying new items by automatically recognizing them.
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
____________ is an example of a NoSQL DBMS
A limitation of the relational data model that contributed to the development of nontraditional DBMS products is _______.
fundamental ACID transaction processing
____________ is a NoSQL DBMS developed by Amazon to overcome the limitations of a traditional relational DBMS
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
All of the following are examples of nonrelational databases EXCEPT ________.
Which category of nonrelational databases consists of DBMS products that process databases in main memory?
The term ACID transactions refers to which of the following?
Atomic, consistent, isolated, durable
According to the text, why is the NoSQL DBMS acronym misleading?
It really should be nonrelational DBMS
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.
As Jack explains to Kate, a _____ is effective for managing information about one thing, such as items for sale in a retail store.
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?
In this video, Jack describes a(n) _____ as a software program for creating, processing, and administering a database.
As Jack explains to Kate, _____ describe the characteristics of each field in a database table; thus, they are data that describe data.
According to information presented in this video, each _____ in a relational database table is a unique record of something that users want to track.
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.
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
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
Which of the following is one of the stages in the database system development process?
create a database design
Which of the following must validate and approve a data model?
Like how an architect designs detailed blueprints for a building project, database developers create a ___________ before developing a database.
Which of the following specifies the correct sequence of activities or stages for the database system developmentprocess?
Develop system requirements, create the data model, create the database design, and then create the database
A database application consists of the following EXCEPT ________.
Which of the following statements about the database development process is FALSE?
The database developers usually know everything to include in the database from the start.
Which of the following statements about data modeling is true?
It is a logical representation of the structure of the data.
Which of the following is an accurate statement regarding entities in the entity-relationship data model?
An entity is something that the users want to track.
Which of the following is a notation for a many-to-many relationship in an entity-relationship diagram?
If a student can have many advisors, and an advisor can advise many students, this represents an example of a(n) ____________ relationship.
If a student can have one locker, and a locker can only be assigned to one student, this is an example of a(n) ____________ relationship.
In E-R diagrams, a line is used to connect two entities. This line represents a(n) ____________.
Which of the following would represent the best identifier for a large database?
Within the context of database design, ______________ represent characteristics of the entity such as LastName, FirstName, and Birthdate.
Which of the following statements regarding relationships between entities in the entity-relationship data model isFALSE?
A crow's-foot diagram is the only acceptable technique to depict an entity-relationship diagram.
Which of the following statements about the entity-relationship (E-R) data model is FALSE?
The entity-relationship (E-R) data model is a less popular technique for creating a data model.
Which of the following statements about entities is FALSE?
all entities represent a physical object
Which of the following statements about identifiers is FALSE?
An identifier may have a value that is associated with more than one entity instance.
Which of the following statements about database design is FALSE?
Database design is a straightforward and relatively simple subject, so all business students should master this topic.
What is normalization?
Converting poorly structured tables into two or more well-structured tables
Which of the following statements about transforming a data model into a database design is FALSE?
represent relationships using primary keys
Which of the following statements about information system data integrity is FALSE?
Information systems with poor reputations have no effects on the organizations that use them.
Other sets by this creator
OIM FInal Exam
OIM Chapter 12
OIM Week 12
OIM 471 Chapter 10
Other Quizlet sets
BYUI SPA 441 Doña Perfect capitulo 10 y 11
Cox College Mental Health Exam 2 Chapter 12
Business Law Chapter 12
sociology chapter 7