Multiple Choice Questions

Which of the following is correct in reference to a database? A. A database can support only one logical viewB. A database can support many physical viewsC. A database can support many logical viewsD. A database can support up to 3 logical views
  • Zappos database was highly redundant
  • Operational systems are integrated
  • Transactional information
  • A database can support many logical views
What is a foreign key? A. A field (or group of fields) that uniquely identifies a given entity in a tableB. A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tablesC. Characteristics or properties of an entityD. A field (or group of fields) that uniquely identifies a given attribute in a table
  • An entity is a table that stores information about people, places, or events, where as an attribute is a column or specific field of the data elements associated with an entity
  • A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables
  • unstructured data associated with websites to identify consumer behavior and website navigation
  • Primary key
When does information cleansing occur in the data warehouse? A. During the ETL processB. On the information, once it is in the data warehouseC. During the ETL process and once it is in the data warehouseD. During the ETL process and before it is in the data warehouse
  • Future growth analysis, sales projections, and product statistics
  • A database can support many logical views
  • During the ETL process and once it is in the data warehouse
  • Competitor and industry information, mailing lists, and stock market analysis
0 h : 0 m : 1 s

Multiple Choice Questions
Answered Not Answered Not Visited Correct : 0 Incorrect : 0