GoConqr hat ein neues Design! Sag uns, wie es dir gefällt.

Kostenlos registrieren

Quiz

2

Jake Jakes 22 Fragen

Quiz starten

Fragen in diesem Quiz (22)

  1. 1Which tables do you need to be able to gather data needed to calculate sales tax remittance for December 2025?Bild zu Frage 1
    1. AOrder Number
    2. BSalesOrders, SalesOrderExpenses
  2. 2What fields will you use to join the tables?Bild zu Frage 2
    1. AOrderSales
    2. BOrderNumber
  3. 3Which fields will you need to gather the information necessary to submit sales tax 2025Bild zu Frage 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?Bild zu Frage 4
    1. ARegions and Sales Order
    2. BSales Number and Order
  5. 5Which fields will you need to perform your analysis?Bild zu Frage 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.Bild zu Frage 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.Bild zu Frage 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 allBild zu Frage 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 tableBild zu Frage 10
    1. ALeft join
    2. BFull Join
    3. CInner join

Informationen

Beschreibung
University acc Quiz am 2, erstellt von Jake Jakes am 15/12/2024.
Sprache
English
Aufrufe
1
Schlagwörter
accuniversity
Bewertung
Noch keine Bewertungen
Bewerte dieses Quiz
Bewerte dieses Quiz

Feedback

Worum geht es?

Wie gefällt dir das neue Design?

Dein Eindruck