ITSS 3300 UTD Final Exam Review with Solutions 2025

A bar code scanner would be an example of a (n): Storage device. Processing device. Input device. Output device. - -input device When a user opens a new program, the cpu may make a __________ and move a block of unused data to make room for the one just called up. 1. Bus 2. Memory swap 3. Volition 4. Data channel - -memory swap Which device listed below is an example of a processing hardware device? 1. Keyboard 2. Main memory 3. Bar code scanner 4. Microphone - -main memory A program that allows customers to modify its code in order to change its behavior or add enhancements is referred to as: - -open source _____________ software are programs that control the computer's resources. - operating system When one buys an operating system like winxp, you are actually buying a software Copyright. License. Upgrade. Version. - -license. _____________ software is processed on client computers. Server application programs Client application programs Client operating system Server operating system - -client application programs Ram is an example of: Volatile memory. ITSS 3300 ITSS 3300 Cache memory. Lcd. Hardware. Non-volatile memory. - -volatile memory __________ data and programs are stored in the hard drive - -permanent A collection of similar records is called a(n) _________________. - -table Every normalized table has A single theme. Duplicated data. Multiple topics Data integrity problems. None of the above. - -single theme _________________ is the process of converting poorly structured tables into two or more well-structured tables. - -normalization How many tables are displayed in the figure? - -3 In a database, a field is a: - -category of information ________________ is an example of a personal dbms - -access A type of management reporting system that processes data through a series of reasoning methods in order to give advice or render an opinion on a set of data. - expert system Basic operations of reporting - -1. Sorting 2. Filtering 3. Grouping 4. Calculating 5. Formatting Many users prefer to avoid database applications altogether and simply store their data in a(n): Encrypted table. Spreadsheet. Old can. Mattress. File. - -spreadsheet Sql stands for - -structured query language Sql is a(n) - -query language ITSS 3300 ITSS 3300 ___________________ is a popular enterprise dbms. Paradox Foxpro Db2 Access - -db2 Which of the following is not a component of a database? Lists Fields Table Records - -lists A _________________ is the smallest piece of data. - -byte A(n) ______________________ connects computers at different geographic locations. - -wan __________ consist of computers at a single organizational site that are connected via unshielded twisted pair (utp) or optical fiber cables - -lans If you frequently transfer large data files between nodes on a network, which of the following networks would be the best choice? Ethernet Wireless Powerline Dial-up - -ethernet A(n) ______________________ uses the internet or other internet to create the appearance of private, point-to-point connections. - -vpn Vpn codes or __________ messages that are transmitted. - -encrypts Because of problems with operational data, many organizations choose to extract operational data into a(n): . - -data warehouse ________________ tools are programs that read data from a variety of sources, process that data, and produce and deliver formatted reports to users. - -reporting Sometimes, large organizations break out ____________________ from their data warehouses so they can be used for a specific functional area of the organization like marketing or finance. - -data marts A column or group of columns that identifies a unique row in a table. - -primary key ITSS 3300 ITSS 3300 Column or group of columns used to represent relationships - -foreign key View data; insert new, update existing, and delete existing data - -forms The cloud is - -elastic leasing of pooled computer resources over the internet Pooled - -many different organizations share same physical hardware through virtualization Rfm analysis ranks customers by considering the recency, frequency, and _________________ of their orders. - -monetary When a decision tree classifies customers into good and bad prospects for future sales, a company should be careful not to _______________ the bad prospects based on this. - -neglect A data warehouse also contains a special database that stores the ________________, which records its source, history, format, and constraints - -metadata __________________ is a technique that looks for groups of entities that have similar characteristics. - -cluster analysis All the words ever spoken by human beings could be stored on five ________________ of storage capacity .petabytes Megabytes. Exabytes Terabytes. Gigabytes. - -megabytes Decision trees are good at sorting through lots of data and making binary: Classifications. Projections. Analysis. Forecasts. Decisions. - -classifications Identifies a particular device on public internet - -public ip addresses Program for creating, processing, and administering a database. A large complex program that is licensed like an operating system. - -dbms An international standard language for proc