CIS 205 Introduction to Information Systems and Technologies L. Multiple Choice
ID: 382820 • Letter: C
Question
CIS 205 Introduction to Information Systems and Technologies L. Multiple Choice Choose the one best answer) ) models data into 2-dimensional tables (a) Data warehouses (b) Databases (c) Relational warehouses (d) None of the above 2) Acondition in an Access query is also known as a (a) terms (b) requirements (c) criteria (d) none of the above 3) Access records are stored directly in well-designed . (a) warehouses (b) tables (c) forms (d) None of the above 4) A company with, for example, customers, inventory, and transactions would representing 3 have 3 a) Tables, entities b) Entities, records c) Tables relationships d) None of the above A data warehouse is needed to store a) Multiple databases b) A company's inventory records c) A company's employee records 5) d) All of the above 6) Tables, forms and reports are examples of database a) files b) fields c) objects d) None of the above Big data' makes it advisable for companies to have a) Data depots 7) b) Data warehouses c) Data storehouses d) None of the aboveExplanation / Answer
A data warehouse uses snowflake schema to normalize data into multiple tables.Hence, due to normalization the redundancy is reduced and it is easy to manage and store. Answer is (a) Data warehouses
A condition in an Access query is also known as a criteria. This can be executed in MS-Access by opening the query in Design view. Here select the criteria row for the required field to add the criteria, click on enter and Run to check the data. Answer is ( c) criteria
Access records are stored directly in well designed tables and these are important to maintain data integrity with long term goal to manage database with good performance. Answer is (b) tables
While designing the database information, and this information is divided into subjects or major entities in turn every subject converts into a table. Hence, answer is (a)
A data warehouse is a centralized place for data storage of a big organization. To perform analysis and data report generation. It uses multiple datasets from external and operational databases to give a meaningful data used for organizational or business decisions. Answer is (d)
Tables, queries, forms and reports are database objects. Tables are used to store data, retrieve by using query, forms to view the data, and finally report out to print. Hence, answer is ( c)