7. Study.com - Business 303: Management Information Systems (3) - Chapter 7
Which of the following is an example of an integer data type? 13.829 1st -17 All answers are incorrect. π
-17
Given the following table called Students, how many records would be returned using the following SQL database query? SELECT `Student ID` FROM Students WHERE `Financial Aid` = 'Yes' AND GPA > 3.0; 4 5 3 7
3
Which of the following is an example of an integer? 0.6777 12.5 4.8 4
4
What is a computer server? The physical casing for a large computer system A secure facility to store sensitive data A computer system that stores a data warehouse A centralized computer system which provides services over a network
A centralized computer system which provides services over a network
What is a database? A part of a computer closest to data A base layer for storing items A computer mechanism for storing and retrieving data A type of a disk
A computer mechanism for storing and retrieving data
A field in a database table whose values are the same as the primary key of another table is called: A foreign key A secondary key A primary key An alternate key A candidate key
A foreign key
All of these statements are correct, EXCEPT: A number with a decimal is referred to as an integer. A string is an alphanumeric data represented on a database. A Boolean data type can only represent two values: true or false. All digital data are stored as binary digits.
A number with a decimal is referred to as an integer.
_____ is a field in a database table (or a combination of fields) that has a unique value. A primary key A secondary key A foreign key An alternate key An identifier
A primary key
_____ is a field in a database table (or a combination of fields) that has a unique value. A foreign key An identifier An alternate key A secondary key A primary key
A primary key
What is a firewall? Software that encrypts data before it leaves an internal network A security system consisting of software or hardware between an internal network and the Internet A physical enclosure of a data storage system to keep it safe from fire, water and other elements Software that removes viruses and other malware from a computer network A backup system for a database so it can be recovered if the original is destroyed
A security system consisting of software or hardware between an internal network and the Internet
_____ within a database makes up a schema. A set of chairs A set of tables A set of malwares A set of codes
A set of tables
What does a database model provide? The different data types that can be stored in a database The best names to use for database tables A systematic way to organize data A conceptual representation of digital data The file format to store the database
A systematic way to organize data
What is a computer virus? A type of malware that replicates itself into computer programs and performs some type of harmful activity. A type of malware that provides unauthorized access to someone computer system. Software that logs a user's keystrokes on a keyboard in order to get access to their passwords. Software that keeps track of someone's online activities without their knowledge. A type of malware that displays unwanted advertising on your monitor.
A type of malware that replicates itself into computer programs and performs some type of harmful activity.
Which of the following is NOT an example of current spreadsheet software? Access Excel Calc Numbers
Access
Which of the following is an example of database software? Lotus 1-2-3 Excel Access Numbers Word
Access
Which of the following tasks is a typical role of a database administrator? Controlling data security All are typical tasks. Managing data recovery and backup procedures Providing support services to end users Controlling access to the database
All are typical tasks.
Which of the following tasks is a typical role of a database administrator? Controlling access to the database Controlling data security Providing support services to end users All are typical tasks. Managing data recovery and backup procedures
All are typical tasks.
In what way might data mining help marketing? By helping find when goods are purchased. By indicating what customers may want which goods Providing input about which goods should be matched with one another for higher profits All of the above
All of the above
Which of the following is an example of a database? Customer contact information Library catalog Hospital records All of the answers are examples of databases. Store sales transactions
All of the answers are examples of databases.
What would be the benefits to a chain of grocery stores from using a database? All of these are correct. Multiple users could access store data at the same time. Top management can easily track each stores sales. Each stores data could be available to other stores. Store inventory data would be available and up to the minute.
All of these are correct.
A relationship between two or more tables is also known as: An association A key A link An attribute A database model
An association
What is the difference between analog and digital data? Analog data cannot be stored while digital data are stored using computers. Analog data are continuous while digital data are discrete. There is no real difference. Analog data refer to data from before the invention of computers.
Analog data are continuous while digital data are discrete.
What is the difference between analog and digital data? There is no real difference. Analog data cannot be stored while digital data are stored using computers. Analog data refer to data from before the invention of computers. Analog data are continuous while digital data are discrete.
Analog data are continuous while digital data are discrete.
AND would be an appropriate operator to use while searching in a database using only _____ logical operators. Boolean JavaScript PHP JS
Boolean
All of these statements are correct, EXCEPT: Once a database has been created using one format, the values can be displayed in different formats. A document with 100,000 words usually require less than 1 megabyte of space. Organizing multimedia files typically uses an object-oriented view of the data. Boolean data include photographs, audio, video, and numerous specialized formats.
Boolean data include photographs, audio, video, and numerous specialized formats.
_____ refers to how many records in a table are related to the number of records in another table. Keying Association Cardinality Linking Hierarchy
Cardinality
In which of the following cases is a person using the Flat file management model? Pedro is the Director of an enterprise, and uses multiple databases in different formats to manage its finances. Clea manages the finances for her company in a database that consists of a single table on a spreadsheet. John is the administrator of a company, and uses a database that consists of a single table on a word document to organize the finances of the company. Leyla is the CEO of a company, and manages its finances in a database that consists of multiple tables on a spreadsheet.
Clea manages the finances for her company in a database that consists of a single table on a spreadsheet.
_____ operators are used to compare values, while _____ operators make it possible to combine two or more conditions in a single statement. Arithmetic; comparison Boolean; comparison Comparison; boolean Arithmetic; boolean
Comparison; boolean
Which of the following is an advantage of a hierarchical data model? Ability to store multimedia data types Easy to understand database tables Conceptual simplicity Complex data relationships can be modeled
Conceptual simplicity
Data security management concerns which of the following? Controls are created regulating the access of data Quality assurance of data is defined Data is categorized in a retrievable manner Maintenance of the database is determined
Controls are created regulating the access of data
What is the primary advantage of using a distributed database? Storage capacity needs are reduced. Multiple users can use the same database at the same time. Data management is much simpler. Data access and processing are much faster.
Data access and processing are much faster.
Which of the following statements is false with respect to distributed databases? Data at each site are under control of the DBMS. Users may not be aware that they are using a distributed database. Multiple computer network sites are connected by a communication system. Data at any site are only available to users at those sites.
Data at any site are only available to users at those sites.
What is composite data? True or false data represented by 1 or 0. Data formed by a combination of multiple attributes. All of these are correct. A minimal set of fields whose values uniquely identify a record in a table.
Data formed by a combination of multiple attributes.
What is the need for data quality management? Data quality management is a critical component of maintaining value within an organization Errors in data will likely have no consequences An organization will never possess a database that contains errors Data that is specific to an organization should be freely shared by all individuals
Data quality management is a critical component of maintaining value within an organization
What does the term big data refer to? Data that is too big to be stored in a database A document that contains a large amount of data Data that has the potential of bringing significant value to an organization. A database that contains a large amount of documents
Data that has the potential of bringing significant value to an organization.
What is master data? Data that is considered erroneous and need be cleansed Data that is specific and meaningful to an organization Data that is indistinguishable Data that can be used across all organizations regardless of the type
Data that is specific and meaningful to an organization
What does the acronym DBA stand for in the context of information systems? Database business address Design bandwidth allocation Database administrator Database administration Doing business as
Database administrator
Which of the following about database management is false? Different people in an organization may have access to different parts of a database. A library catalog is an example of a database. Databases can only be accessed by the database manager. Many databases are updated regularly. Making a database searchable makes it more useful.
Databases can only be accessed by the database manager
Which of the following BEST describes the use of referencing in spreadsheet software? Using statistical formulas to calculate cell values Use the values in one spreadsheet to populate the values in another Documenting the source from which cell values are derived Copying the values of other cells into new cells Determining the value of a cell by using the values of other cells
Determining the value of a cell by using the values of other cells
Which of these statements is true about analog data? It is finite It is continuous It is discrete All of these are correct.
It is continuous
Which of the following is NOT true of a data warehouse? It provides storage of data. It provides a way for businesses to understand data from multiple databases. It is a collection of databases that work together. It is one large database that is stored in a large building.
It is one large database that is stored in a large building
Which of these is typically true about the information that data mining reveals? It may not always be logical or apparent, but makes sense after looking at the numbers It makes sense only after qualitative analysis It is always logical It never makes sense
It may not always be logical or apparent, but makes sense after looking at the numbers
Which of these is typically true about the information that data mining reveals? It never makes sense It may not always be logical or apparent, but makes sense after looking at the numbers It makes sense only after qualitative analysis It is always logical
It may not always be logical or apparent, but makes sense after looking at the numbers
n which of the following cases is normalization the BEST database business process to use? Sabrina is creating a customer service database and does not care about the order of each field. Lily is constructing a customer service database and wants to break up data into the smallest parts. She is using this database to create different fields for the customers' first and last name Rob is creating a database that deeply cares about the last name of the clients, therefore, this is the most important field on it. Kevin is managing a database that does not break up the data but rather contemplates it in the biggest possible parts.
Lily is constructing a customer service database and wants to break up data into the smallest parts. She is using this database to create different fields for the customers' first and last name
A database of auto parts has two tables. The first table includes all the different parts. The second table includes all the different types of vehicles. Some parts can be used in more than one vehicle, while all vehicles consist of more than one part. This describes which type of table association? Many-to-all Many-to-one Many-to-many All-to-many One-to-many
Many-to-many
Access is a database program that is widely used on _____ operating systems. Linux Microsoft Chrome Fedora
Microsoft
Which statement is false with respect to multimedia data types? All statements are true. Multimedia data cannot be stored in a database management system. Multimedia data typically require more storage capacity than text and numbers. Multimedia data are typically stored in an object-oriented database. Multimedia data consist of images, audio, video and specialized data types.
Multimedia data cannot be stored in a database management system.
What makes a relational database so effective ? Multiple tables can be linked together. It can be used to store video. It works best for data that is inherently hierarchical. Every object has a unique ID. It can be used to store objects.
Multiple tables can be linked together.
Which of the following database models uses parent-child relationships where each child can have multiple parents? Relational database model Parent-child database model Hierarchical database model Network database model Object-oriented database model
Network database model
Which SQL statement is used to sort the result of a database query? ORDER BY ORDER SORT-ORDER SORT BY
ORDER BY
Which of the following DBMS models would be used to manage a collection of audio files ? Network Relational Flat files Hierarchical Object-oriented
Object-oriented
Which of the following DBMS models would be used to manage a collection of audio files ? Network Relational Hierarchical Flat files Object-oriented
Object-oriented
Which of these is NOT an application of data mining? Predicting new disruptions Improving manufacturing Marketing Improving hiring
Predicting new disruptions
Which of the following does not represent a typical scenario with respect to the use of a database by a hospital ? A Doctor accessing the database from home Printing out all the pages of a database to create a permanent record of patients Updating the database to reflect a patients treatment All of the answers are correct. Searching through the database to find a patients records
Printing out all the pages of a database to create a permanent record of patients
Which of the following does not represent a typical scenario with respect to the use of a database by a hospital ? Printing out all the pages of a database to create a permanent record of patients Searching through the database to find a patients records A Doctor accessing the database from home All of the answers are correct. Updating the database to reflect a patients treatment
Printing out all the pages of a database to create a permanent record of patients
Which of the following is not involved in data governance? How data will be used, when, and by whom is determined Decisions regarding data-related matters are made Purging data from the system that is no longer needed Policies and formal organizational documents are created
Purging data from the system that is no longer needed
Which of the following is used in database software to answer basic questions about your data? Filtering Formatting Queries Sorting Referencing
Queries
What does RDBMS stand for? Real Database Messaging System Relational Database Management System Research Development BMS Rapid Development Bit Map Systems
Relational Database Management System
Given a table called Employees with a field called Last Name, using SQL, how would you select all the records with the last name 'Jones'? FROM Employees SELECT all WHERE Last Name = 'Jones' SELECT * FROM Employees WHERE Last Name = 'Jones' SELECT * FROM Employees WHERE Last Name <> 'Jones' FROM Employees SELECT * WHERE Last Name = 'Jones'
SELECT * FROM Employees WHERE Last Name = 'Jones'
_____ is a programming language for accessing and manipulating a _____. EGL/social media PHP/CRM SQL/database HTML/website
SQL/database
In the data storage sense, what does 'denormalized' mean? Storing data in small chunks Data containing unusual information Storing data in large chunks Standardizing data before it's stored
Storing data in large chunks
In which of the following cases would a Database Administrator be the needed employee for a company? The Amarillo Company needs a person who could improve the velocity of the promotional website for customers to navigate easier. The Verde Company needs a person who could provide emotional support to internal workers who use the database to analyze and improve the performance of the company. The Rojo Company needs a person who could provide support services to end users, to set data privacy, and to protect company data against security threats. The Azul Company is lacking personnel to call and find new leads that could be a part of the sales database.
The Rojo Company needs a person who could provide support services to end users, to set data privacy, and to protect company data against security threats.
In which of the following examples would it be more useful to use the Data Mining technique? The Avion Company is worried about data loss and focuses its efforts on preparing themselves in case of losing files. The Voiture Company analyzes the data it collects and summarizes it to produce useful business intelligence information. The Velo Company develops the best program to manage the information they receive from social media to improve the velocity of the system. The Train Company is trying to maintain the security of all the data it collects and open the information only to a small group of people.
The Voiture Company analyzes the data it collects and summarizes it to produce useful business intelligence information.
Where does the information used in data mining come from? It is purchased from a data company It is freely available on the internet The company acquired it from their own resources The company steals it from a competitor
The company acquired it from their own resources
Computers represent data in a finite manner. What does this mean? Computers cannot store analog data. There is an infinite amount of different ways to represent something. The data are discrete and not continuous. Computers are not (yet) as intelligent as the human brain.
The data are discrete and not continuous.
What is data encryption? Copying data onto an external drive and locking this into a safe Breaking up a database into many pieces before sending it across the Internet so nobody can see the entire database Converting the format of a database so it cannot be read by regular software Translating a message into a language nobody else can understand The process of encoding messages so it can only be viewed by authorized individuals
The process of encoding messages so it can only be viewed by authorized individuals
Why is SQL so widely used? This programming language can be applied to any database management system once learned. It is the programming language used to make interactive web pages. It is the programming language of the World Wide Web and is built into all major web browsers. This programming language is behind audio/video processing.
This programming language can be applied to any database management system once learned.
If you owned a business, how might you use data mining? You can only use data mining with credit card customers Use basic summaries of information to get a general idea of customer habits To find patterns in large amounts of data Analyze a small sampling of data in order to make predictions
To find patterns in large amounts of data
If you owned a business, how might you use data mining? Use basic summaries of information to get a general idea of customer habits You can only use data mining with credit card customers Analyze a small sampling of data in order to make predictions To find patterns in large amounts of data
To find patterns in large amounts of data
What is the purpose of primary and foreign keys? To differentiate the analogue and digital data. To relate boolean data. To differentiate numerical and quantitative data. To relate records on a relational database.
To relate records on a relational database.
What is the primary strategic goal of database management for an organization? To store all relevant data in a database To support effective problem solving and decision making To convert all paper-based data to digital data in a computer-based database To make all important data available to everyone in the organization
To support effective problem solving and decision making
How might data mining help HR? Suggesting which employees should be trained to be the new CEO Tracking employee morale and performance Finding employees to fire Data mining doesn't help HR
Tracking employee morale and performance
What type of information is classified as boolean data? True or false Photographs and audio Qualitative Numerical
True or false
When would encryption be the best type of technology for the Chat company? When organizing and analyzing all the different codes in a database. When creating new systems to find and use new data coming from customers. When creating a display page to show the possible payment options for a client. When encoding a customer's credit card information in order to avoid identity theft
When encoding a customer's credit card information in order to avoid identity theft
While both spreadsheet and database software can be used to organize and manipulate data, when would you benefit most from using database software? You have data that consist of text and numbers You need a rigorous structure to organize your data effectively You are going to carry out statistical analysis using your data You need to perform many different types of calculations on your data You want to make graphical displays of your data
You need a rigorous structure to organize your data effectively
Sometimes data values consist of numbers, yet they are best stored as text. To which of the following does this apply? Annual earnings of an employee ZIP code of an employee's address Number of dependents of an employee All answers are incorrect. Age of an employee
ZIP code of an employee's address
A wildcard is the symbol used in _____ to select all the fields. Access FileMaker a SQL statement dBase
a SQL statement
What is the diagram symbol for a database? a line a circle a cylinder a cloud
a cylinder
Many types of data cannot be easily organized. This is a limitation when using _____ database management system. a cycle an equality a chain a hierarchical
a hierarchical
A(n) _____ is an example of Malware. adware pop-up window cookie computer virus
computer virus
Cardinality refers to _____. the difference between qualitative and quantitative data how the records in a database are related to one another the difference between an analogue and a digital table how many values in one table are related to how many values in another table
how many values in one table are related to how many values in another table
Statements in SQL _______________. should use binary format may be completely random must use correct English grammar must adhere to the specific syntax
must adhere to the specific syntax
A(n) _____ database does not use the same row and column approach, while a _____ database does. selling-oriented/encrypted information-oriented/non-relational analyze-oriented/improving object-oriented/relational
object-oriented/relational
Which database type is the simplest type and is organized into rows and columns in a text file? text database command line shell database line entry
text database
