ETM 3310 X1 EXAM QUESTIONS WITH ACCURATE ANSWERS

ETM 3310 X1 EXAM QUESTIONS WITH
ACCURATE ANSWERS

Which SQL statement will return the quantity of all parts in Inventory with each
PartName? - ANSWER X
SELECT Parts.PartName, Inventory.QuantityFROM PartsINNER JOIN
InventoryON Parts.PartNumber = Inventory.PartNumberGROUP BY
Parts.PartName

What data type is a string store as on a Microsoft SQL server database? -
ANSWER nvarchar

When you perform a join, you are - ANSWER X
appending data from one table to another.

What data type should you use for a field that will store telephone numbers? -
ANSWER Short Text

A chart is based on data stored in cells. When the data in these cells is changed,
the chart - ANSWER is updated.

Excel uses a PMT function to calculate - ANSWER payment for a loan based on
constant payments and a constant interest rate.

This feature allows you to apply formatting to data that meets a specific
criterion. - ANSWER conditional formatting

When creating a calculated field in a query, the field name should be separated
from the equation by a(n) - ANSWER colon (:).

What does the word query mean? - ANSWER question

A chart is a picture of numeric data and is sometimes referred to as a - ANSWER
X
report

When a relationship is established between two tables, the primary key in one
table is joined to the _____ key in the other table. - ANSWER X
secondary

, If you enter the formula =SUM(A2:C2) in cell D2 of your worksheet and then copy
it using a relative cell reference to cell D3, the formula in D3 will display as -
ANSWER =SUM(A3:C3).

Which SQL statement will return the PartName , PartNumber and date the part
was added to inventory? Sorted in ascending order by PartName? - ANSWER X
SELECT Parts.PartNumber, Parts.PartName, Time
FROM Parts
INNER JOIN Inventory ON Parts.PartNumber = Inventory.PartNumber
WHERE Inventory.Quantity = 0 ORDER BY Parts.PartName

If you enter the formula =SUM(A2:C2) in cell D2, what will happen if you copy it to
cell D3? - ANSWER X
The formula will not change.

In this tier information is stored and retrieved from the database or file system. -
ANSWER Data

In a linked data situation, the worksheet that relies on the worksheet with the
original data is called the _____ worksheet. - ANSWER X
child

When a field in a query contains two criteria statements, either of which can be
met to return results, this is referred to as a(n) _____ statement. - ANSWER X
Boolean

Which of the following data types is automatically filled when a new record is
added? - ANSWER AutoNumber

Which SQL statement will return the number of parts employee Emp2 has taken
from inventory. The SQL ABS aggregate function returns the absolute value of
an integer. - ANSWER X
SELECT ABS(SUM(Inventory.Quantity)) AS TotalFromInventoryFROM
InventoryWHERE EmpID = 'Emp2';

To create a report with the Report button, begin by - ANSWER X
opening the data source (table or query) in Design view.

Which SQL statement will return the quantity of all parts in Inventory with each
PartNumber? - ANSWER SELECT Parts.PartNumber,
SUM(Inventory.Quantity)FROM PartsINNER JOIN InventoryON
Parts.PartNumber = Inventory.PartNumber GROUP BY Parts.PartNumber

The EmpID in the Inventory table is a __________. - ANSWER foreign key

A file created in Excel is referred to as a - ANSWER workbook