A SQL query with local format transparency needs to specify:
A) Fragments
B) Locations
C) Fragments and locations
D) Local formats

Question

Quizplus · Accepted Answer

A SQL query with local format transparency needs to specify both fragments and locations in order to map data from various databases with different formats into a consistent format that can be easily analyzed. By specifying fragments, the query can identify what information needs to be extracted from each database, while specifying locations helps to ensure that the data from each fragment is correctly located and related to other data within the query. Local formats are not necessary to specify, as the goal of local format transparency is to standardize the data format regardless of the original format in each database.

A SQL Query with Local Format Transparency Needs to Specify