¡GoConqr estrena diseño! Cuéntanos qué te parece.

Regístrate gratis

Test

2

Jake Jakes 22 preguntas

Hacer el test

Preguntas del test (22)

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

Información

Descripción
University acc Test sobre 2, creado por Jake Jakes el 15/12/2024.
Idioma
English
Visitas
1
Etiquetas
accuniversity
Valoración
Aún sin valoraciones
Valora este test
Valora este test

Escríbenos

¿Sobre qué es tu mensaje?

¿Qué te parece el nuevo diseño?

¿Te gusta?