Question
Which of the following is the most effective data
collection method for gathering real-time data from a website or application?Solution
APIs (Application Programming Interfaces) are the most effective and efficient method for collecting real-time data from websites or applications. APIs allow direct access to the underlying data structures of web services and applications, enabling the extraction of up-to-date information without human intervention. They are designed to handle frequent and automated requests, making them ideal for real-time data collection. APIs support various data formats like JSON or XML, ensuring seamless data integration into other systems or analysis platforms. Unlike web scraping, which can be less reliable and more resource-intensive, APIs provide structured access to data in a secure and efficient manner. Why Other Options Are Incorrect: • A: Surveys collect data based on responses from individuals and are not suited for real-time or continuous data collection. • B: Web scraping is an automated method of extracting data from websites, but it can be unreliable, inconsistent, and not always real-time, as it depends on the website’s structure. • D: Database queries are used to retrieve data from a structured database but do not apply directly to real-time data collection from external sources like websites or applications. • E: Interviews are a qualitative method of data collection that require manual interaction and are unsuitable for gathering real-time or automated data from websites or applications.
Which of the following statements about SQL `INDEXES` is generally TRUE?
Which of the following can be used to avoid duplicate entries in a column?
Which SQL clause is used to filter records based on aggregate functions?
In PL/SQL, what type of parameter allows a procedure to both receive a value from the calling environment and return a modified value back to it?
In SQL, the ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW clause applies to:
Which SQL constraint ensures that a column’s values are unique across the table?
Which SQL operator is used to search for a pattern in a column?
Which operator is used to combine results of two SELECT queries and remove duplicates?
Which SQL statement combines the results of two queries and removes duplicates?
In PL/SQL, what type of parameter allows a procedure to both receive a value from the calling environment and return a modified value back to it?