AIS exam #1 Questions and Answers 100 % correct

AIS exam #1 Questions and Answers 100 % correct This is a collection of data items organized as a set of formally-described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables. a. Dataflow diagram b. Matrix c. data warehouse d. relational database d. relational database Data differ from information in which way? a. Information is data organized to provide meaning b. Data are meaningful bits of information c. There is no difference; the two terms are used synonymously d. Data are facts about a sale a. Information is data organized to provide meaning As a new sales manager, Sylvia is processing the monthly sales report numbers to determine the top three salespersons of the year. At which stage of the DIKW hierarchy is Sylvia working? a. the revenue cycle b. database c. Information d. wisdom c. Information Which of the following is not a characteristic that makes information useful? a. It is inexpensive b. It is relevant c. It is timely d. It is reputable a. It is inexpensive In which cycle does a company ship goods to customers? a. production cycle b. financing cycle c. revenue cycle d. expenditure cycle c. revenue cycle Which of the following is a function of an AIS? a. Reducing the need to identify a strategy and strategic position. b. Allocating organizational resources. c. Automating all decision making d. Transforming data into useful information d. Transforming data into useful information Which of the following is not a step in the data processing cycle? a. Data processing b. Data survey design c. Data input d. Data storage b. Data survey design Which of the following is not an advantage of an ERP system? a. Standardization of procedures and reports b. Simplicity and reduced costs c. Better access control d. Improved monitoring capabilities b. Simplicity and reduced costs How does the chart of accounts list general ledger accounts? a. Alphabetical order b. The order in which they appear in financial statements c. Chronological order d. Size order b. The order in which they appear in financial statements Which of the following is a primary activity in the value chain? a. Post-sales service b. Accounting c. Human resource management d. Purchasing a. Post-sales service In the value-chain concept, upgrading IT is considered what kind of activity? a. structured technical activity b. support activity c. primary activity d. service activity b. support activity The term data generally refers to: a. raw facts about concrete or abstract entities and events b. information c. an excel spreadsheet d. tables of numbers a. raw facts about concrete or abstract entities and events A database management system is a. a collection of databases in a company b. a software system that facilitates the process of defining, constructing, manipulating and controlling a database for various applications. c. a cloud-based service used to implement Accounting Information Systems d. a large digital storage device (e.g., disk drive) on which a database is stored. b. a software system that facilitates the process of defining, constructing, manipulating and controlling a database for various applications. The teacher of a class of third graders records the height of each student. Indicate which level of measurement is being used in this scenario a. Nominal b. Ratio c. Ordinal d. Interval b. Ratio "Customer satisfaction" measured on a 3-point scale (negative, neutral, positive) is an example of an attribute/variable that is a. discrete, qualitative, ordinal b. discrete, quantitative, interval c. continuous, quantitative, nominal d. continuous, qualitative, ratio a. discrete, qualitative, ordinal In a database table, the field or fields that uniquely identify a record is referred to as: a. variable key b. Foreign key c. Primary key d. schema c. Primary key A database query is a. data extracted from AIS transactions b. a question you pose to the database system c. a question you bring to the attention of management d. an internal control feature of any database b. a question you pose to the database system Which of the following is not a property of the mathematical concept of a "set": a. there is a foreign key in each element that refers to the primary key of that element b. all elements on the set are distinct c. there is no order to the set of elements in a set d. there is no relationship among elements in a set other than membership in the set a. there is a foreign key in each element that refers to the primary key of that element The term Data Warehouse is used to refer to: a. a system for processing daily business transactions b. any collection of documents, spreadsheets, and videos c. an enterprise-level archival database designed and fine-tuned for analysis and decision making d. the process of data capture and validation c. an enterprise-level archival database designed and fine-tuned for analysis and decision making Unlike traditional databases, a data warehouse is a. is an example of online transaction processing system b. stores only current (up-to-date) data c. is designed with a focus on efficiency for operational support d. tends to have a broad, enterprise-wide scope d. tends to have a broad, enterprise-wide scope What is SQL? SQL is a declarative query language. Unlike procedural query or programming languages, you do not tell the system/database how to to get the data you want; you only specify what you want. What is each row in a relational database called? a. key b. tuple c. attribute d. relation b. tuple Which of the following attributes would most likely be a primary key? a. supplier zip code b. supplier account balance c. supplier name d. supplier number d. supplier number To select records with strings that match a wildcard value, use the following keyword in your filter: a. EQUALS b. LIKE c. BETWEEN d. MATCH b. LIKE Which of the following is not a basic requirement of a relational database? a. Primary keys cannot be null b. Every column in a row must be single valued c. All of the requirements listed (above) are basic requirements d. All nonkey attributes in a table should describe a characteristic about the object identified by the primary key e. Foreign keys, if not null, must have values that correspond to the value of some other primary key in another table c. All of the requirements listed (above) are basic requirements Which of the following clauses properly filters the rows in an (SQL) query to values greater than 3 in field Field4 from Table3? a. WHERE Table3.Field4 3 b. SELECT Table3.Field4 3 c. WHERE Field4.Table3 3 d. FROM Table3.Field4 3 a. WHERE Table3.Field4 3 The constraint that all foreign keys must have either null values or the value of a primary key in another table is referred to as which of the following? a. foreign key rule b. referential integrity rule c. unique values rule d. entity integrity rule b. referential integrity rule The relational data model portrays data as being stored in ________. a. transactions b. files c. spreadsheet d. tables d. tables Web servers and web browsers communicate using an application-level protocol called: a. TCP/IP b. HTML c. Ethernet d. Wi-Fi e. HTTP e. HTTP Online portals, like Yahoo, derive most of their revenue from a. subscriptions to e-mail services b. advertising c. fees from premium content d. retail sales b. advertising The internet is a a. one big network owned and managed by a single organization b. is a term used to refer to the world wide web c. is a secured private network d. a network of networks d. a network of networks When connected directly to the internet, a computer/device has a globally unique address called the: a. IP address b. domain name c. Web address d. TCP address a. IP address On the internet, a domain name server a. maps domain names to IP addresses b. maps IP addresses to wifi addresses c. is a centralized database on internet addresses d. is a distributed web content service a. maps domain names to IP addresses On the web, the term URL refers to a. an application-level protocol b. Under-represented Resource Lines c. Uniform Resource Locator d. Unrecognized Return Location c. Uniform Resource Locator With XBRL, a. the formatting of content on the www is specified b. the syntax and semantics of messages on the web is specified c. the layout of financial reports is indicated d. financial data is encoded/tagged to make it machine readable d. financial data is encoded/tagged to make it machine readable On the internet, a "web service" a. a protocol that governs communication on the internet b. any website on the www c. a self-contained function/procedure that is/application remotely invoked over the web d. any network of machines c. a self-contained function/procedure that is/application remotely invoked over the web On a computer network, a router is a. a device that implements a special protocol which ensures proper communication between applications. b. software that provides for secure communication on the internet. c. a software/hardware device that interconnects two networks. d. a device that amplifies the signal on a wired or wireless network. c. a software/hardware device that interconnects two networks.