Enhanced models and applications: temporal, multimedia, XML, distributed databases, data warehousing, OLAP-OLTP, data mining techniques and Big Data (MapReduce, Hadoop) and NoSQL systems. - Question Bank

1. What is the primary benefit of using a data mining approach over traditional statistical analysis for certain problems?
A) It requires less computational power.
B) It can uncover complex, non-linear patterns in large datasets automatically.
C) It is simpler to implement.
D) It guarantees the discovery of causal relationships.
2. In multimedia databases, what is a key challenge related to data storage and retrieval?
A) The large size of media files and the need for efficient indexing and searching based on content.
B) The limited variety of data types.
C) The simplicity of query languages.
D) The small volume of data.
3. What is a common use case for distributed databases?
A) Small, single-user applications.
B) Applications requiring high availability and geographic distribution of data, like global e-commerce.
C) Databases with very simple schemas.
D) Storing small configuration files.
4. Which technique is commonly used to improve the performance of OLAP queries on large data cubes?
A) Indexing individual records.
B) Pre-aggregation of data (materialized views).
C) Reducing the number of dimensions.
D) Using only OLTP tables.
5. What does the 'variety' aspect of Big Data refer to?
A) The speed of data generation.
B) The volume of data.
C) The different types of data (structured, semi-structured, unstructured).
D) The accuracy of the data.
6. Which NoSQL database type is most suitable for representing social network connections or recommendation engines?
A) Key-Value Store
B) Document Database
C) Column-Family Store
D) Graph Database
7. What is a 'data mart' in a data warehousing context?
A) A small, single-subject data warehouse tailored to the needs of a specific department or user group.
B) The central repository for all organizational data.
C) A temporary storage area for raw data.
D) A tool for online transaction processing.
8. Which of the following is a potential challenge in managing temporal databases?
A) Handling the large volume of historical data and efficiently querying time intervals.
B) Ensuring data is not duplicated.
C) Simplifying query syntax.
D) Reducing the need for indexing.
9. What is a 'shredded' XML document in the context of storing XML in relational databases?
A) An XML document that has been deleted.
B) An XML document whose content is broken down and stored across multiple relational tables.
C) An XML document that is not well-formed.
D) An XML document that is only partially loaded.
10. Which component of Hadoop is responsible for resource management and job scheduling?
A) HDFS
B) MapReduce
C) YARN
D) Hive
11. What is the main advantage of using HDFS over traditional file systems for Big Data?
A) Lower latency for small file access.
B) Designed for fault tolerance and high throughput for large files across a cluster.
C) Easier management of structured data.
D) Built-in support for ACID transactions.
12. In the context of Big Data, what does 'velocity' refer to?
A) The sheer amount of data generated.
B) The speed at which data is generated and needs to be processed.
C) The diversity of data types.
D) The accuracy of the data.
13. Which data mining technique is analogous to supervised learning where the goal is to predict a numerical value?
A) Clustering
B) Classification
C) Regression
D) Association Rule Mining
14. What is the primary goal of 'data mining' when applied to customer data?
A) To optimize database indexing.
B) To identify customer segments, predict churn, or recommend products.
C) To ensure transactional integrity.
D) To manage multimedia content.
15. The 'Slice' operation in OLAP typically involves:
A) Selecting a subset of a cube by choosing a single value for one of its dimensions.
B) Selecting a sub-cube by specifying values for some but not all dimensions.
C) Aggregating data to a higher level.
D) Changing the orientation of the cube.
16. Which OLAP operation allows users to navigate through different levels of detail in a data hierarchy?
A) Slice
B) Dice
C) Drill-down/Roll-up
D) Pivot
17. What are 'dimension tables' in a star schema?
A) Tables containing the primary measures or metrics.
B) Tables providing context or descriptive attributes for the facts.
C) Tables used for transactional processing.
D) Tables storing raw, unaggregated data.
18. A 'fact table' is a central component in which data warehousing structure?
A) Entity-Relationship Diagram
B) Star Schema
C) Network Model
D) Hierarchical Model
19. What is a challenge related to distributed database concurrency control?
A) Ensuring that transactions do not interfere with each other across multiple sites.
B) Reducing the number of transactions.
C) Simplifying transaction logging.
D) Avoiding distributed deadlocks.
20. Which of the following is a common data format for XML documents?
A) Relational tables
B) Key-value pairs
C) Hierarchical structure with tags
D) Graph nodes and edges
21. In temporal databases, what is 'transaction time'?
A) The time a fact is valid in the real world.
B) The time a fact is recorded or modified in the database.
C) The time a query is executed.
D) The time a transaction is committed.
22. What does 'eventual consistency' mean in the context of some NoSQL databases?
A) Data will eventually become consistent across all replicas, but there might be a delay.
B) Data is always immediately consistent across all replicas.
C) Data is never consistent.
D) Consistency is guaranteed only for read operations.
23. Graph databases are designed to excel at:
A) Storing and querying large amounts of unstructured text.
B) Representing and querying complex relationships between data points (nodes and edges).
C) Handling high-volume, transactional workloads.
D) Storing key-value pairs efficiently.
24. Column-family stores (like Cassandra) are particularly well-suited for:
A) Storing single, complex documents.
B) Handling queries that involve large numbers of rows but few columns.
C) Applications with very high write loads and large datasets distributed across many servers.
D) Representing relationships between entities.
25. Which type of NoSQL database stores data in JSON-like documents, allowing for flexible and nested structures?
A) Key-Value Store
B) Column-Family Store
C) Document Database
D) Graph Database
26. Which type of NoSQL database is optimized for storing and retrieving key-value pairs?
A) Document Database
B) Column-Family Store
C) Key-Value Store
D) Graph Database
27. NoSQL is often chosen for applications requiring:
A) Strong consistency and complex relational queries.
B) High scalability, availability, and handling of unstructured or semi-structured data.
C) ACID compliance for all transactions.
D) Mature tooling and widespread adoption in enterprise reporting.
28. Which of the following is a characteristic of NoSQL databases?
A) Strict adherence to ACID properties.
B) Use of SQL as the primary query language.
C) Schema-less or flexible schema design.
D) Designed primarily for complex joins across multiple tables.
29. What is the purpose of the Hadoop Distributed File System (HDFS)?
A) To manage relational databases.
B) To store very large files across multiple machines in a cluster.
C) To handle real-time data streams.
D) To provide a query interface for XML data.
30. In Hadoop MapReduce, what does the 'Reduce' phase typically do?
A) Processes input data and generates intermediate key-value pairs.
B) Combines intermediate results from the map phase into final outputs.
C) Sorts the input data.
D) Initializes the job.
31. In Hadoop MapReduce, what does the 'Map' phase typically do?
A) Combines intermediate results from the map phase.
B) Processes input data and generates intermediate key-value pairs.
C) Sorts the intermediate data.
D) Outputs the final results.
32. What is the primary function of Hadoop MapReduce?
A) A distributed file system for storing large files.
B) A programming model for processing large datasets in parallel across clusters.
C) A NoSQL database for unstructured data.
D) A tool for real-time data streaming.
33. Which of the following is a core concept in Big Data processing frameworks?
A) Single-threaded processing
B) Distributed computing
C) Sequential data access
D) In-memory processing only
34. What is 'Big Data' generally characterized by?
A) Small volume, low velocity, and low variety.
B) High volume, high velocity, and high variety of data.
C) Structured data only, with low complexity.
D) Data that is easy to process and analyze.
35. Association rule mining, like 'Apriori', is primarily used for what purpose?
A) Predicting future trends.
B) Discovering relationships between items (e.g., market basket analysis).
C) Segmenting customers into groups.
D) Identifying anomalies in data.
36. What does the 'classification' technique in data mining aim to do?
A) Predict a continuous value for a given input.
B) Assign data points to predefined categories or classes.
C) Discover relationships between items in a dataset.
D) Group similar data points without predefined categories.
37. Which data mining technique is used to group similar data instances together?
A) Classification
B) Regression
C) Clustering
D) Association Rule Mining
38. What is the goal of data mining?
A) To store large volumes of data efficiently.
B) To extract hidden patterns and knowledge from large datasets.
C) To provide real-time transaction processing.
D) To design and implement distributed systems.
39. Which of the following best describes 'OLTP'?
A) Online Transaction Processing systems designed for high-volume, short, atomic transactions.
B) Online Analytical Processing systems for complex data analysis.
C) Systems for managing large multimedia files.
D) Systems for querying XML documents.
40. What is the main characteristic of OLAP operations compared to OLTP operations?
A) Focus on frequent, small, atomic transactions.
B) Focus on complex analytical queries involving large historical data.
C) Designed for real-time data entry.
D) Primarily used for online transaction processing.
41. In data warehousing, what does 'OLAP' stand for?
A) Online Analytical Processing
B) Operational Level Access Protocol
C) Object Linking and Access Program
D) Optimized Logical Application Processing
42. Which of the following is a common data modeling technique used in data warehousing?
A) Entity-Relationship Modeling
B) Star Schema
C) Network Model
D) Hierarchical Model
43. What is the primary purpose of a data warehouse?
A) To support day-to-day operational transactions.
B) To store and manage real-time data streams.
C) To facilitate business intelligence and decision support by integrating data from various sources.
D) To provide a platform for developing new applications.
44. What is a 'distributed transaction' in the context of distributed databases?
A) A transaction that executes on a single database server.
B) A transaction that involves updates to data stored at multiple network sites.
C) A transaction that only reads data.
D) A transaction that is never committed.
45. Which of the following is a key challenge in distributed databases?
A) Ensuring data consistency across multiple sites.
B) Reducing the number of available servers.
C) Simplifying query processing.
D) Limiting the scope of data access.
46. In XML, what is a 'tag' used to define?
A) A data value
B) An element or structure within the document
C) A comment
D) A processing instruction
47. Which standard is commonly used for representing and querying semi-structured data, particularly in web applications?
A) SQL
B) JSON
C) XML
D) CSV
48. What is the primary characteristic of a multimedia database?
A) Storing only textual data.
B) Storing and managing various types of media like images, audio, and video.
C) Optimized for complex numerical calculations.
D) Designed for transactional processing only.
49. In a temporal database, what is a 'valid time' interval?
A) The period during which a fact is true in the real world.
B) The period during which a fact is stored in the database.
C) The period during which a query is executed.
D) The period during which a transaction is active.
50. Which type of database model is designed to handle time-varying data, allowing queries about past, present, and future states?
A) Relational Model
B) Temporal Database Model
C) Object-Oriented Model
D) Network Model
All Question Banks
E-Book Enhanced models and applications: temporal, multimedia, XML, distributed databases, data warehousing, OLAP-OLTP, data mining techniques and Big Data (MapReduce, Hadoop) and NoSQL systems. One Line Questions Enhanced models and applications: temporal, multimedia, XML, distributed databases, data warehousing, OLAP-OLTP, data mining techniques and Big Data (MapReduce, Hadoop) and NoSQL systems. Online Test Enhanced models and applications: temporal, multimedia, XML, distributed databases, data warehousing, OLAP-OLTP, data mining techniques and Big Data (MapReduce, Hadoop) and NoSQL systems.