Question 1Which is not a reason why data integration across multiple organizations is harder than integration within an organization? SQL can be implemented differently in different databases, which creates a need to reconcile those differences. Efficient execution of queries over multiple systems is challenging. Query processing in distributed databases is challenging. Data from different sources tend to be structured differently.Question 2Which statement accurately distinguishes the roles of the wrapper and source description in a mediated schema? The wrapper requests and parses data from the sources, while the source description converts data from the source schemas and values into the global representation. The source description requests and parses data from the sources, while the wrapper converts data from the source schemas and values into the global representation. The wrapper abstracts source data, while the source description requests and parses data from the sources. The source description abstracts source data, while the wrapper requests and parses data from the sources. Question 3Which of the following statements is true about data warehouse integration systems and virtual data integration systems? A virtual data integration system uses ETL, or extract-transform-load, tool pipelines that periodically extract data from the sources and load them an application. Both data integration architectures use a mediated schema. A data warehouse integration system leaves data in the sources and accesses them as needed at query time. In the warehousing approach, the user poses queries in terms of the warehouse schema. Question 4______ considerably simplifies the task of expressing complex queries because they can be written in smaller fragments and combined appropriately. Query unfolding Composability A datalog program Integrity constraints Question 5What is specified by a relational schema? The number of arguments in a query Limits of the possible states of the database The set of attributes in the table and a data type for each attribute The contents of a database Question 6Which is an example of an unstructured query? SQL query over an XML database XQuery query SQL query over a relational database A list of keywords Question 7Which defines the Global-and-Local-as-View (GLAV) schema mapping? Expressions include a query over the data sources on the left-hand side and a query on the mediated schema on the right-hand side Focuses on describing each data source as precisely as possible and independently of any other sources Defines the mediated schema as a set of views over the data sources Derived from data dependency constraints and developed for the specification and analysis of integrity constraints in databases Question 8Which describes the affine gap measure? Computed by assigning a score to each alignment between the two input strings and choosing the score of the best alignment An extension of the Needleman-Wunsch measure that handles longer gaps more gracefully Computes the minimal cost of transforming string x to string y Designed to find matching substrings by introducing two key changes to the Needleman-Wunsch measure Question 9Which describes the Monge-Elkan similarity measure? Effective in matching names, since names are often spelled in different ways that sound the same Retrieves only the strings in Y whose size makes them match candidates Limits the set of candidate matches by deriving an upper bound on the size of the overlap between a pair of strings Effective for domains in which more control is needed over the similarity measure Question 10Which is not a common integrity constraint in a database? Functional dependencies Key Foreign key Null value

Question

Question 1Which is not a reason why data integration across multiple organizations is harder than integration within an organization?  SQL can be implemented differently in different databases, which creates a need to reconcile those differences. Efficient execution of queries over multiple systems is challenging. Query processing in distributed databases is challenging. Data from different sources tend to be structured differently.Question 2Which statement accurately distinguishes the roles of the wrapper and source description in a mediated schema?  The wrapper requests and parses data from the sources, while the source description converts data from the source schemas and values into the global representation. The source description requests and parses data from the sources, while the wrapper converts data from the source schemas and values into the global representation. The wrapper abstracts source data, while the source description requests and parses data from the sources. The source description abstracts source data, while the wrapper requests and parses data from the sources. Question 3Which of the following statements is true about data warehouse integration systems and virtual data integration systems?  A virtual data integration system uses ETL, or extract-transform-load, tool pipelines that periodically extract data from the sources and load them an application. Both data integration architectures use a mediated schema. A data warehouse integration system leaves data in the sources and accesses them as needed at query time. In the warehousing approach, the user poses queries in terms of the warehouse schema. Question 4______ considerably simplifies the task of expressing complex queries because they can be written in smaller fragments and combined appropriately.  Query unfolding Composability A datalog program Integrity constraints Question 5What is specified by a relational schema?  The number of arguments in a query Limits of the possible states of the database The set of attributes in the table and a data type for each attribute The contents of a database Question 6Which is an example of an unstructured query?  SQL query over an XML database XQuery query SQL query over a relational database A list of keywords Question 7Which defines the Global-and-Local-as-View (GLAV) schema mapping?  Expressions include a query over the data sources on the left-hand side and a query on the mediated schema on the right-hand side Focuses on describing each data source as precisely as possible and independently of any other sources Defines the mediated schema as a set of views over the data sources Derived from data dependency constraints and developed for the specification and analysis of integrity constraints in databases Question 8Which describes the affine gap measure?  Computed by assigning a score to each alignment between the two input strings and choosing the score of the best alignment An extension of the Needleman-Wunsch measure that handles longer gaps more gracefully Computes the minimal cost of transforming string x to string y Designed to find matching substrings by introducing two key changes to the Needleman-Wunsch measure Question 9Which describes the Monge-Elkan similarity measure?  Effective in matching names, since names are often spelled in different ways that sound the same Retrieves only the strings in Y whose size makes them match candidates Limits the set of candidate matches by deriving an upper bound on the size of the overlap between a pair of strings Effective for domains in which more control is needed over the similarity measure Question 10Which is not a common integrity constraint in a database?  Functional dependencies Key Foreign key Null value

Accepted Answer

According to our company's policy, we are obliged to answer only the first question in case of…