Quiz7 Studying Sheet for IT learners quiz description document very understandable PDF

Preview

Summary

Studying Sheet for IT learners quiz description document very understandable MyLab IT course it is useful for learners especially beginners...

Description

1. A database is a collection of related data that can be stored, sorted, organized, and queried. 2. If a school keeps two lists, one for student registration and one for student financial information, both containing name and address information, this is an example of data redundancy. 3. Data integrity means that the data contained in a database is accurate and reliable. 4. Data centralization helps to ensure data integrity by maintaining information in only one place. 5. Normalization is used to ensure that data is organized most efficiently in a database. 6. Relational databases are the most commonly used electronic databases. 7. A one-to-one relationship indicates that for each record in a table, there is only a single corresponding record in a related table. 8. Nontraditional data in object-oriented databases such as audio clips, video clips, pictures, and very large documents are called unstructured data. 9. Data in a multidimensional database is organized in a cube format. 10. In a database, the term field is synonymous with a category of data. 11. In a database, a group of related records is referred to as a(n) table. 12. In a Microsoft Access database, something like the Gettysburg Address would be stored in a(n) long text field. 13. You can set a default value, which is automatically displayed in a field unless the user enters something different. 14. Which of the following is a likely primary key in a student information record? Student id number 15. Referential integrity means that for each value in the foreign key of one table, there is a corresponding value in the primary key of another table. 16. A range check would be used in a field to restrict the fines for speeding violations so that they fall between $50 and $250. 17. A(n) completeness check determines whether a required field such as LastName was filled in. 18. A consistency check compares the values of data in two or more fields to see whether those values are reasonable. 19. You would use a filter in a database to temporarily display records of residents for the city of Boston. 20. A(n) query is a way of retrieving information from one or more tables that defines a particular subset of data. 21. A select query displays a subset of data from a table (or tables) based on the specified criteria. 22. SQL uses relational algebra to extract records from a database by using English-like expressions that have variables and operations. 23. Exporting involves taking data from your database and putting it into an electronic file in a format that another external application or database can recognize. 24. A data warehouse is a large-scale collection of data that contains and organizes all of an organization's data in one place. 25. Data staging consists of all of the following steps, EXCEPT ________. mining the data 26. Big data analytics is usually associated with ________ services. data warehouse 27. In a transaction-processing system (TPS), if the TPS database can be queried and updated while the transaction is taking place, this is called ________ processing. real-time 28. Management information systems (MIS) provide reports called ________ reports, which show conditions that are unusual or need attention from users of the system. exception 29. Siri, the personal assistant application on Apple's iPhone is an example of a ________. natural language processing (NLP) system 30. Artificial intelligence is the branch of computer science that attempts to create computers that think like humans. 31. A database that allows data to be maintained in a single location provides data centralization 32. In a relational database, a(n) one-to-many relationship indicates that a record that appears only one time in a table, may appear multiple times in a related table.

33. Object-oriented databases are better than relational databases at handling unstructured data such as audio clips, video clips, and pictures. 34. A(n) multidimensional database stores data in more than two dimensions, as opposed to relational databases, which store data in two-dimensional tables. 35. A data dictionary is also referred to as a(n) database schema. 36. A group of related records is called a(n) table. 37. Data that describes other data is called metadata 38. In a database, another term for a table is a(n) file 39. In a Microsoft Access database, an active web page, e-mail address, or existing file is stored as a(n) hyperlink field. 40. When working with a relational database, each record must have a(n) primary key field, which has a value unique to that record. 41. Referential integrity means that for each value in the foreign key field of a table, there is a corresponding value in the primary key of the related table. 42. A(n) input form provides a view of data fields to be filled in with appropriate labels to assist a user in entering data into the database. 43. Data validation is the process of ensuring that the data entered into a field meets specified guidelines. 44. A field constraint is a property that must be met before an entry can be accepted into the field. 45. To temporarily display records from a single table that match certain criteria, you would use a(n) filter 46. When using SQL, a(n) join query is used to extract data from two or more tables. 47. The data in a data warehouse is time-variant meaning it does not all pertain to one period in time. 48. Clickstream data is information about how users of a company's website move through the web pages. 49. When creating a data warehouse, data staging is the process that extracts data from source databases, reformats the data, and stores them in the warehouse. 50. A(n) data mart is created from a large data business warehouse to analyze a single component of the business. 51. Data mining is used to analyze large amounts of data and identify unseen patterns or trends. 52. A business that updates its records all at once at the end of the business day uses batch processing. 53. A(n) summary report provides a consolidated picture of detailed data and usually includes some calculation or visual displays of information and is generated by a MIS. 54. A(n) expert system tries to replicate the decision-making processes of human experts to solve specific problems. 55. Data redundancy ensures that the data contained in the database is accurate and reliable. F 56. Normalization means that there are no data entry errors in a database. F 57. In a relational database, when two tables have a common field, the link between the tables is known as a hyperlink. F 58. A street address field is an example of a field that should have a default value. F 59. A group of related records is called a table. T 60. In an employee database, an employee's ID number, last name, first name, company position, address, city, state, and Zip Code make up a record. T 61. When using Access, the text of the Declaration of Independence would be stored in a short text field. F 62. Employees' last names would usually make an appropriate primary key field. F 63. A database schema defines the name, data type, and length of each field in the database. T 64. Most databases can import electronic data from other software applications. T 65. A filter is limited to extracting data from a single table. T 66. Small slices of a data mart are called data warehouses. F 67. The information in a data mart spans an entire enterprise. F

68. Data mining analyzes and investigates large amounts of data with the intention of discovering significant patterns or trends. T 69. Real-time processing means that transactions are updated when they occur. T 70. A summary report generated by a MIS provides a list of the transactions that occurred during a specified time period. F 71. field a category of information in a database database a collection of related data that can be stored, sorted, organized, and queried record a group of related fields table a group of related records primary key a field that has a value unique to each record 72. data mining process by which great amounts of data are analyzed and investigated expert system software that tries to replicate the decision making of human specialists data mart small slice of a data warehouse artificial intelligence attempts to create computers that think like humans data staging includes transforming data to fit into a data warehouse 73. office support system (OSS) assists employees in day-to-day tasks and communication natural language processing (NLP) communicates with computer systems using a natural spoken or written language management information system (MIS) provides managers with timely and accurate information decision support system (DSS) helps managers develop solutions for specific problems enterprise resource planning (ERP) system software system that integrates multiple system data sources and ties together the various processes of an organization 74. data warehouse large-scale collection of data batch processing transaction data that are processed all at once relational database organizes data into various tables based on logical groupings real-time processing when a database is queried and updated as a transaction is taking place data dictionary defines the name, data type, and length of each field in a database 75. alphabetic confirms that only textual characters are entered into a field numeric confirms that only numbers are entered into a field completeness ensures that all required fields have data entered into them consistency compares values in two or more fields to see whether the values are reasonable range ensures data entered into the database fall within a certain set of values 76. Which of the following applications is not included with Microsoft Office? Photoshop 77. The ________ identifies the current file name and the application in which you are working. title bar 78. Microsoft Office's ________ box enables you to search for help and information about a command or task. Tell me what you want to do 79. A(n) ________ is a custom program or additional command that is installed to extend the functionality of a Microsoft Office program. add-in 80. The figure shown above shows examples of ________. templates 81. Clicking the icon shown in the figure above, activates the________ feature. Format Painter...