ETM 3310 X1 || with Errorless Answers.
Which SQL statement will return the quantity of all parts in Inventory with each PartName?
correct answers 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? correct answers nvarchar
When you perform a join, you are correct answers X
appending data from one table to another.
What data type should you use for a field that will store telephone numbers? correct answers
Short Text
A chart is based on data stored in cells. When the data in these cells is changed, the chart correct
answers is updated.
Excel uses a PMT function to calculate correct answers 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. correct
answers conditional formatting
When creating a calculated field in a query, the field name should be separated from the equation
by a(n) correct answers colon (:).
What does the word query mean? correct answers question
, A chart is a picture of numeric data and is sometimes referred to as a correct answers 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. correct answers 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 correct answers
=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? correct answers 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?
correct answers X
The formula will not change.
In this tier information is stored and retrieved from the database or file system. correct answers
Data
In a linked data situation, the worksheet that relies on the worksheet with the original data is
called the _____ worksheet. correct answers X
child
Which SQL statement will return the quantity of all parts in Inventory with each PartName?
correct answers 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? correct answers nvarchar
When you perform a join, you are correct answers X
appending data from one table to another.
What data type should you use for a field that will store telephone numbers? correct answers
Short Text
A chart is based on data stored in cells. When the data in these cells is changed, the chart correct
answers is updated.
Excel uses a PMT function to calculate correct answers 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. correct
answers conditional formatting
When creating a calculated field in a query, the field name should be separated from the equation
by a(n) correct answers colon (:).
What does the word query mean? correct answers question
, A chart is a picture of numeric data and is sometimes referred to as a correct answers 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. correct answers 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 correct answers
=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? correct answers 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?
correct answers X
The formula will not change.
In this tier information is stored and retrieved from the database or file system. correct answers
Data
In a linked data situation, the worksheet that relies on the worksheet with the original data is
called the _____ worksheet. correct answers X
child
