MANAGEMENT OF DATA Straighterline IT101 Information Technology Fundamentals Graded Topic Test (New Version August 2024)

MANAGEMENT OF DATA Straighterline IT101 Information Technology Fundamentals Graded Topic Test (New Version August 2024) We are a team of experts offering course/class attendance (including final proctored exams!!) for all Straighterline, Online ATI, HESI, NCLEX, Portage Learning, Sophia, Nursing, Business etc courses. We also write essays, discussion posts, research papers and school assignments. Should you need any of these services, Contact us via email: or : +1 (540) 753-5914. Guaranteed Passing! Step 1 of 1 Question 1 of 27 Question 1 This is not a form; we suggest that you use the browse mode and read all parts of the question carefully. How many data types would be required to store the following entry in a database? 3.87 Two data types would be required. One data type is needed for the integer portion of the number, and another data type, called floating point, is needed for the decimal portion of the number Two data types would be required. Because the number has a decimal point, both numerical data and symbolic data need to be used. One data type would be required. A floating point data type would be used because the number includes a decimal. Only one data type is needed, but the whole number part and the decimal part will be stored in separate fields as separate, but associated, entries. Correct. Question 2 of 27 Question 2 This is not a form; we suggest that you use the browse mode and read all parts of the question carefully.A certain charitable organization works with underprivileged children in local communities. As part of their company policy, all volunteers must answer certain personal questions as part of a background check. One section of the personal information form is a series of questions about whether certain factors would make the volunteer ineligible to work with . The volunteer is expected to answer these questions with a simple “yes” or “no.” What data type would be most effective in storing the answers to these questions? string data number data Boolean data any of the above Correct. Question 3 of 27 Question 3 This is not a form; we suggest that you use the browse mode and read all parts of the question carefully. It is most important to ask which of the following questions before designing a database? What is the purpose of the database, and how will it be used? Will the data be numbers, words, or other data types? From where will the data that will be stored in the database be gathered? Approximately how many entries will be made in the database? Correct. Question 4 of 27 Question 4This is not a form; we suggest that you use the browse mode and read all parts of the question carefully. What type of database allows new tables to be created out of information that is requested in a search of the database? relational database flat file database hierarchical database all of the above Correct. Question 5 of 27 Question 5 This is not a form; we suggest that you use the browse mode and read all parts of the question carefully. What type of database organizes data in a tree-like or organizational chart type structure? relational database flat file database hierarchical database none of the above Correct. Question 6 of 27 "Fill in the blank" question: select the correct answer. - Question 6 The input and select elements may be inline with important contextual information.This is not a form; we suggest that you use the browse mode and read all parts of the question carefully. If a relation contains five records for individual songs and each of the records has data entered for the artist, duration, and release year, these three categories are attributes attributes of the records. Response for: undefined Correct. Question 7 of 27 Question 7 This is not a form; we suggest that you use the browse mode and read all parts of the question carefully. Which of the following is a common example of a type of software that uses flat file structuring? word processing software inventory databases for large corporations Microsoft Access spreadsheet software Correct. Question 8 of 27 "Fill in the blank" question: select the correct answer. - Question 8 The input and select elements may be inline with important contextual information.This is not a form; we suggest that you use the browse mode and read all parts of the question carefully. Alicia is working with a database relation that contains data about the litters of puppies that her dogs have had over the years. Each row in the relation represents a litter of puppies and contains information about the number of puppies, when they were born, and how much they weighed at 6 weeks of age. In such a relation, each row of data about a litter of puppies is known as a record record . Response for: undefined Correct. Question 9 of 27 Question 9 This is not a form; we suggest that you use the browse mode and read all parts of the question carefully. Kevin is doing some unique database research. He wants to evaluate whether there is any significant connection between the color of an individual’s car and how likely the individual is to receive a speeding ticket. He has access to databases with all the information he needs about individuals and their vehicles, but the color of the vehicle is in the vehicle registration database relation while the ticket information is in a separate database relation for traffic violations. Fortunately, both relations include the unique vehicle identification number (VIN) as the primary key. What query tool can he use to return information from both relations at the same time so that he can see the vehicle color information alongside of the ticket information in the same table? sort join comparison restrictionCorrect. Question 10 of 27 Question 10 This is not a form; we suggest that you use the browse mode and read all parts of the question carefully. When a join operation is used in a query, the records from different relations must be associated through the use of a field with unique values for each and every record. What is the name of that field? PIN attribute record identifier primary key Correct. Question 11 of 27 Question 11 This is not a form; we suggest that you use the browse mode and read all parts of the question carefully. Which task is not associated with managing a DBMS? account creation installation performance analysis All of these are associated with managing a DBMS. Correct. Question 12 of 27Question 12 This is not a form; we suggest that you use the browse mode and read all parts of the question carefully. Which of the database administrator’s roles requires a special set of skills that includes database modeling, schema development, normalization, and performance tuning? ensuring database security professional development and continued education server management application design and development Correct. Question 13 of 27 "Fill in the blank" question: select the correct answer. - Question 13 The input and select elements may be inline with important contextual information. This is not a form; we suggest that you use the browse mode and read all parts of the question carefully. One of the main purposes of a BI system is to improve the timeliness and quality timeliness and quality of the information that is used to make strategic decisions. Response for: undefined Correct. Question 14 of 27 Question 14This is not a form; we suggest that you use the browse mode and read all parts of the question carefully. The supermarket where Victor works as a manager collects large amounts of data about sales, inventory, customers, and other related aspects of their operations. They have invested in an advanced database system that uses product barcodes to track sales and inventory. They have also purchased an additional software application program that tracks customer purchases on an individual basis using loyalty cards at the checkout locations. They also have separate records of all the promotions and sales they have implemented over the years. How do these data collection processes relate to the potential implementation of a BI system? A BI system would be very helpful because it would be able to integrate these various sources of data into one database that could be organized and interpreted much more usefully. They make the importance and value of a BI system somewhat less significant, though it could still be useful. With all the data sources already present, another BI system would only add extra confusion to the situation. Correct. Question 15 of 27 Question 15 This is not a form; we suggest that you use the browse mode and read all parts of the question carefully. Evan wants to integrate the data from numerous databases into a single data warehouse. He recognizes that he will need to develop a system that can extract data from many different sources and then load that data into the data warehouse. What other important step does he need to consider and develop for this process? The data must be encrypted so that it can be transferred and stored securely. The data extracted from the various sources must be formatted consistently to fit the format of the warehouse. The data needs to be interpreted and classified according to its priority and value.The data must be sorted so that unhelpful or inaccurate data is removed. Correct. Question 16 of 27 Question 16 This is not a form; we suggest that you use the browse mode and read all parts of the question carefully. When data from a data warehouse is utilized and processed, what useful step is often done with the resulting information? The resulting information is discarded. The new information replaces the older data, thereby saving much storage space. The data warehouse analyzes the resulting information and provides multiple suggestions for actionable responses. It is often stored back in the data warehouse as data for future use. Correct. Question 17 of 27 Question 17 This is not a form; we suggest that you use the browse mode and read all parts of the question carefully. Answering which of the following questions would be enabled by OLAP software? If the unemployment rate decreases 1% and the housing market increases by 2%, how will demand for our construction services be affected? How many sales representatives are active in a certain geographical sales zone? How many units of a certain product were sold last month? Which color of the product was in greatest demand during the past year?Correct. Question 18 of 27 Question 18 This is not a form; we suggest that you use the browse mode and read all parts of the question carefully. A candy store has records of all the different sales it has made over the past three years. The types, colors, quantities, and names of the candies sold each day are recorded. The owner of the store uses OLAP operations to show only the colors of candies purchased during the month of December over the past three years. He plans to purchase greater quantities of those colors during the next December period. What OLAP operation was used in this research? pivoting dicing isolating slicing Correct. Question 19 of 27 Question 19 This is not a form; we suggest that you use the browse mode and read all parts of the question carefully. What type of data processing is defined by the fact that it takes place in real time? SQL queries OLAP batch processing OLDPCorrect. Question 20 of 27 Question 20 This is not a form; we suggest that you use the browse mode and read all parts of the question carefully. What type of processing takes place based on the occurrence of a certain event rather than a user command or the arrival of a scheduled point in time? OLDP OLAP event-driven processing batch processing Correct. Question 21 of 27 Question 21 This is not a form; we suggest that you use the browse mode and read all parts of the question carefully. What is needed in order for an ODBC compliant application to communicate understandably with a database? a database driver a database server a database query language such as SQL all of the above Correct. Question 22 of 27Question 22 This is not a form; we suggest that you use the browse mode and read all parts of the question carefully. JDBC is a driver used for applications written in what language? Java Oracle SQL HTML Correct. Question 23 of 27 Question 23 This is not a form; we suggest that you use the browse mode and read all parts of the question carefully. What change in how applications handle data has provided the advantage that changes can be made to the data without the need to rewrite the application? Applications today do not store data themselves, but rather the data is stored in separate databases. Applications today are able to store their own data rather than export it for storage elsewhere. Applications today are separated from data and do not use it. Applications are now able to interact with relational databases through drivers such as JDBC. Correct. Question 24 of 27 Question 24This is not a form; we suggest that you use the browse mode and read all parts of the question carefully. What basic SQL command can be used to specify that the query should only return data from records where the field “last_name” begins with a certain letter? match from where select Correct. Question 25 of 27 Question 25 This is not a form; we suggest that you use the browse mode and read all parts of the question carefully. Which of the following data manipulation techniques will allow for modifications to columns in an existing table? UPDATE command INSERT INTO command ALTER TABLE command ORDER BY command Correct. Question 26 of 27 Question 26 This is not a form; we suggest that you use the browse mode and read all parts of the question carefully. What would the following table modifying command do?ALTER TABLE students ADD homePhone STRING(10) add a students field to an existing table add a new field to the table students add a new student to the table students specify the home phone numbers of particular students from a string file Correct. Question 27 of 27 Question 27 This is not a form; we suggest that you use the browse mode and read all parts of the question carefully. SQL commands can be used for which of the following database language types? DDL DML DQL all of the above