O GoConqr está de visual novo! Conte para nós o que você achou.

Registre-se grátis

Quiz

2

Jake Jakes 22 perguntas

Fazer o quiz

Perguntas do quiz (22)

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

Informações

Descrição
University acc Quiz sobre 2, criado por Jake Jakes em 15-12-2024.
Idioma
English
Visualizações
1
Etiquetas
accuniversity
Avaliação
Ainda sem avaliações
Avalie este quiz
Avalie este quiz

Fale Conosco

Sobre o que é sua mensagem?

O que você acha do novo visual?

Você gostou?