BCIS 3610 EXAM 1 (CH1-5) Question and answers already passed
3 views 0 purchase
Module
BCIS 3610
Institution
BCIS 3610
BCIS 3610 EXAM 1 (CH1-5) Question and answers already passed
The smallest piece of data used by a computer is a(n) _____. - correct answers Bit
Haley's employer has asked her to review tens of thousands of social media posts about their company's products and compile this data into a databas...
BCIS 3610 EXAM 1 (CH1-5) Question and
answers already passed
The smallest piece of data used by a computer is a(n) _____. - correct
answers Bit
Haley's employer has asked her to review tens of thousands of social media
posts about their company's products and compile this data into a database.
In terms of the characteristics of big data, Haley is dealing with ________. -
correct answers variety
A _____ is a subset of a data warehouse that is used by small- and medium-
sized businesses and departments within large companies to support decision
making. - correct answers data mart
In the context of the relational database model, selecting involves combining
two or more tables - correct answers False
A ______ is a collection of instructions and commands used to define and
describe data and relationships in a specific database. - correct answers Data
definition language
A collection of data fields that are all related to one object, activity, or
individual is called a file. - correct answers False (its a record)
_____ is the term used to describe enormous and complex data collections
that traditional data management software, hardware, and analysis processes
are incapable of handling. - correct answers Big data
,Kyle works for National Sporting Goods, where he manages critical data
elements, such as identifying and acquiring new data sources, creating
consistent reference data, and analyzing data for quality. Kyle is a _______. -
correct answers Data Steward
It is possible to restrict access to data depending on the database user's
privileges. - correct answers True
For the ____ operation, it is required that the the two tables have a common
attribute. - correct answers join
One of the primary advantages of a relational database is that it allows tables
to be linked to reduce data redundancy and allow data to be organized more
logically. - correct answers True
A database must reflect the business processes of an organization. - correct
answers True
A field is typically a name, number, or combination of characters that
describes an aspect of a business object. - correct answers True
A database management system (DBMS) serves as an interface between an
application program and a database. - correct answers True
Two sets of fields can have a common primary key. - correct answers False
Each attribute in a relational database model can be constrained to a range of
allowable values called a _____. - correct answers domain
,Suppose a manager wishes to analyze historical trends in sales. He would
use the online transaction processing (OLTP) system. - correct answers False
To ensure reliability and integrity, SQL databases conform to four specific
properties. Which of the following is NOT one of those four properties? -
correct answers currency
(isolation, atomicity, durability,
Unstructured data comes from sources such as word-processing documents
and scientific research. - correct answers True
What are three attributes of data that would indicate that it may be big data -
correct answers variety, volume, velocity
Organizations can collect many types of data from a wide variety of sources,
but typically they only collect structured data that fits neatly into traditional
relational database management systems. - correct answers False
A database administrator (DBA) is an important nontechnical position
responsible for defining and implementing consistent principles for a variety of
data issues, including setting data standards and data definitions that apply
across all the databases in an organization. - correct answers False
(its data administrator)
An attribute is a general class of people, places, or things for which data is
collected, stored, and maintained. - correct answers False- attribute is a char
of an entity
, Starting from monthly sales data, if you wish to get weekly sales data, use the
___ feature. - correct answers drill down
A(n) _____ is a field or set of fields in a record that uniquely identifies the
record. - correct answers Primary key
An enterprise data model is created only for documentation, but is otherwise
inconsequential. - correct answers False
If "color" is an attribute, then "green" is a data item. - correct answers True
DBMSs are used primarily for modeling data. - correct answers False (ch 5)
One of the disadvantages of proprietary software is that ______________. -
correct answers it can take a long time and significant resources to develop
the required software features
Today's mobile phones and some PCs use a touch user interface called a
_____ to allow people to control the personal computer. - correct answers
natural user interface
The use of middleware to connect disparate systems has evolved into an
approach for developing software and systems called _____. - correct
answers service-oriented architecture
Suppose a business wishes to move away from hosting its own applications,
the recommended solution is to use ______. - correct answers cloud
computing
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller flyhigher329. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £10.94. You're not tied to anything after your purchase.
