11-13-2010, 04:03 AM
[FONT="]Imrangee[/FONT]
[FONT="]CS614 DATA WAREHOUSING[/FONT]
[FONT="]FALL 2010 QUIZ # 1 HELD ON 12 NOV 2010[/FONT]
[FONT="]Question # 1 of 10 Total Marks: 1[/FONT]
[FONT="]Node of a B- Tree is stored in memory block and Traversing a B-tree[/FONT]
[FONT="]involves ____ page faults?[/FONT]
[FONT="]O (n^2)[/FONT]
[FONT="]O (n)[/FONT]
[FONT="]O (n log n)[/FONT]
[FONT="]O (log n)[/FONT]
[FONT="]Question # 2 of 10 Total Marks: 1[/FONT]
[FONT="]The growth of master files and magnetic tapes exploded around the mid[/FONT]
[FONT="]1960[/FONT]
[FONT="]1970[/FONT]
[FONT="]1980[/FONT]
[FONT="]1990[/FONT]
[FONT="]Question # 3 of 10 Total Marks: 1[/FONT]
[FONT="]Is an application of information & data[/FONT]
[FONT="]Intelligence[/FONT]
[FONT="]Education[/FONT]
[FONT="]Knowledge[/FONT]
[FONT="]Power[/FONT]
[FONT="]Question # 4 of 10 Total Marks: 1[/FONT]
[FONT="]Need to synchronize data upon updation is called?[/FONT]
[FONT="]Data Limitation[/FONT]
[FONT="]Data Manipulation[/FONT]
[FONT="]Data Coherence[/FONT]
[FONT="]Data Replication[/FONT]
[FONT="]Question # 5 of 10 Total Marks: 1[/FONT]
[FONT="]Suppose the amount of data recorded in an organization is doubled every[/FONT]
[FONT="]year, this is called?[/FONT]
[FONT="]Linear[/FONT]
[FONT="]Quadratic[/FONT]
[FONT="]Exponential[/FONT]
[FONT="]Logarithmic[/FONT]
[FONT="]Imrangee[/FONT]
[FONT="]Question # 6 of 10 Total Marks: 1[/FONT]
[FONT="]Relational databases allow you to navigate the data in _____ direction that is[/FONT]
[FONT="]appropriate using the primary, foreign key structure?[/FONT]
[FONT="]Forward[/FONT]
[FONT="]One[/FONT]
[FONT="]Backward[/FONT]
[FONT="]Any[/FONT]
[FONT="]Question # 7 of 10 Total Marks: 1[/FONT]
[FONT="]The input to the data warehouse can come from OLTP or transactional[/FONT]
[FONT="]systems or other third party databases.[/FONT]
[FONT="]True[/FONT]
[FONT="]False[/FONT]
[FONT="]Question # 8 of 10 Total Marks: 1[/FONT]
[FONT="]Naturally Evolving Architecture occurred when an organization had a[/FONT]
[FONT="]______ approach to handling the whole process of hardware and software[/FONT]
[FONT="]architecture?[/FONT]
[FONT="]Good[/FONT]
[FONT="]Relaxed[/FONT]
[FONT="]Not Relaxed[/FONT]
[FONT="]None[/FONT]
[FONT="]Question # 9 of 10 Total Marks: 1[/FONT]
[FONT="]____ modeling technique is more appropriate for data warehousing[/FONT]
[FONT="]Dimensional[/FONT]
[FONT="]Physical[/FONT]
[FONT="]Entity Relationship[/FONT]
[FONT="]None[/FONT]
[FONT="]Question # 10 of 10 Total Marks: 1[/FONT]
[FONT="]______ gives total view of an organization?[/FONT]
[FONT="]OLTP[/FONT]
[FONT="]OLAP[/FONT]
[FONT="]Data warehousing[/FONT]
[FONT="]Database[/FONT]
[FONT="]CS614 DATA WAREHOUSING[/FONT]
[FONT="]FALL 2010 QUIZ # 1 HELD ON 12 NOV 2010[/FONT]
[FONT="]Question # 1 of 10 Total Marks: 1[/FONT]
[FONT="]Node of a B- Tree is stored in memory block and Traversing a B-tree[/FONT]
[FONT="]involves ____ page faults?[/FONT]
[FONT="]O (n^2)[/FONT]
[FONT="]O (n)[/FONT]
[FONT="]O (n log n)[/FONT]
[FONT="]O (log n)[/FONT]
[FONT="]Question # 2 of 10 Total Marks: 1[/FONT]
[FONT="]The growth of master files and magnetic tapes exploded around the mid[/FONT]
[FONT="]1960[/FONT]
[FONT="]1970[/FONT]
[FONT="]1980[/FONT]
[FONT="]1990[/FONT]
[FONT="]Question # 3 of 10 Total Marks: 1[/FONT]
[FONT="]Is an application of information & data[/FONT]
[FONT="]Intelligence[/FONT]
[FONT="]Education[/FONT]
[FONT="]Knowledge[/FONT]
[FONT="]Power[/FONT]
[FONT="]Question # 4 of 10 Total Marks: 1[/FONT]
[FONT="]Need to synchronize data upon updation is called?[/FONT]
[FONT="]Data Limitation[/FONT]
[FONT="]Data Manipulation[/FONT]
[FONT="]Data Coherence[/FONT]
[FONT="]Data Replication[/FONT]
[FONT="]Question # 5 of 10 Total Marks: 1[/FONT]
[FONT="]Suppose the amount of data recorded in an organization is doubled every[/FONT]
[FONT="]year, this is called?[/FONT]
[FONT="]Linear[/FONT]
[FONT="]Quadratic[/FONT]
[FONT="]Exponential[/FONT]
[FONT="]Logarithmic[/FONT]
[FONT="]Imrangee[/FONT]
[FONT="]Question # 6 of 10 Total Marks: 1[/FONT]
[FONT="]Relational databases allow you to navigate the data in _____ direction that is[/FONT]
[FONT="]appropriate using the primary, foreign key structure?[/FONT]
[FONT="]Forward[/FONT]
[FONT="]One[/FONT]
[FONT="]Backward[/FONT]
[FONT="]Any[/FONT]
[FONT="]Question # 7 of 10 Total Marks: 1[/FONT]
[FONT="]The input to the data warehouse can come from OLTP or transactional[/FONT]
[FONT="]systems or other third party databases.[/FONT]
[FONT="]True[/FONT]
[FONT="]False[/FONT]
[FONT="]Question # 8 of 10 Total Marks: 1[/FONT]
[FONT="]Naturally Evolving Architecture occurred when an organization had a[/FONT]
[FONT="]______ approach to handling the whole process of hardware and software[/FONT]
[FONT="]architecture?[/FONT]
[FONT="]Good[/FONT]
[FONT="]Relaxed[/FONT]
[FONT="]Not Relaxed[/FONT]
[FONT="]None[/FONT]
[FONT="]Question # 9 of 10 Total Marks: 1[/FONT]
[FONT="]____ modeling technique is more appropriate for data warehousing[/FONT]
[FONT="]Dimensional[/FONT]
[FONT="]Physical[/FONT]
[FONT="]Entity Relationship[/FONT]
[FONT="]None[/FONT]
[FONT="]Question # 10 of 10 Total Marks: 1[/FONT]
[FONT="]______ gives total view of an organization?[/FONT]
[FONT="]OLTP[/FONT]
[FONT="]OLAP[/FONT]
[FONT="]Data warehousing[/FONT]
[FONT="]Database[/FONT]