INF503 Week 1 All Quizezz

Flume is a tool for converting data back and forth between a relational database and the HDFS.

• True
• False

CORRECT

See: Ch. 14: Big Data and NoSQL, Section - 14-2c Hadoop Ecosystem

Automatic query optimization means that the:

• optimization process is scheduled and selected by the end user or programmer.
• optimization takes place at compilation time by the programmer.
• DBMS finds the most cost-effective access path without user intervention.
• database access strategy is defined when the program is executed.

CORRECT

See: Ch. 11: Database Performance Tuning and Query Optimization, Section - 11-1c Database Query Optimization Modes

_____ can render data useless to unauthorized users who might have violated some of the database security layers.

• Password security
• Data encryption
• Access rights
• Physical security

CORRECT

See: Ch. 9: Database Design, Section - 9-3d Testing and Evaluation

Which statement describes a feature of Oracle sequences?

• Dropping a sequence does not delete values assigned to table attributes; it deletes only the sequence object from the database.
• Oracle sequences are tied to columns and tables.
• Oracle sequences generate a character string that can be assigned to tables.
• An Oracle sequence uses the identity column property to automatically number rows.

CORRECT

See: Ch. 8: Advanced SQL, Section - 8-6 Sequences

The _____ component of a CASE tool produces the information system's input/output formats.

• graphics
• program document generator
• screen painter and report generator
• analysis

CORRECT

See: Ch. 16: Database Administration and Security, Section - 16-7b Case Tools

Which of the following is true of a web application server?

• It provides security and authentication of users through user IDs and passwords.
• It runs on the client machine, freeing server resources.
• It is Microsoft's implementation of a superset of the SQL Access Group CLI standard for database access.
• It is automatically invoked by the browser when needed.

CORRECT

See: Ch. 15: Database Connectivity and Web Technologies, Section - 15-2e Web Application Servers

The scheduler establishes the order in which the operations within concurrent transactions are executed.

• True
• False

CORRECT

See: Ch. 10: Transaction Management and Concurrency Control, Section - 10-2d The Scheduler

An atomic attribute _____.

• displays multiplicity
• is always chosen to be a foreign key
• cannot exist in a relational table
• cannot be further subdivided

CORRECT

See: Ch. 6: Normalization of Database Tables, Section - 6-4 Improving the Design

A(n) _____ specifically reserves access to the transaction that locked the object.

• shared lock
• binary lock
• exclusive lock
• deadlock

CORRECT

See: Ch. 10: Transaction Management and Concurrency Control, Section - 10-3b Lock Types

The effects of bad database design, implementation, and management are magnified in an environment in which the number of transactions is less than one hundred.

• True
• False

CORRECT

See: Ch. 15: Database Connectivity and Web Technologies, Section - 15-2 Database Internet Connectivity

Advanced OLAP feature become more useful when access to them is kept simple.

• True
• False

CORRECT

See: Ch. 13: Business Intelligence and Data Warehouses, Section - 13-6c Easy-to-Use End-User Interfaces

The storage locations for multiple backups must include sites inside and outside the organization.

• True
• False

CORRECT

See: Ch. 16: Database Administration and Security, Section - 16-5a The DBA's Managerial Role

MySQL allows multiple triggering conditions per trigger.

• True
• False

CORRECT

See: Ch. 8: Advanced SQL, Section - 8-7a Triggers

Fully equivalent means that the optimized query results are always the same as the original query.

• True
• False

CORRECT

See: Ch. 11: Database Performance Tuning and Query Optimization, Section - 11-2a SQL Parsing Phase

_____ transparency exists when the end user or programmer must specify the database fragment names but does not need to specify where these fragments are located.

• Fragmentation
• Location
• Local mapping
• Transaction

CORRECT

See: Ch. 12: Distributed Database Management Systems, Section - 12-8 Distribution Transparency

An operational database is sometimes referred to as an enterprise database.

• True
• False

CORRECT

See: Ch. 1: Database Systems, Section - 1-3b Types of Databases

In the single-site processing, single-site data (SPSD) scenario, all processing must be done on the end user's side of the system.

• True
• False

CORRECT

See: Ch. 12: Distributed Database Management Systems, Section - 12-6a Single-Site Processing, Single-Site Data

Which of the following is a specialization hierarchy overlapping constraint scenario in case of partial completeness?

• Supertype has optional subtypes.
• Subtype does not have a supertype.
• Subtype discriminators cannot be null.
• Subtype sets are unique.

CORRECT

See: Ch. 5: Advanced Data Modeling, Section - 5-1f Completeness Constraint

The database contents might be loaded interactively or in batch mode using a variety of methods and devices including customized user programs.

• True
• False

CORRECT

See: Ch. 9: Database Design, Section - 9-2d Implementation

A _____ entity has a primary key that is partially or totally derived from the parent entity in the relationship.

• strong
• weak
• business
• child

CORRECT

See: Ch. 4: Entity Relationship (ER) Modeling, Section - 4-1f Relationship Strength

Which query is used to list a unique value for V_CODE, where the list will produce only a list of those values that are different from one another?

• SELECT DISTINCT V_CODE
  
  FROM PRODUCT;
• SELECT UNIQUE V_CODE
  
  FROM PRODUCT;
• SELECT DIFFERENT V_CODE
  
  FROM PRODUCT;
• SELECT ONLY V_CODE
  
  FROM PRODUCT;

CORRECT

See: Ch. 7: Introduction to Structured Query Language (SQL), Section - 7-3e Listing Unique Values

In the relational model, _____ are important because they are used to ensure that each row in a table is uniquely identifiable.

• logical structures
• keys
• indexes
• relations

CORRECT

See: Ch. 3: The Relational Database Model, Section - 3-2 Keys

______ minimizes the number of disk reads necessary to retrieve a row of data.

• Column-centric storage
• Column-oriented database
• Column-family database
• Row-centric storage

CORRECT

See: Ch. 14: Big Data and NoSQL, Section - 14-3c Column-Oriented Databases

The reliance on _____ as the design methodology for relational databases is seen as a stumbling block to its use in OLAP systems.

• normalization
• denormalization
• star schema
• multidimensional schema

CORRECT

See: Ch. 13: Business Intelligence and Data Warehouses, Section - 13-6e Relational OLAP

Which of the following is true of business rules?

• They can serve as a communication tool between the users and designers.
• They provide a framework for the company's self-actualization.
• They allow the designer to develop business processes.
• They allow the designer to set company policies with regard to data.

CORRECT

See: Ch. 2: Data Models, Section - 2-4a Discovering Business Rules

Right

"Check My Work" Clicked: 5 Times

• Check My Work

Remember for a moment a recent trip you have made to the grocery store to pick up a few items. What pieces of data did the Point of Sale (POS) terminal and cashier collect from you and what pieces of data about the transaction did the POS terminal pull from a database to complete the sale? In addition to the data collected and retrieved what information was generated by the POS terminal at the end of the order, as it is being completed? Identify the following parts of a common grocery store transaction as data, information, or knowledge. 1. An item's UPC number DataSelectDataInformationKnowledgeItem 1  2. Change back to customer InformationSelectDataInformationKnowledgeItem 2  3. General changes to demand in different seasons KnowledgeSelectDataInformationKnowledgeItem 3  4. Cost each DataSelectDataInformationKnowledgeItem 4  5. Quantity purchased DataSelectDataInformationKnowledgeItem 5  6. Non-taxable total InformationSelectDataInformationKnowledgeItem 6  7. Extended cost (quantity times cost each) InformationSelectDataInformationKnowledgeItem 7  8. Amount tendered DataSelectDataInformationKnowledgeItem 8  9. Sales of an item for the last week InformationSelectDataInformationKnowledgeItem 9  10. Upcoming holidays and customer’s special needs KnowledgeSelectDataInformationKnowledgeItem 10  11. How paid (cash, charge card, debit card) DataSelectDataInformationKnowledgeItem 11  12. Shopper loyalty card number DataSelectDataInformationKnowledgeItem 12  13. Taxable total InformationSelectDataInformationKnowledgeItem 13

ight

"Check My Work" Clicked: 2 Times

• Check My Work

Given the following table of students, assignments, and grades for a single class: Student_ID Student_Name Assignment_1_Date Assignment_1_Name Assignment_1_Grade Assignment_2_Date Assignment_2_Name Assignment_2_Grade Assignment_3_Date Assignment_3_Name Assignment_3_Grade 1011 Susan J. Smith 2015-06-01 Homework - Chapter Seven 76 2015-06-05 Chapter 7 Quiz 88 2015-06-12 Homework – Chapter 8 A 2332 Jones, Jamal K. 2015-06-01 Homework - Chapter Seven 84 2015-06-05 Quiz – Chapter 7 89 2015-06-12 Homework – Chapter 8 95 3432 Brown, Ronald 2015-06-01 Homework - Chapter Seven 66 2015-06-05 Quiz – Chapter 7 78 2015-06-12 Homework – Chapter 8 B 5435 Killen, Katie 2015-06-01 Homework - Chapter Seven 97 2015-06-05 Chapter 7 – Quiz 95 2015-06-12 Homework – Chapter 8 94 7574 Powell, B. 2015-06-01 Homework - Chapter Seven 68 2015-06-05 Quiz – Chapter 7 89 9677 Pat Hayes 6/1/2015 Homework - Chapter Seven 89 2015-06-05 Quiz – Chapter 7 85 2015-06-12 Homework – Chapter 8 99 Examine the data in the table above and identify any columns that contain data inconsistencies. Place an X in the Consistent or Inconsistent column. Column Student_ID ConsistentSelectConsistentInconsistentItem 1  Student_Name InconsistentSelectConsistentInconsistentItem 2  Assignment_1_Date InconsistentSelectConsistentInconsistentItem 3  Assignment_1_Name ConsistentSelectConsistentInconsistentItem 4  Assignment_1_Grade ConsistentSelectConsistentInconsistentItem 5  Assignment_2_Date ConsistentSelectConsistentInconsistentItem 6  Assignment_2_Name InconsistentSelectConsistentInconsistentItem 7  Assignment_2_Grade ConsistentSelectConsistentInconsistentItem 8  Assignment_3_Date ConsistentSelectConsistentInconsistentItem 9  Assignment_3_Name ConsistentSelectConsistentInconsistentItem 10  Assignment_3_Grade InconsistentSelectConsistentInconsistentItem 11

Hide Feedback

Correct

Check My Work Feedback

Four columns (Student_Name, Assignment_1_Date, Assignment_2_Name, and Assignment_3_Grade) have inconsistencies in the format of their data:

• In column Student_Name “Pat Hayes” is in a different format than the other names.
• In column Assignment_1_Date all but one of the dates is shown in YYYY-MM-DD format.
• In column Assignment_2_Name one of the chapter 7 quizzes has a different name.
• In column Assignment_3_Grade two of the grades were entered as letters not as a number like all of the other grades.

Right

"Check My Work" Clicked: 3 Times

• Clear All
 
• Check My Work

Use the following business rules to assign name to the tables on the ERD: Note: These rules are in the context of a small retail store and their charge account process. The case contains simplifying assumptions that may not accurately represent a real-world example. 1) A customer may be responsible for one account. 2) An account can have several charges posted to it but a charge may only be posted to a single account. 3) A charge may include an item and an item may be included on many charges. 4) An account may have several payments made against it but a payment may only be credited to a single account. Write the business rules for the following ERD shown in the figure below. The diagram represents the “Charge Account” at a small retail store. The ERD may contain simplifying assumptions that may not accurately represent a real-world example.

Hide Feedback

Correct

• Clear All
 
• Check My Work

1. What image should go into the square marked 1?

a.

b.

c.

d.

Hide Feedback

Correct

2. What image should go into the square marked 2?

a.

b.

c.

d.

Hide Feedback

Correct

3. What image should go into the square marked 3?

a.

b.

c.

d.

Hide Feedback

Correct

4. What image should go into the square marked 4?

a.

b.

c.

d.

Hide Feedback

Correct

5. What image should go into the square marked 5?

a.

b.

c.

d.

Hide Feedback

Correct

6. What image should go into the square marked 6?

a.

b.

c.

d.

Hide Feedback

Correct

7. What image should go into the square marked 7?

a.

b.

c.

d.

Hide Feedback

Correct

8. What image should go into the square marked 8?

a.

b.

c.

d.

Hide Feedback

Correct