SDS Programming for business

Written by Saad Rahman (ACCA)

ACCA · New at Strategic Professional level · 7 questions

Name: ____________________   Date: ____________

1. In SQL, which clause filters groups after aggregation?

   • A WHERE
   • B HAVING
   • C FROM
   • D ORDER BY

2. Which SQL join keeps all rows from the left table and the matching rows from the right?

   • A INNER JOIN
   • B UNION
   • C LEFT JOIN
   • D CROSS JOIN only

3. In Python, which library is most commonly used for working with tables of data?

   • A random
   • B os
   • C pandas
   • D turtle

4. The SQL statement SELECT region, SUM(sales) FROM orders GROUP BY region returns:

   • A One row per region with total sales
   • B Only the largest region
   • C The average sales
   • D One row for each order

5. A join between a customer table and an orders table on the wrong column typically results in:

   • A Fewer errors
   • B Duplicated or incorrect rows
   • C A faster query
   • D No change

6. In Python, a list of values such as [10, 20, 30] can be used in a loop to:

   • A Encrypt the data
   • B Process each value in turn
   • C Format the screen
   • D Delete the database

7. A good practice when cleaning data in code is to:

   • A Keep the raw data unchanged and make the steps repeatable
   • B Delete all rows with any missing value
   • C Do the work by hand without notes
   • D Overwrite the original file