BCIS 3610 Exam 1: Chapters 4 & 5 - Application Software and Database Management, Exams of Nursing

Download BCIS 3610 Exam 1: Chapters 4 & 5 - Application Software and Database Management and more Exams Nursing in PDF only on Docsity!

BCIS 3610 exam 1 ch4&5 questions well

answered to pass

The primary function of application software is to apply the power of the computer to enable people, workgroups, and the entire enterprise to solve problems and perform specific tasks. - correct answer ✔✔True All of the following are examples of activities performed by an operating system EXCEPT ________. - correct answer ✔✔allowing a user to do word processing Utility programs are used to perform system maintenance, such as repairing errors on a hard drive, improving system security, and optimizing sluggish system processes. - correct answer ✔✔True One advantage of proprietary software versus off-the-shelf software is that _____. - correct answer ✔✔the software provides a company a competitive advantage by solving problems in a unique manner When your IT person says, "It is best to host the application on a web server," that means the users will be accessing the software via a(n) ______. - correct answer ✔✔web browser Suppose a business wishes to move away from hosting its own applications, the recommended solution is to use ______. - correct answer ✔✔cloud computing _____ programs can reduce the amount of disk space required to store a file or reduce the time it takes to transfer a file over the Internet. - correct answer ✔✔File-compression A global positioning system (GPS) device uses a(n) _____ to help people find their way around town or more remote areas. - correct answer ✔✔embedded system _____ software addresses the needs that are common across businesses, organizations, or individuals. - correct answer ✔✔Off the shelf

Suppose a stock analyst wants to automate the retrieval of stock trade data, process the data, and produce analysis reports. His requirements can be met by writing custom software. - correct answer ✔✔True Windows embedded was developed by _____________ to support mobile and consumer appliances. - correct answer ✔✔Microsoft Today's mobile phones and some PCs use a touch user interface called a _____ to allow people to control the personal computer. - correct answer ✔✔natural user interface Proprietary software is mass-produced by software vendors to address needs that are common across businesses, organizations, or individuals. - correct answer ✔✔False Software as a Service (SaaS) refers to the use of computing resources, including software and data storage, on the Internet rather than local computers. - correct answer ✔✔False Operating systems provide a measure of security by allowing users to access to those resources they've been cleared to use as well as other users' resources if those resources are beneficial. - correct answer ✔✔False An example of a common hardware function performed by the operating system is presenting information on a monitor or printer. - correct answer ✔✔True Linux is an open-source operating system. - correct answer ✔✔True Your friend has a Mac that runs OS X. If she needs to run a Windows app on it, she can set it to run Windows also. - correct answer ✔✔True A storage device that contains some or all of the operating system is often called a(n) _____ because one can use it to start the computer if he or she has problems with the primary hard disk. - correct answer ✔✔Rescue disk

Being able to develop software without concern for the specific underlying hardware is referred to as _____. - correct answer ✔✔hardware independence _____ software can help a company manage security, enforce corporate strategies, and control downloads and content streaming from corporate databases into smartphones and mobile devices. - correct answer ✔✔Mobile device management (MDM) Suppose you wish to run two different operating systems on one computer, you can accomplish it by using _______. - correct answer ✔✔virtualization software _____ works by swapping programs or parts of programs between memory and one or more disk drives.

• correct answer ✔✔Virtual memory An operating system with _____ capabilities allows a user to run more than one program concurrently. - correct answer ✔✔multitasking ____ is a personal application software that includes a wide range of built-in functions for statistical, financial, logical, database, graphics, and date and time calculations. - correct answer ✔✔Spreadsheet The _____ task management technique of an operating system supports running a program on more than one central processing unit (CPU). - correct answer ✔✔multiprocessing Which of the following statements is true of a database? - correct answer ✔✔It helps companies analyze information to open new market opportunities. A database, a database management system, and the application programs that use the data, make up a database environment. - correct answer ✔✔True If you wish to develop expertise in database management, you must learn popular language known as ______. - correct answer ✔✔SQL A(n) _____ is a detailed description of all data used in a database. - correct answer ✔✔data dictionary

The action of including only some columns for output while retrieving data is known as ____. - correct answer ✔✔projecting While building a data warehouse, you are converting dates to months. This second step in the ETL process is known as ______. - correct answer ✔✔transformation The relational database model is currently the most widely used. - correct answer ✔✔False If "color" is an attribute, then "green" is a data item. - correct answer ✔✔True With _____, the database is stored on a service provider's server and accessed by the client over a network, typically the Internet. - correct answer ✔✔Database as a Service To ensure reliability and integrity, SQL databases conform to four specific properties. Which of the following is NOT one of those four properties? - correct answer ✔✔currency The smallest piece of data used by a computer is a(n) _____. - correct answer ✔✔bit Today, most organizations use the traditional approach to data management, where multiple information systems share a pool of related data. - correct answer ✔✔False The ____ model database makes it easy to develop queries that involve joining two tables. - correct answer ✔✔relational The database approach to managing data is superior to the file-based approach. - correct answer ✔✔True Sometimes a database can contain "bad data," meaning incomplete, incorrect, inaccurate, or irrelevant records, which can be corrected or deleted through data cleansing. - correct answer ✔✔True Unstructured data comes from sources such as word-processing documents and scientific research. - correct answer ✔✔True

mySQL is a popular ____________. - correct answer ✔✔database program Data modeling usually involves setting a specific business goal and then analyzing the data and information needed to reach that goal. - correct answer ✔✔False _____ 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. - correct answer ✔✔Enterprise data modeling Suppose we have a table that stores student data. In that table we have a field - Student ID - that uniquely identifies each student. This field is known as the ____. - correct answer ✔✔primary key DBMSs are used primarily for modeling data. - correct answer ✔✔False A database management system (DBMS) serves as an interface between an application program and a database. - correct answer ✔✔True Suppose you wish to find what tables are in a database, what fields they have, and how they are related you would review the _____. - correct answer ✔✔schema For the ____ operation, it is required that the the two tables have a common attribute. - correct answer ✔✔join In a relational database model, the range of allowable values for a data attribute is called its _____. - correct answer ✔✔domain In the context of a database management system (DBMS), a(n) _____ interacts with other programs or applications and only indirectly interacts with people or users. - correct answer ✔✔back-end application Two sets of fields can have a common primary key. - correct answer ✔✔False

Siri, the personal assistant app on the Apple iOS operating system, is an example of _______ recognition software. - correct answer ✔✔Speech _____ is a powerful operating system originally developed by AT&T for minicomputers—the predecessors of servers that are larger than PCs and smaller than mainframes. - correct answer ✔✔UNIX Your friend has a Mac that runs OS X. If she needs to run a Windows app on it, she can set it to run Windows also. - correct answer ✔✔True One of the disadvantages of proprietary software is that ______________. - correct answer ✔✔it can take a long time and significant resources to develop the required software features If 10 users can run programs at the same time on the same computer, it is known as multi-tasking. - correct answer ✔✔false A(n) _____ is a field or set of fields in a record that uniquely identifies the record. - correct answer ✔✔primary key _____ is the process of detecting and then correcting or deleting incomplete, incorrect, inaccurate, irrelevant records that reside in a database. - correct answer ✔✔Data Cleansing Together, bits, characters, fields, records, files, and databases form the ______. - correct answer ✔✔Hierarchy of Data Carlos is working with an existing database, but he wants to eliminate some of the columns in the table to create a new, more streamlined database. He will use projection to create his new database. - correct answer ✔✔true One of the final steps in installing and using a large database involves "telling" the database management system (DBMS) the logical and physical structure of the data and the relationships among the data for each user. - correct answer ✔✔false

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 answer ✔✔data mart If an organization is taking a "store everything" approach to data, it will save all the data in its raw and unaltered form in a _____. - correct answer ✔✔data lake 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 ___________. - correct answer ✔✔data lifecycle management A collection of data fields that are all related to one object, activity, or individual is called a file. - correct answer ✔✔false Starting from monthly sales data, if you wish to get weekly sales data, use the ___ feature. - correct answer ✔✔drill down A database is a collection of integrated and related _____. - correct answer ✔✔files 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 answer ✔✔variety With _____, the database is stored on a service provider's server and accessed by the client over a network, typically the Internet. - correct answer ✔✔Database as a Service The relational model describes data using a standard tabular format; all data elements are placed in three-dimensional tables called relations, which are the logical equivalent of files. - correct answer ✔✔false A(n) ______ is an individual responsible for defining and implementing consistent principles for a variety of data issues. - correct answer ✔✔Data Administrator

An attribute is a general class of people, places, or things for which data is collected, stored, and maintained. - correct answer ✔✔false