CIS 2200 CHAPTER 6 BARUCH COLLEGE QUESTIONS AND ANSWERS|GUARANTEED SUCCESS

A​ ________ is the smallest component in the computer system data hierarchy. A. field B. record C. file D. bit E. byte D. bit A​ ________ is a component in the computer system data hierarchy that includes content such as Student ID​ 100, Course IS​ 101, and Grade A. A. record B. byte C. bit D. field E. file D. field A​ ________ is a component in the computer system data hierarchy that consists of multiple records of the same type. A. bit B. record C. field D. file E. byte D. file A​ ________ is a component in the computer system data hierarchy that represents an ASCII character like a​ letter, a​ number, or another symbol. A. record B. bit C. field D. file E. byte E. byte A grouping of characters into a word or group of words is called​ a(n) ________. A. bit B. record C. file D. field E. byte D. field A​ person, place, or thing which is stored in a database is called​ a(n) ________. A. object B. bit C. file D. entity E. attribute D. entity The coupling of files used to store information and the application program that updates and maintains those files is called​ ________. A. enterprise computing B. ​program-data independence C. ​client/server computing D. ​program-data dependence E. data redundancy D. ​program-data dependence Data is considered to be​ ________ when the same attribute has different values. A. cleansed B. safe C. redundant D. inconsistent E. dependent upon a program D. inconsistent A record describes​ a(n) ________ which is a​ person, place,​ thing, or event on which we store and maintain information. Each characteristic or quality describing a particular​ ________ is called​ a(n) ________. A. ​file; file; field B. ​entity; entity; attribute C. ​field; field; byte D. ​bit; bit; byte E. ​entity; entity; field B. ​entity; entity; attribute The​ sales, manufacturing, and inventory systems at a bicycle manufacturer use different codes to represent bicycle frame sizes. For​ example, in the sales​ system, a large bike frame is coded with​ "L", while the inventory system codes a large bike frame with​ "LG". This situation illustrates​ ________. A. duplicate data B. ​re-indexed data C. data inconsistency D. coarse data E. ​non-indexed data C. data inconsistency ​A(n) ________ is a collection of data organized to serve many applications efficiently. A. hard drive B. email server C. word processor D. information system E. database E. database Microsoft SQL Server is a​ ________ for large mainframes and midrange computers. A. MongoDB B. SimpleDB C. NoSQL D. distributed database E. relational DBMS E. relational DBMS A​ ________ is software that enables an organization to centralize​ data, manage them​ efficiently, and provide access to the stored data by application programs. A. systems process B. spreadsheet C. system network D. word processor E. database management system​ (DBMS) E. database management system​ (DBMS) ​A(n) ________ database makes it possible to store information across millions of machines in hundreds of data centers around the​ globe, with special​ time-keeping tools to synchronize the data and ensure the data are always consistent. A. NoSQL B. distributed C. relational D. SQL E. simple B. distributed The field that uniquely identifies a row in a relational database table is called a​ ________. A. primary key B. foreign key C. null value D. column E. data definition language A. primary key Another name for a database field is​ a(n) ________. A. row B. attribute C. database D. tuple E. record B. attribute Another term for a database row is​ a(n) ________. A. field B. attribute C. record D. spreadsheet E. database C. record A​ ________ provides the link from one table to another​ table's primary key. A. referential key B. data key C. primary key D. foreign key E. surrogate key D. foreign key Another term for a key field is a​ ________. A. primary key B. null key C. data key D. surrogate key E. foreign key A. primary key An emerging​ non-relational database management system is called​ ________. A. a relational database B. Oracle C. NoSQL D. XBRL E. an​ information-base C. NoSQL The SQL​ ________ statement allows you to combine two different tables. A. JOIN B. ORDER BY C. COMBINE D. GROUP BY E. SELECT A. JOIN SQL stands for​ ________. A. Structured Question Language B. Structured Questioning Language C. Structured Query Language D. Streamlined Question Language E. Special Question Language C. Structured Query Language ​Microsoft's DBMS that includes​ built-in report generation and reporting is called​ ________. A. SQL Server B. Access C. MySQL D. Spreadsheets E. DB2 B. Access Which of the following is a distributed database technology that enables firms and organizations to create and verify transactions on a​ peer-to-peer network nearly instantaneously without a central​ authority? A. NoSQL B. Blockchain C. Cloud Spinner D. DB2 E. MySQL B. Blockchain