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
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
