Which DB2 feature allows for querying and manipulating XML or JSON data directly?
- DB2 XML Toolkit
- JSON_TABLE function
- SQL/XML
- XMLTABLE function
The JSON_TABLE function in DB2 allows for querying and manipulating JSON data directly. It provides a way to extract data from JSON documents and transform it into relational format, facilitating seamless integration of JSON data with traditional SQL queries.
Loading...
Related Quiz
- What is the purpose of the CHECK constraint in DB2?
- Scenario: A DBA needs to generate XML output from a query result in DB2 but wants to customize the format according to specific requirements. Which feature of DB2 can help achieve this?
- Scenario: An application requires that a certain column in a DB2 table always contains a valid date value. Which constraint should be applied to enforce this rule?
- How does the performance of a subquery differ from that of a join in DB2?
- Scenario: An organization is required to comply with strict data security regulations. How can they ensure that sensitive data stored in DB2 is adequately encrypted?