Chapter 5 Quiz BCIS 4350 PDF

Preview

Summary

quiz answers...

Description

Chapter 5 Quiz BCIS 4350 (95/100 correct answers listed below)

1. To ensure reliability and integrity, SQL databases conform to four specific properties. Which of the following is NOT one of those four properties?

Group of answer choices durability isolation atomicity currency 2. A _____ is a simple database program whose records have no relationship to one another.

Group of answer choices relational system flat file user view schema 3. A _____ is a subset of a data warehouse that is used by small- and mediumsized businesses and departments within large companies to support decision making.

Group of answer choices data model data mine data mart data dictionary 4. A ______ is a collection of instructions and commands used to define and describe data and relationships in a specific database.

Group of answer choices data dictionary data manipulation language schema data definition language 5. A collection of fields all related to a single object, activity, or individual is a(n) _____.

Group of answer choices record character attribute file 6. A database is a collection of integrated and related _____.

Group of answer choices attributes files fields records 7. A(n) _____ is a field or set of fields in a record that uniquely identifies the record.

Group of answer choices entity attribute data item

primary key 8. At Coast-to-Coast Moving and Van Lines, Ryan is responsible for managing the flow of the company's data, from initial acquisition of new data to deletion of old, outdated data. Ryan is involved in ___________.

Group of answer choices data management database administration data stewardship data lifecycle management 9. For the ____ operation, it is required that the two tables have a common attribute.

Group of answer choices project join delete select 10. 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 _______.

Group of answer choices data administrator data steward data manager database administrator 11.Suppose a new tech startup wants to define the data model. They would then ____.

Group of answer choices

create the entity-relationship model define user access privileges collect and cleanse the data acquire a new database management system 12.The action of including only some columns for output while retrieving data is known as ____.

Group of answer choices joining selecting projecting linking 13.The smallest piece of data used by a computer is a(n) _____.

Group of answer choices byte entity bit character 14.With _____, the database is stored on a service provider’s server and accessed by the client over a network, typically the Internet.

Group of answer choices Software as a Service Oracle Database as a Service Internet access

15._____ is a special-purpose programming language for accessing and manipulating data stored in a relational database.

Group of answer choices Java Access Structured Query Language (SQL) Query by Example (QBE) 16._____ is the term used to describe enormous and complex data collections that traditional data management software, hardware, and analysis processes are incapable of handling.

Group of answer choices Knowledge base Data mart Big data Data warehouse 17._____ is an approach that starts by investigating the general data and information needs of an organization at the strategic level and then examines more specific data and information needs for the functional areas and departments within the organization.

Group of answer choices Data cleansing Enterprise data modeling Data selecting Social graph analysis 18.You would use Query by Example, if _____.

Group of answer choices

you build a query from an example wish teach SQL with examples you wish to use a visual approach to query building you use a template for reports 19.Which of the following statements is true of a database?

Group of answer choices It provides an essential foundation for an organization’s knowledge management and artificial intelligence systems. It is accessed primarily for use by an organization’s database administrator and data administrator. It is a collection of unstructured data. It helps companies analyze information to open new market opportunities. 20.The position of a _____ is a non-technical position responsible for defining and implementing consistent principles for setting data standards and data definitions that apply across all the databases in an organization.

Group of answer choices data analyst data administrator database administrator data owner...