Question
Which of the following scenarios best exemplifies the
use of semi-structured data in an organization?Solution
Semi-structured data, such as JSON, is a data format that organizes information without adhering to the rigid schemas of structured data. JSON allows the storage of key-value pairs, enabling flexibility while maintaining some structure for processing. In this case, the employee performance report in a JSON file captures a mix of structured data (e.g., employee IDs, performance ratings) and unstructured details (e.g., textual feedback). Organizations favor semi-structured formats for applications like web services or APIs, as these allow data to be easily shared and parsed across systems. Unlike structured data, JSON’s flexibility makes it highly suitable for evolving datasets that require some hierarchy but not the strictness of relational databases. Why Other Options Are Incorrect: • A: Customer surveys stored in spreadsheets represent structured data due to their tabular arrangement. • B: Video recordings are unstructured data as they lack inherent categorization or schema. • D: Handwritten notes qualify as unstructured data because they lack a predefined organization. • E: Relational databases are an example of structured data, adhering to defined schemas.
Which of the following memories has the shortest access times?Â
Which normal form deals with the issue of transitive dependencies?
What is the purpose of the SQL "GROUP BY" clause?
Which of the following is used to speed up data retrieval in a relational database?
Which of the following joins returns all rows from both tables, filling in NULL values for non-matching rows?
What is the full form of DBMS?
Which database model is based on the mathematical set theory and is the foundation of many modern databases?
Which of the following storage devices is considered non-volatile?
How many types of architecture we have in DBMS
Pick the odd one out.