ETM 3310 -4 EXAM QUESTIONS WITH
COMPLETE ANSWERS
Which SQL statement will return the PartName , PartNumber and date the part was
added to inventory? Sorted in ascending order by PartName? - ANSWER SELECT
Parts.PartNumber, Parts.PartName, TimeFROM PartsINNER JOIN Inventory ON
Parts.PartNumber = Inventory.PartNumberWHERE Inventory.Quantity > 0ORDER BY
Parts.PartName
A question that can be answered with a true or false is considered a - ANSWER logical
test.
If you enter the formula =SUM(A2:C2) in cell D2, what will happen if you copy it to cell
D3? - ANSWER The formula will change to =SUM(A3:C3).
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 Or
When creating a calculated field in a query, the field name should be separated from the
equation by a(n) - ANSWER colon (:).
What is the relationship between the Employees table and the Inventory table? -
ANSWER one to many
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.PartNumberGROUP BY
Parts.PartNumber
Which SQL statement or statements will introduce a part p1-1 into the system. Assume
employee Emp1 has be inserted into the Employees table. - ANSWER INSERT INTO
Parts (PartNumber, PartName,Cost) VALUES ('p1-1','Part 1', 10.00); INSERT INTO
, Inventory (PartNumber, Quantity, EmpID, Time) VALUES (''p1-1', 0, 'Emp1',GETDATE());
Which button is useful for capturing information from a web page or from a file in
another program? - ANSWER Screenshot
What does PDF stand for? - ANSWER portable document format
This type of chart shows change over time at even intervals and emphasizes the rate of
change rather than the magnitude of change. - ANSWER line
The first step in creating a chart is to - ANSWER select the cells that contain the data
you want to chart.
Excel uses a PMT function to calculate - ANSWER payment for a loan based on constant
payments and a constant interest rate.
To export an Access table to Excel, begin by - ANSWER clicking the table in the
navigation pane.
A group of selected cells is referred to as a - ANSWER range.
What is the primary key in the Employees table from the SQL Inventory database? -
ANSWER EmpID
What data type is a string store as on a Microsoft SQL server database? - ANSWER
nvarchar
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
COMPLETE ANSWERS
Which SQL statement will return the PartName , PartNumber and date the part was
added to inventory? Sorted in ascending order by PartName? - ANSWER SELECT
Parts.PartNumber, Parts.PartName, TimeFROM PartsINNER JOIN Inventory ON
Parts.PartNumber = Inventory.PartNumberWHERE Inventory.Quantity > 0ORDER BY
Parts.PartName
A question that can be answered with a true or false is considered a - ANSWER logical
test.
If you enter the formula =SUM(A2:C2) in cell D2, what will happen if you copy it to cell
D3? - ANSWER The formula will change to =SUM(A3:C3).
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 Or
When creating a calculated field in a query, the field name should be separated from the
equation by a(n) - ANSWER colon (:).
What is the relationship between the Employees table and the Inventory table? -
ANSWER one to many
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.PartNumberGROUP BY
Parts.PartNumber
Which SQL statement or statements will introduce a part p1-1 into the system. Assume
employee Emp1 has be inserted into the Employees table. - ANSWER INSERT INTO
Parts (PartNumber, PartName,Cost) VALUES ('p1-1','Part 1', 10.00); INSERT INTO
, Inventory (PartNumber, Quantity, EmpID, Time) VALUES (''p1-1', 0, 'Emp1',GETDATE());
Which button is useful for capturing information from a web page or from a file in
another program? - ANSWER Screenshot
What does PDF stand for? - ANSWER portable document format
This type of chart shows change over time at even intervals and emphasizes the rate of
change rather than the magnitude of change. - ANSWER line
The first step in creating a chart is to - ANSWER select the cells that contain the data
you want to chart.
Excel uses a PMT function to calculate - ANSWER payment for a loan based on constant
payments and a constant interest rate.
To export an Access table to Excel, begin by - ANSWER clicking the table in the
navigation pane.
A group of selected cells is referred to as a - ANSWER range.
What is the primary key in the Employees table from the SQL Inventory database? -
ANSWER EmpID
What data type is a string store as on a Microsoft SQL server database? - ANSWER
nvarchar
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
