Quiz
C175 - Practice Test
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (49)
1What is a broad definition of data?
- ANumbers that are captured on digital media
- BRaw facts that are captured on printed or digital media
- CAlphanumeric combinations that can be captured on media that a computer can read
- DAny information that can be transferred from print to digital
2What is data?
- AFacts that have been organized in a meaningful way
- BFacts that are the result of a query of a database system
- CFacts that are collected and stored in a database system
- DFacts that have been processed and used for decision making
3What is a determining characteristic of unstructured data?
- AIt does not allow copying and pasting.
- BIt is easy to query and retrieve by business applications.
- CIt does not follow a data model.
- DIt is stored in rows and columns.
4Which item represents unstructured data?
- AA
- BB
- CC
- DD
5Which is true about flat files?
- AThey contain no internal hierarchical organization.
- BThey have a limit of 256 records.
- CThey can only contain two-dimensional data.
- DThey are always encrypted.
6Which technology has no internal hierarchy?
- AFlat files
- BHeap files
- CHashed tables
- DRelational databases
7How were data retrieved before database management systems?
- ARandomly from linked files
- BSequentially from simple files
- CUsing set operations on complex files
- DUsing relationships between logical entities
8What is the uniquely identifiable element about which data can be categorized in an entity-relationship diagram?
- AEntity types
- BPrimary keys
- CUnary relationships
- DIntersection data points
9Which classification is correct for the box marked “Quantity” in the given entity-relationship diagram?
- AQuantity data
- BModality data
- CIntersection data
- DProduct sales data
10Which data classification is an entity?
- AEvent
- BDuration
- CDirections
- DAttendance
11What is the entity-relationship diagram about a car rental agency showing?
- AAn agency’s cars were provided by multiple manufacturers.
- BOne manufacturer created at least one of the agency’s cars.
- CThe model, year, and class of the car are part of the primary key.
- DThe manufacturer maintains database records for its sales representatives.
12A salesperson is authorized to sell 12 products; a product can be sold by 10 salespersons.
Which kind of binary relationship is described in this example?- AOne-to-one
- BOne-to-many
- CMany-to-many
- DAssociative
13Which relationship does the cardinality in the diagram represent?
- AMany customers to many products
- BOne customer to many products
- COne customer to many product numbers
- DOne customer to one product number
- EMany customers to one product
14How is the cardinality of the customers misrepresented?
- AThere is one customer number, but the cardinality indicates many customers.
- BThere are many customers, but the cardinality indicates one customer.
- CThere is more than one salesperson, but the cardinality indicates multiple salespersons.
- DThe cardinality of the salesperson number and the customer number do not match.
15How is the cardinality of the customers misrepresented?
- AA maximum of one customer
- BA maximum of many customers
- CA minimum of zero customers
- DA maximum of zero customers
16What is the modality of the product?
- ATwo
- BAt least one
- CTwo or more
- DDependent on the quantity
17Which kind of relationship does this diagram depict?
- AUnary one-to-one
- BBinary one-to-one
- CUnary one-to-many
- DBinary one-to-many
18Which kind of relationship does this diagram depict?
- AUnary one-to-many
- BBinary one-to-many
- CUnary many-to-many
- DBinary many-to-many
19Which three kinds of rules for referential integrity are provided by modern relational database management systems?
Choose 3 answers- ASort
- BInsert
- CQuery
- DDelete
- EUpdate
- FRetrieve
20What is an important aspect of “referential integrity”?
- APrimary keys refer to data in particular relation.
- BReference points are placed by the database in each record during backups.
- CThe relationships between entities and attributes are called referrals.
- DReference to data in one relation is based on values in another relation.
21Refer to the given SQL statement.
SELECT SPNUM, SPNAME
FROM SALESPERSON
What is the correct line to add to the end of this statement to find salespersons with a commission percentage of 15?- A* COMMPERCT=15;
- BIF COMMPERCT=15;
- CAND COMMPERCT=15;
- DWHERE COMMPERCT=15;
22Refer to the given SQL statement.
SELECT COMMPERCT, YEARHIRE
FROM SALESPERSON
WHERE SPNUM=22;
How should this statement be altered to retrieve the entire record instead of the commission percentage and year of hire?- AReplace WHERE SPNUM=22; with WHERE SPNUM=*
- BReplace COMMPERCT, YEARHIRE with an asterisk
- CReplace COMMPERCT, YEARHIRE with ALL
- DReplace SALESPERSON with ALL
23A manager asks an employee to list attributes of the customers that are headquartered in Los Angeles and that have a customer number higher than 1000. Refer to the given SQL statement prepared by this employee.
SELECT CUSTNUM, CUSTNAME, HQCITY
FROM CUSTOMER
WHERE HQCITY=‘Los Angeles’
Which line should go at the end of this statement?- AAND CUSTNUM>1000;
- BAND CUSTNUM>=1000;
- CWHERE CUSTNUM<1000
- DWHERE CUSTNUM>=1000;
24What is a key difference between the DISTINCT and ORDER BY statements, in SQL SELECT commands?
- AORDER BY does not alter the presentation of data results and DISTINCT modifies data results.
- BORDER BY modifies the presentation of data results and DISTINCT filters data results.
- CORDER BY changes the order of results in the database and DISTINCT changes the order of results in the view only.
- DORDER BY changes the order of results in the view only and DISTINCT changes the order of results in the database.
25Which SQL statement alphabetizes customer names within the same satellite-office city?
- AORDER BY CUSTNAME, SATCITY;
- BALPHA BY CUSTNAME, SATCITY;
- CORDER BY SATCITY, CUSTNAME;
- DALPHA BY SATCITY, CUSTNAME;
26The given SQL statement is intended to list the names of the products of which salesperson Fox has sold more than 500 units.
SELECT PRODNAME
FROM SALESPERSON, SALES, PRODUCT
?
?
AND SPNAME=‘Fox’
AND QUANTITY>500;
Which set of lines should replace the question marks to make this statement work?- AWHERE SALESPERSON.SPNUM=PRODUCT.PRODNUM AND SALES.PRODNUM=PRODUCT.PRODNUM
- BWHERE SALESPERSON.SPNUM=SALES.SPNUM AND SALES.PRODNUM=PRODUCT.PRODNUM
- CWHERE SALESPERSON.SPNUM>SALES.SPNUM AND SALES.PRODNUM=PRODUCT.PRODNUM
- DWHERE SALESPERSON.SPNUM=SALES.SPNUM AND SALES.PRODNUM=SALES.SPNUM
27The 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?- AFROM PUBNAME.BOOK
- BFROM PUBLISHER, BOOK
- CWHERE PUBNAME = BOOK
- DWHERE PUBLISHER = BOOK
28Refer to the given SQL statement to answer the following question:
SELECT *
FROM PRODUCT;
What would this SQL statement accomplish?- AList all PRODUCT from the * table.
- BDelete all products from the PRODUCT table view.
- CDelete all entries in the PRODUCT table.
- DList all entries in the PRODUCT table.
29A product-marketing company publishes an Internet-based newsletter about their new products to increase their customer base.
What is an advantage that this company will gain from investing in a relational database management system that will store customer information?- AIncreased sales
- BLower advertising costs
- CImproved query response times
- DDecreased skill acquisition times
30In which two ways does a database management system environment increase effectiveness in working with data?
Choose 2 answers- AIt enables data sharing.
- BIt duplicates redundant data for security.
- CIt permits storage of vast volumes of data.
- DIt increases the complexity rules by which data is organized.
31Sales data, detailing the customer names, products sold, and salespersons, is kept in a database.
Which kind of data in this database would qualify as intersection data related to both the product and salesperson entities?- AQuantity
- BProducts
- CSalespersons
- DCustomer names
32What is an attribute or group of attributes that uniquely identify a tuple in a relation?
- AIndex key
- BForeign key
- CPrimary key
- DPhysical key
33What 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?
- AA domain of values
- BIntersection data
- CAn attribute name
- DA quantity
34What uniquely identifies each entity in a collection of entities but is not the primary key?
- AThe foreign key
- BThe secondary key
- CThe alternate key
- DThe master key
35What 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?
- AForeign key
- BPrimary key
- CAlternate key
- DCandidate key
36What happens to the original data in database indexing?
- AIt is moved to the index.
- BIt is copied to the index.
- CIt is compiled by the DBMS.
- DIt is translated into hexadecimals.
37Why are indexes created in a physical database design?
- ATo group data into aggregations
- BTo iterate across data in a sequence
- CTo retrieve data directly using a pointer
- DTo summarize data into dimensions for a cube
38Why is an index created on a database column?
- ATo optimize data integrity
- BTo optimize data updates
- CTo optimize data retrievals
- DTo optimize data insertions
39What is a methodology for organizing attributes into tables?
- AData normalization
- BData redundancy
- CData indexing
- DData compression
40What is the term for the value of one particular attribute associated with a specific single value of another attribute?
- AFunctional dependency
- BTransitive dependency
- CDecomposition
- DNormalization
41Refer to the given table.
Project Code Employee No. Employee Name Department No. Department Name Hourly Rate
PC010 S10001 A. Smith L004 IT 22.00
PC010 S10030 L. Jones L023 Pensions 18.50
PC010 S21010 P. Lewis L004 IT 21.00
PC045 S10010 B. Jones L004 IT 21.75
PC045 S10001 A. Smith L004 IT 18.00
PC045 S31002 T. Gilbert L028 Database 25.50
PC045 S13210 W. Richards L008 Salary 17.00
PC064 S31002 T. Gilbert L028 Database 23.25
PC064 S21010 P. Lewis L004 IT 17.50
PC064 S10034 B. James L009 HR 16.50
In which state are the attributes shown?- AUnnormalized
- BFirst normal form
- CSecond normal form
- DThird normal form
42Refer to the given table.
Students
IDSt LastName IDProf Prof Grade
1 Mueller 3 Schmid 5
2 Meier 2 Borner 4
3 Tobler 1 Bernasconi 6
Which factor determines whether the table is in first normal form?- AThere are no functional dependencies.
- BThe fourth column shows the foreign keys.
- CThe attributes are all single valued.
- DThe first column is in numerical order.
43Refer to the given tables.
ID Contract Code
1 Vinod 091
2 Rajiv 091
Code City Country
091 Bangalore India
The primary key in the first table is ID, and the primary key in the second is Code.
How advanced are the two tables in the normalization process?- AUnnormalized
- BFirst normal form
- CSecond normal form
- DThird normal form
44Which characteristic points to the tables being in third normal form?
- AEach primary key has a functional dependency on every other primary key in the table.
- B"Salesperson Number” appears in more than one table.
- CThe tables are completely free of data redundancy.
- DThe attributes are all single valued.
45Which set of results should a company expect from implementing a business intelligence system?
- AIncreased profitability and increased throughput
- BReduced hardware redundancy and decreased workloads
- CIncreased profitability and reduced hardware redundancy
- DRiskier capital and asset investments and increased throughput
46Which issue is focused on the loading component of extract, transform, load (ETL)?
- AMonitor refreshing volume and frequency
- BDenormalizing and renormalizing the data
- CMapping keys from one system to another
- DDetermining the content of the data
47During which step in the extract, transform, load (ETL) process are raw data sets aggregated?
- ALoading
- BExtraction
- CConversion
- DTransformation
- EDenormalization
48How is prediction distinguished from estimation in data mining?
- APrediction is used to look at historical data only.
- BEstimation assumptions do not need to be tested.
- CPrediction classifies objects according to an expected future behavior.
- DEstimation divides small collections of entities into smaller groups of similar entities.
49Where does affinity grouping occur in data mining?
- AAmong entities and target applications
- BBetween entity group names
- CBetween objects
- DAmong clusters
Information
- Description
- College C175 - Data Management - Foundations Quiz on C175 - Practice Test, created by Craig Willey on 06/05/2019.
- Author
- Craig Willey
- Language
- English
- Views
- 91
- Tags
- Rating
- No ratings yet Rate this quiz