GoConqr has a new look! Let us know what you think.

Sign up free

Quiz

2

Jake Jakes 22 questions

Take the quiz

Questions in this quiz (22)

  1. 1Which tables do you need to be able to gather data needed to calculate sales tax remittance for December 2025?Image for question 1
    1. AOrder Number
    2. BSalesOrders, SalesOrderExpenses
  2. 2What fields will you use to join the tables?Image for question 2
    1. AOrderSales
    2. BOrderNumber
  3. 3Which fields will you need to gather the information necessary to submit sales tax 2025Image for question 3
    1. ASales Tax from the SalesOrder Expenses table and OrderNumber, SoldDate, State from SalesOrders table, OrderNumber
    2. BOrderNumber, Sales Tax from the SalesOrder Expenses table and OrderNumber, SoldDate, State from SalesOrders table.
  4. 4Which tables do you need to gather the data necessary to analyze gross sales by region for 2024 and 2025?Image for question 4
    1. ARegions and Sales Order
    2. BSales Number and Order
  5. 5Which fields will you need to perform your analysis?Image for question 5
    1. AAll fields from the Regions table and SalesOrderNumber, SoldDate, RegionNumber, Sales Volume, UnitSalePrice from SalesOrders table.
    2. BSalesOrderNumber, SoldDate, RegionNumber, Sales Volume, UnitSalePrice from SalesOrders table.
  6. 6Assume you are a financial analyst in the controller's group for your distribution company. You have been asked to identify all inventory items without sales in the past year:
    - The IT group has provided the inventory on hand data file and the twelve month sales data file.
    • You have identified the inventory on hand table as the left table and the twelve month sales table as the right table. what Join is most appropriate?
    1. ALeft Join
    2. BRight Join
  7. 7Execute a query to join the Restaurant table (left table) and the Order table (right table), but only return the rows from both tables that have matching values.Image for question 7
    1. ALeft Join
    2. BInner Join
  8. 8Execute a query to join the Restaurant table (left table) and the Customer 1 (right table) table, and return all records from the Restaurant table, but only those matching records from the Customer 1table.Image for question 8
    1. ALeft Join
    2. BInner Join
  9. 9Execute a query to join the Order table (left table) and the Customer 1 table (right table), and return allImage for question 9
    1. ALeft Join
    2. BInner Join
    3. CFull join
  10. 10Execute a query to join the Order table (left table) and the Customer1 table (right table), and only return all the records from the Order table and the matching records from the Customer1 tableImage for question 10
    1. ALeft join
    2. BFull Join
    3. CInner join

Information

Description
University acc Quiz on 2, created by Jake Jakes on 15/12/2024.
Language
English
Views
1
Rating
No ratings yet
Rate this quiz
Rate this quiz

Feedback

What is it about?

What do you think of the new look?

How do you like it?