WGU/DataBase - Practice Test ?'s Questions 100% correct, expert verified answers

WGU/DataBase - Practice Test ?'s Questions 100% correct, expert verified answers Which set of results should a company expect from implementing a business intelligence system ? Increased profitibility and increased throughput. Which issue is focused on the loading component of extract, transform, load (ETL) ? refreshing volume and frequency Where does affinity occur in data mining ? Between Objects. Monitor Which three kinds of rules for referential integrity are provided by modern relational database management systems ? Insert, Delete, Update Sales data, detailing the customer names, products sold, and salespersons, is kept in a data base. Which kind of data in this database would qualify as intersection data related to both the product and salesperson entities ? Customer Names What is necessary for a primary key in one relation of a database to match with its corresponding foreign key in another relation of the same database ? A Domain Of Values What uniquely identifies each entity in a collection of entities but is not the primary key ? Alternate Key The What is a term for a set of columns in a table that can uniquely identify any record in that table without referring to other data ? Candidate Key What is a key difference between the DISTINCT and ORDER BY statements, in SQL SELECT commands? ORDER BY movies the presentation of data results DISTINCT filters data results Which SQL statement alphabetizes customer names within the same satellite-office city ? BY SATCITY, CUSTNAME; ORDER The given SQL statement is intended to query how many books there are with at least 800 pages from publishers in Los Angeles, United States. SELECT COUNT (*) ? WHERE PUBLISHER.PUBNAME = BOOK.PUBNAME AND CITY='Los Angeles' AND COUNTRY = 'United States' AND PAGES =800; With which line should the question mark in this statement be replaced ? PUBLISHER,BOOK Where does affinity grouping occur in data mining ? FROM Between Objects What is the term for the value of one particular attribute associated with a specific single value of another attribute ? Functional Dependency What is necessary for a Primary Key in one relation of a database to match with its corresponding Foreign Key in another relation of the same database ? A Domain Of Values What is an important aspect of "referential integrity" ? on values in another relation Reference to data in one relation is based What uniquely identifies each entity in a collection of entities but is not the primary key ? The Alternate Key The given SQL statement is intended to list the names of the products of which salesperson Fox has more than 500 units. SELECT PRODNAME FROM SALESPERSON,SALES,PRODUCT ? ? AND SPNAME='Fox' AND QUANTITY500; Which set of lines should replace the question marks to make this statement work ? SALESPERSON.SPNUM=SALES.SPNUM AND SALES.PRODNUM=PRODUCT.PRODNUM