Quiz 4 Flashcards
You have dinner with your family and tell them that you have taken BCIS. Your mother tells you that she is proud of you and that now you can help her get her database of recipes set up better because, as it has gotten larger, it seems to have gotten more difficult to use. She shows you her database, and you realize that she is using a spreadsheet. What should you tell her?
Question content area bottom
Part 1
A.
”I’ll show you how to set up a simple database with one table called ‘Recipes.’ You’ll be able to manage it and run simple queries on it to find specific recipes very quickly and easily. All you need is some rudimentary knowledge of Access to get the job done.”
B.
”You should switch to a database only if you want to share your recipes with other people across the Web.”
C.
”Don’t worry about trying to use a database because they have to be created by professional people and you will need them to keep it running.”
D.
”Keep it simple, Mom. There is no need for a real database here. You probably just need to learn how to use the spreadsheet data filter properly, and things will go much more smoothly.”
E.
”Stick with your spreadsheet list because it is too expensive to set up and manage a database.”
A.
”I’ll show you how to set up a simple database with one table called ‘Recipes.’ You’ll be able to manage it and run simple queries on it to find specific recipes very quickly and easily. All you need is some rudimentary knowledge of Access to get the job done.”
As a business professional, you need to learn about database technology. Which of the following is not a reason why?
A.
You need to know if database technology can facilitate your project goals.
B.
You might choose to build your own database.
C.
You need to know the underlying technology of the database.
D.
You might be asked to evaluate a data model when the structure of the database changes.
E.
You need to know how to turn data into a format from which you can construct useful information.
C.
You need to know the underlying technology of the database.
Which of the following is an international standard language for processing a database?
A.
C++
B.
Structured Query Language
C.
Standard Query Language
D.
VBA
E.
Visual Basic
B.
Structured Query Language
The management of many types of content has traditionally been handled through __________________.
A.
a database administrator
B.
a database
C.
files and folders
D.
Database Management Systems
E.
a content manager
D.
Database Management Systems
Content management systems can do all the following, except:
A.
organize documents for corporate websites.
B.
seek out documents located across an organization and manage access to them.
C.
categorize media files, word-processing documents, and html pages.
D.
document archiving.
E.
review documents and web pages.
E.
review documents and web pages.
Which of the following are NOT users of a content management system?
A.
Managers
B.
Customers
C.
Copy editors
D.
Employees
E.
Web masters
B.
Customers
What is the type of software used to track very large amounts of related data?
Question content area bottom
Part 1
A.
Email
B.
Presentation
C.
Database
D.
Word processing
E.
Spreadsheet
C.
Database
A ____________ is a self-describing collection of integrated records.
Question content area bottom
Part 1
A.
spreadsheet
B.
PowerPoint presentation
C.
Word document
D.
file cabinet
E.
database
E.
database
The columns in a database are also called ________.
Question content area bottom
Part 1
A.
items
B.
files
C.
tables
D.
fields
E.
records
D.
fields
The records in a database table are generally visualized as ________.
Question content area bottom
Part 1
A.
fields
B.
rows
C.
attributes
D.
files
E.
relationships
B.
rows
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.
Question content area bottom
Part 1
A.
key
B.
folder
C.
field
D.
metadata
E.
descriptor
A.
key
Relational databases store data in the tables of columns and rows that represent relationships using ____________.
Question content area bottom
Part 1
A.
relational keys
B.
objects
C.
primary keys
D.
secondary keys
E.
foreign keys
E.
foreign keys
The data in a Database Management System that identifies the 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 ____________.
Question content area bottom
Part 1
A.
metadata
B.
data definitions
C.
descriptive data
D.
uberdata
E.
qualitative data
A.
metadata
In a database of telephone customers, which would be the best primary key?
Question content area bottom
Part 1
A.
The customer’s driver’s license number
B.
The area code
C.
The account number for each customer
D.
The customer’s name
E.
The customer’s social security number
C.
The account number for each customer
Which of the following is/are NOT considered to be metadata?
A.
Field properties
B.
File name
C.
Field name
D.
Data type
E.
Description
B.
File name
It is said that a DBMS and a database are not the same thing. Which of the following statements best justifies this position?
Question content area bottom
Part 1
A.
A DBMS is used to make changes to a database.
B.
Although they sound similar, the two are actually completely unrelated.
C.
The database is a software package that you use to make tables, relationships, and metadata, and then you use the DBMS to manage those things.
D.
The DBMS is a software package that you would use to build and manage the database.
E.
There is actually no difference between the two. The trade press and some books have incorrectly caused people to think that there is a difference
D.
The DBMS is a software package that you would use to build and manage the database.
You are building a database for a survey you are conducting for a class. 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?
Question content area bottom
Part 1
A.
Memo
B.
Yes/No
C.
Decimal
D.
Text
E.
Integer
B.
Yes/No
Which process operation is utilized to edit data that is already stored in the database?
Question content area bottom
Part 1
A.
Insert
B.
Modify
C.
Delete
D.
Print
E.
Read
B.
Modify
Which process operation is utilized to remove a record that is already stored in the database?
Question content area bottom
Part 1
A.
Modify
B.
Read
C.
Delete
D.
Insert
E.
Print
C.
Delete
Which of the following statements regarding a database application is not true?
A.
It is a collection of forms, reports, queries, and application programs that process a database.
B.
A database application can have one or more users.
C.
A database application can have only one user.
D.
A database may have one or more application programs.
E.
A database application processes logic that is specific to a given business need.
C.
A database application can have only one user.
DBMS programs provide comprehensive and robust features for _____________ a database.
A.
modifying
B.
recording
C.
querying
D.
selecting
E.
updating
C.
querying
As the head of the DBMS department, you attend a meeting with company managers who are known for their tolerance for the changes in the technology in their company. One of them has heard that non-relational/nontraditional databases have helped some leading companies to be very successful. He suggests that your department, and the company, adopt a nontraditional database. You recommend against it and explain that ________.
Question content area bottom
Part 1
A.
the cost of the conversion would be far beyond the finances of the company
B.
nontraditional databases could be brought in for use in new projects, but that there is no need to make it a company-wide adoption
C.
with today’s features, nontraditional products are very technical and can be used only by those with a deep background in computer science
D.
nontraditional products have nothing to offer your company
E.
nontraditional databases have not yet been completely vetted by industry, and time should be allowed for them to succeed or fail
C.
with today’s features, nontraditional products are very technical and can be used only by those with a deep background in computer science
The relational database model can be replaced today because of all the following reasons, except:
A.
Internet applications process many more transactions against much simpler data than traditional applications do.
B.
New data types need to be stored differently.
C.
ACID transactions are not critical anymore.
D.
There is now a need to gain faster performance using many servers.
E.
Improved storage and processing technology made document piece-making via normalization unnecessary.
C.
ACID transactions are not critical anymore
All the following are NoSQL products, except:
A.
Bigtable
B.
MongoDB
C.
Cassandra
D.
Dynamo
E.
ACID
E.
ACID
