CS331Prac1

docx

School

New Jersey Institute Of Technology *

*We aren’t endorsed by this school

Course

331

Subject

Computer Science

Date

Jan 9, 2024

Type

docx

Pages

Uploaded by ProfessorReindeer1238

Jeet Patel CS 331 State True/False 1. The major advantage of the data propagation approach to data integration is the near real-time cascading of data changes throughout the organization True 2. Data reconciliation occurs in two stages, an initial load and subsequent updates. True 3. Static extract is a method of capturing only the changes that have occurred in the source data since the last capture. False 4. Data scrubbing is a technique using pattern recognition and other artificial intelligence techniques to upgrade the quality of raw data before transforming and moving the data to the data warehouse. True 5. Periodic data are data that are never physically altered or deleted once they have been added to the store. True 6. When a dimension participates in a hierarchy, the database designer can normalize the dimension into a nested set of tables with 1:M relationships between them True 7. A snowflake schema is usually heavily aggregated False 8. Multidimensional OLAP (MOLAP) tools use variations of SQL and view the database as a relational database, in either a star schema or other normalized or denormalized set of tables. False 9. WXDL is an XML-based grammar False 10. The following query will execute without errors. False select customer.customer_name, salesman.sales_quota from customer where customer.salesman_id = (select salesman_id where lname = 'SMITH'); 11. In order to find out what customers have not placed an order for a particular item, one might use the NOT qualifier along with the IN qualifier

True 12. A referential integrity constraint specifies that the existence of an attribute in one table depends upon the existence of a foreign key in the same or another table. False 13. Count(*) tallies only those rows that contain a value, while Count counts all rows. True False 14. Sensitivity testing involves ignoring missing data unless knowing a value might significantly change results True 15. Free range partitioning is a type of horizontal partitioning in which each partition is defined by a range of values for one or more columns in the normalized table. False

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Related Documents

Database Optimization and Performance Tuning Paper COMPLETE.docx

Term Group Project Deliverable 1.docx

workshop_9.pdf

ALU Lab.docx

DBch5a (1)-1-1(1).docx

Midterm Exam Note.docx

Quiz 1.docx

Recommended textbooks for you

Fundamentals of Information Systems

Computer Science

ISBN:9781337097536

Author:Ralph Stair, George Reynolds

Publisher:Cengage Learning

Principles of Information Systems (MindTap Course...

Computer Science

ISBN:9781305971776

Author:Ralph Stair, George Reynolds

Publisher:Cengage Learning

Principles of Information Systems (MindTap Course...

Computer Science

ISBN:9781285867168

Author:Ralph Stair, George Reynolds

Publisher:Cengage Learning

Fundamentals of Information Systems

Computer Science

ISBN:9781305082168

Author:Ralph Stair, George Reynolds

Publisher:Cengage Learning

MIS

Computer Science

ISBN:9781337681919

Author:BIDGOLI

Publisher:Cengage

Database Systems: Design, Implementation, & Manag...

Computer Science

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Cengage Learning

SEE MORE TEXTBOOKS

Recommended textbooks for you

Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
MIS
Computer Science
ISBN:9781337681919
Author:BIDGOLI
Publisher:Cengage
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning