I85PREP
⌘ K
Industrial Engineer Office Automation study materials
Industrial Engineer Office Automation study resources

Industrial Engineer Office Automation practice questions

One question at a time. Build your Industrial Engineer Office Automation understanding.

First 50 of 200 questions. Each one lists the choices, the correct answer, and an explanation. The checker at the top of this page saves progress in this browser when it is available.

Continue in the practice tool above to load more questions, 50 at a time.

Question 1Office Automation Systems and Productivity Software

In a spreadsheet used to track production-line downtime, which cell reference style keeps the column letter and row number fixed when the formula is copied to other cells?

  1. Relative reference such as B4
  2. Structured reference such as Table1[Cost]
  3. Mixed reference such as B$4
  4. Absolute reference such as $B$4 Correct answer.

Explanation

An absolute reference places a dollar sign before both the column letter and the row number, so neither component shifts when the formula is filled across rows or columns. This is the standard way to anchor a fixed parameter cell, such as a downtime cost rate, in an engineering worksheet.

Question 2Office Automation Systems and Productivity Software

A work-study analyst wants a spreadsheet to display the text 'On Time' when a delivery variance is zero or negative and 'Late' otherwise. Which function is designed for this two-outcome test?

  1. VLOOKUP
  2. SUMIF
  3. IF Correct answer.
  4. CONCATENATE

Explanation

The IF function evaluates a logical test and returns one value when the test is true and another when it is false, which matches a two-outcome status label. SUMIF, VLOOKUP, and CONCATENATE perform conditional aggregation, lookup, or text joining rather than branching logic.

Question 3Office Automation Systems and Productivity Software

When preparing a monthly capacity report, an engineer wants the header row to repeat at the top of every printed page. Which page-setup feature accomplishes this?

  1. Header and footer insertion
  2. Freeze panes on the header row
  3. Page break preview scaling
  4. Print titles with rows to repeat at top Correct answer.

Explanation

The print titles setting lets you designate specific rows to repeat on each printed page, which is the intended control for table headers in multi-page reports. Freeze panes only affects on-screen scrolling, and headers/footers are page margins content rather than worksheet rows.

Question 4Office Automation Systems and Productivity Software

In a word-processing document containing a long bill of materials, which feature automatically generates a table of contents from heading styles?

  1. Automatic table of contents based on heading styles Correct answer.
  2. Cross-reference field to a bookmark
  3. Manual tab-aligned list typed by hand
  4. Index entry with concordance file

Explanation

An automatic table of contents collects paragraphs formatted with heading styles and builds entries with page numbers that can be refreshed after edits. Manual lists and cross-references do not rebuild themselves when headings or pagination change.

Question 5Office Automation Systems and Productivity Software

Which email practice best supports traceability when an engineer circulates a revised standard operating procedure for approval?

  1. Send a new message with no subject and attach the file
  2. Reply to the thread with the revision number in the subject line Correct answer.
  3. Post the file only in a personal folder
  4. Forward the file to each reviewer separately

Explanation

Keeping the reply in the existing thread and stating the revision number in the subject preserves the audit trail and lets reviewers see the prior discussion. Splitting messages or omitting identifiers breaks the chain of custody needed for document control.

Question 6Office Automation Systems and Productivity Software

An engineer needs to combine several department spreadsheets into one workbook view while keeping each source file separate. Which feature is appropriate?

  1. Paste values into a single sheet
  2. Apply conditional formatting
  3. Consolidate data from multiple workbooks Correct answer.
  4. Create a pivot chart

Explanation

The consolidate feature pulls ranges from multiple workbooks or sheets into a summary table by position or label while the source files remain independent. Pasting values is a one-time manual copy, and charts or formatting do not merge source data.

Question 7Office Automation Systems and Productivity Software

In a presentation for a plant layout review, which practice keeps text legible when projected in a large meeting room?

  1. Use decorative script fonts throughout
  2. Fill each slide with full paragraphs at small font size
  3. Place all narrative in speaker notes only
  4. Limit each slide to a few short bullet points in a large font Correct answer.

Explanation

Slides are visual aids, so sparse bullets in a large font remain readable from the back of a room while the presenter supplies detail verbally. Dense paragraphs, decorative scripts, and notes-only slides either become illegible or leave the audience without visual support.

Question 8Office Automation Systems and Productivity Software

Which file format preserves the exact layout of a completed engineering report so recipients cannot easily alter its formatting?

  1. PDF Correct answer.
  2. TXT
  3. CSV
  4. RTF

Explanation

Portable Document Format embeds fonts and layout so the document renders consistently on other systems, which suits finalized reports distributed for review. Plain text, CSV, and RTF discard or reinterpret layout elements such as tables and graphics.

Question 9Office Automation Systems and Productivity Software

A spreadsheet stores machine run times in column A and shift names in column B. Which function returns the total run time for the 'Night' shift only?

  1. MAX(B:B)
  2. AVERAGE(A:A)
  3. COUNTIF(B:B,"Night")
  4. SUMIF(B:B,"Night",A:A) Correct answer.

Explanation

SUMIF takes a criteria range, a criterion, and a sum range, so it adds the run times in column A where column B equals 'Night'. COUNTIF would only count matching rows, while AVERAGE and MAX ignore the shift criterion entirely.

Question 10Office Automation Systems and Productivity Software

An analyst builds a PivotTable from a maintenance log to show total repair hours by equipment type. Which field placement produces that summary?

  1. Repair hours in Rows and equipment type in Values with Count
  2. Repair hours in Rows and date in Values with Average
  3. Equipment type in Rows and repair hours in Values with Sum Correct answer.
  4. Equipment type in Filters and repair hours in Columns

Explanation

Placing the category field in Rows and the numeric measure in Values with the Sum aggregation yields one total per equipment type. Swapping the fields or using Count produces counts rather than summed hours.

Question 11Office Automation Systems and Productivity Software

A formula in cell D10 returns #REF! after rows above it were deleted. What is the most likely cause?

  1. The formula divides by a cell containing zero
  2. The formula referenced a cell or range that was removed Correct answer.
  3. The formula omits a required argument separator
  4. The formula contains a text value where a number is required

Explanation

The #REF! error signals an invalid reference, typically because the referenced cells or sheet were deleted. Division by zero yields #DIV/0!, text in a numeric argument yields #VALUE!, and a separator problem usually produces a syntax warning.

Question 12Office Automation Systems and Productivity Software

An engineer wants to look up a standard time from a rate table where the lookup column is to the right of the value to be returned. Which function handles a leftward lookup directly?

  1. SUMIF
  2. HLOOKUP
  3. XLOOKUP Correct answer.
  4. VLOOKUP

Explanation

XLOOKUP accepts separate lookup and return ranges, so the return column may sit to the left of the lookup column. VLOOKUP and HLOOKUP require the key in the first column or row of the searched range, and SUMIF aggregates rather than retrieves.

Question 13Office Automation Systems and Productivity Software

A word-processing template must place the document number and page count in the top margin of every page. Which element is designed for this?

  1. A header field containing document properties and page numbers Correct answer.
  2. A text box anchored to the first paragraph
  3. A comment attached to the title
  4. A footnote at the bottom of the first page

Explanation

Headers repeat on every page and can hold fields that pull document properties and automatic page numbers, giving consistent identification across the file. Footnotes, anchored text boxes, and comments do not repeat automatically in the margin.

Question 14Office Automation Systems and Productivity Software

A shared procedure document is edited by several engineers and must show who changed each clause. Which feature provides this?

  1. Track changes with reviewer attribution Correct answer.
  2. Automatic spell check
  3. Read-only password protection
  4. Document comparison against a blank file

Explanation

Track changes records each insertion, deletion, and formatting edit together with the reviewer's identity, which supports controlled review of a shared procedure. Read-only protection blocks editing, spell check ignores authorship, and comparing to a blank file yields no attribution.

Question 15Office Automation Systems and Productivity Software

An engineer must send a 40 MB drawing package that exceeds the corporate email attachment limit. Which approach respects typical mail policy?

  1. Split the file into many attachments across messages
  2. Rename the file extension to bypass the filter
  3. Compress the file and resend repeatedly
  4. Upload to the approved shared repository and send a link Correct answer.

Explanation

Placing large files in the organization's approved repository and sharing a link keeps messages within size limits and preserves access control and versioning. Splitting, repeated resends, or renaming extensions either still breach limits or violate policy.

Question 16Office Automation Systems and Productivity Software

A spreadsheet cell shows ##### across its width. What does this indicate?

  1. The column is too narrow to display the numeric result Correct answer.
  2. The workbook is protected against editing
  3. The formula contains a circular reference
  4. The cell holds text where a number is expected

Explanation

A row of hash marks means the column width cannot display the formatted number or date, and widening the column resolves it. Circular references and type mismatches raise distinct warnings or error codes rather than this display pattern.

Question 17Office Automation Systems and Productivity Software

Which spreadsheet technique best tests how total operating cost responds to a range of machine utilization rates without manually rebuilding the model?

  1. Merging the utilization cells
  2. Sorting the cost column descending
  3. A one-variable data table over the utilization input Correct answer.
  4. Freezing the utilization cell

Explanation

A one-variable data table recalculates a chosen output for a series of input values, which is exactly a sensitivity sweep over utilization. Freezing, sorting, and merging affect display or structure and do not compute alternative scenarios.

Question 18Office Automation Systems and Productivity Software

An engineer wants to highlight every row in a quality log where the defect count exceeds a control limit. Which feature applies formatting automatically based on the cell value?

  1. Conditional formatting with a cell-value rule Correct answer.
  2. Data validation with an input message
  3. Sheet protection
  4. Cell styles applied manually

Explanation

Conditional formatting evaluates a rule and applies the format only when the condition, such as exceeding a limit, is met, and it updates as values change. Manual styles, validation messages, and protection do not respond dynamically to values.

Question 19Office Automation Systems and Productivity Software

A presentation must show a trend in monthly scrap rates across twelve months for a management review. Which chart choice communicates the trend most clearly?

  1. A stacked bar chart of one month
  2. A line chart with months on the horizontal axis Correct answer.
  3. A pie chart of all twelve months
  4. A scatter chart of month numbers only

Explanation

A line chart places time on the horizontal axis and connects successive values, making direction and rate of change easy to read. Pie charts show parts of a whole, a single-month bar omits the trend, and a scatter of month numbers alone carries no scrap values.

Question 20Office Automation Systems and Productivity Software

A workbook used for shift scheduling must let planners pick only from a fixed list of approved shift codes. Which feature enforces this?

  1. Conditional formatting on the code column
  2. Data validation with a list source Correct answer.
  3. Text wrapping in the cells
  4. A pivot table of shift codes

Explanation

Data validation with a list restricts entries to predefined values and can reject anything outside the approved codes. Formatting, pivot summaries, and wrapping affect appearance or analysis but do not control what can be typed.

Question 21Office Automation Systems and Productivity Software

An engineer receives a workbook where a cost total is wrong. The total cell contains =SUM(B2:B9), but rows 10 through 14 also hold cost entries. What is the most likely explanation?

  1. The cost column is formatted as text
  2. The workbook calculation mode is manual
  3. The sum range excludes rows 10 through 14 Correct answer.
  4. The sheet is protected

Explanation

The formula's range stops at row 9, so any entries in rows 10 through 14 are outside the summed area and the total will be understated. Manual calculation would leave stale results everywhere, text formatting would prevent summation of those cells, and protection would block editing rather than silently omit rows.

Question 22Office Automation Systems and Productivity Software

Two versions of a capacity model exist: one links to external source workbooks, the other contains pasted values. Which statement correctly describes the trade-off?

  1. The pasted model updates automatically whenever sources change
  2. The linked model is always smaller in file size and never needs refreshing
  3. Both models behave identically when source files are renamed
  4. The linked model updates with source changes but breaks if sources move; the pasted model is stable but static Correct answer.

Explanation

External links propagate updates from source files but depend on those files remaining at the referenced location, whereas pasted values are self-contained and immune to link breakage but never refresh. Renaming or moving sources breaks links, so the two models do not behave identically.

Question 23Office Automation Systems and Productivity Software

A shared master schedule is stored on a network drive. Two planners open it, edit different rows, and each saves. What is the primary risk with a simple file-share workflow?

  1. The file automatically merges both sets of edits
  2. Version history is created for every save by the file server
  3. Row-level locking always prevents conflicting saves
  4. The second save can overwrite the first planner's changes Correct answer.

Explanation

Without co-authoring controls, the last save wins and earlier edits can be lost when two users work from separate copies. Automatic merging, guaranteed row locking, and per-save version history are properties of managed collaboration platforms, not plain file shares.

Question 24Office Automation Systems and Productivity Software

A macro-enabled workbook is received from an external supplier and must be reviewed before use. Which control most directly reduces the risk of running malicious code?

  1. Enable all macros so the file loads completely
  2. Rename the file to remove the macro extension
  3. Open it in protected view with macros disabled until the source is verified Correct answer.
  4. Convert it to PDF before opening

Explanation

Protected view and disabled macros let the reviewer inspect content without executing embedded code, which is the standard defense against macro-borne threats. Enabling macros executes the code, and converting or renaming does not neutralize the payload if the file is later reopened in its original form.

Question 25Office Automation Systems and Productivity Software

An engineer builds a dashboard where several charts reference named ranges. After a row is inserted inside a named range, some charts fail to update. Which explanation is most consistent?

  1. The named range was defined with fixed cell addresses that did not expand Correct answer.
  2. Inserting rows always corrupts chart data caches
  3. Named ranges only work with pivot tables
  4. Charts cannot reference named ranges at all

Explanation

A name defined as a static address like Sheet1!$A$1:$A$20 does not grow when rows are inserted, so new data falls outside the range and charts appear stale. Charts do support named ranges, and inserting rows does not inherently corrupt chart caches.

Question 26Office Automation Systems and Productivity Software

An industrial engineer prepares a weekly productivity report in a spreadsheet. Which built-in feature automatically recalculates totals and charts when source cells are edited, without rerunning any separate command?

  1. Freeze Panes on the data sheet
  2. Automatic workbook calculation mode Correct answer.
  3. Manual calculation mode with F9
  4. Paste Special with values only

Explanation

In automatic calculation mode the spreadsheet engine recalculates dependent formulas whenever precedent cells change, so totals and linked charts refresh immediately. Manual mode requires the user to trigger recalculation, and pasting values breaks the live link to source data.

Question 27Office Automation Systems and Productivity Software

A time-study workbook must record observations in minutes but the standard is reported in hours. Which approach converts all recorded values consistently while preserving the original observations for audit?

  1. Divide the final total only, after summing all observations
  2. Add a helper column that multiplies each observation by 1/60 and build reports from it Correct answer.
  3. Overwrite each observed value with its hour equivalent
  4. Change the workbook's default number format to hours

Explanation

A helper column keeps the raw minute observations intact for audit while producing a derived hour value that reports and charts can reference. Overwriting destroys the source data, and changing number format alone does not change the underlying value.

Question 28Office Automation Systems and Productivity Software

An engineer wants one workbook to print a cover page in portrait and the following data sheets in landscape. Which setting achieves this within a single workbook?

  1. Scale every sheet to fit one page wide
  2. Set the print orientation per worksheet in Page Setup Correct answer.
  3. Insert manual page breaks between the sheets
  4. Set one orientation for the whole workbook at save time

Explanation

Page Setup orientation is a per-worksheet property, so each sheet can carry its own portrait or landscape setting in the same workbook. Workbook-level settings do not override individual sheet page setup for orientation.

Question 29Office Automation Systems and Productivity Software

A capacity planning sheet must show the month name derived from a stored date in cell A2. Which function returns the full month name as text?

  1. =DAY(A2)
  2. =TEXT(A2,"mmmm") Correct answer.
  3. =YEAR(A2)
  4. =MONTH(A2)

Explanation

TEXT converts a date serial into a formatted text string, and the code "mmmm" yields the full month name. MONTH returns a month number from 1 to 12, which is not a name.

Question 30Office Automation Systems and Productivity Software

An engineer needs to count how many work orders in a maintenance log meet two conditions at once: priority equals "High" and downtime exceeds 4 hours. Which function is designed for multiple criteria across ranges?

  1. COUNTA over the priority column
  2. SUMIF over the downtime column
  3. COUNTIFS with one criteria range and criterion per condition Correct answer.
  4. COUNTIF with the two criteria concatenated

Explanation

COUNTIFS accepts paired criteria ranges and criteria, counting rows that satisfy every condition simultaneously. COUNTIF handles only a single condition, and COUNTA counts non-empty cells regardless of value.

Question 31Office Automation Systems and Productivity Software

A quality log has defect counts in column C. The engineer wants a cell to display "Escalate" when the count exceeds 10 and "Monitor" otherwise. Which construct returns this result?

  1. =IF(C2>10,"Escalate")
  2. =AND(C2>10,"Escalate","Monitor")
  3. =IF(C2>10,"Escalate","Monitor") Correct answer.
  4. =IF("Escalate",C2>10,"Monitor")

Explanation

The IF function takes a logical test, a value-if-true, and a value-if-false, so this returns one of the two text labels based on the comparison. Omitting the third argument returns FALSE rather than the label.

Question 32Office Automation Systems and Productivity Software

An engineer builds a two-variable data table to see how total cost changes across combinations of labor rate and machine hours. Which spreadsheet capability does this rely on?

  1. Goal Seek on a single input cell
  2. Scenario Manager with named scenarios
  3. Solver with integer constraints
  4. What-if data table with row and column input cells Correct answer.

Explanation

A two-variable data table recalculates one result formula across a grid of values supplied by a row input cell and a column input cell. Goal Seek and Solver solve for a target by adjusting inputs, which is a different operation.

Question 33Office Automation Systems and Productivity Software

To prevent accidental edits to a finalized standards sheet while still allowing users to enter data in designated input cells, which two-step approach is correct?

  1. Convert the sheet to a read-only PDF
  2. Hide the sheet, then apply a password to open the file
  3. Protect the sheet first, then lock all cells
  4. Lock all cells, then protect the sheet with a password Correct answer.

Explanation

Cell locking takes effect only when worksheet protection is enabled, so cells must be locked (with input cells left unlocked) before protection is applied. Applying protection before adjusting locks leaves the current lock state in force.

Question 34Office Automation Systems and Productivity Software

An engineer needs a chart that compares the number of safety incidents recorded in five separate plants, where the categories are distinct and not part of a continuous trend. Which chart type is most appropriate?

  1. Scatter chart with connected points
  2. Line chart
  3. Pie chart with a single series
  4. Clustered column chart Correct answer.

Explanation

A column chart compares discrete category magnitudes side by side, making differences between plants easy to read. Line and scatter charts imply a continuous ordered relationship, and a pie chart suits part-to-whole shares rather than direct magnitude comparison.

Question 35Office Automation Systems and Productivity Software

A workbook template must display the current date automatically each time it is opened, formatted as a standard short date. Which function or feature provides this?

  1. =TODAY() in a cell formatted as a date Correct answer.
  2. Typing the date manually in a cell
  3. =NOW() with the cell formatted as text
  4. A static date stored in a named constant

Explanation

TODAY returns the current date serial, which updates on each recalculation, and a date number format displays it as a short date. Typing or storing a static date does not update.

Question 36Office Automation Systems and Productivity Software

An engineer must consolidate monthly overtime totals from twelve identically structured worksheets into a summary sheet that stays linked to the source sheets. Which method preserves the live links?

  1. Use a 3-D reference such as =SUM(Jan:Dec!D20) Correct answer.
  2. Type the twelve totals manually into the summary
  3. Create a PivotTable from a pasted static list
  4. Copy each monthly total and paste as values

Explanation

A 3-D reference spans a range of identically structured sheets and sums the same cell across them, keeping the summary linked to source data. Pasting values or typing totals severs the link and will not refresh.

Question 37Office Automation Systems and Productivity Software

A workbook contains a lookup where the returned value must come from a column positioned to the left of the lookup column. Which function handles this limitation?

  1. INDEX combined with MATCH Correct answer.
  2. HLOOKUP with an approximate match
  3. VLOOKUP with an exact match
  4. CHOOSE with a fixed index number

Explanation

INDEX returns a value at a given row and column position, and MATCH locates the row position of the lookup value, so together they can return values to the left of the lookup column. VLOOKUP can only return values to the right of its lookup column.

Question 38Office Automation Systems and Productivity Software

A summary sheet must pull the latest utilization figure from a workbook saved on a shared network path, and the figure should refresh when the source file changes. Which approach maintains an external link?

  1. Paste the figure as a static value into the summary
  2. Copy the entire source workbook into the summary workbook
  3. Insert the figure as an image on the summary sheet
  4. Reference the external file path in the formula and keep the link enabled Correct answer.

Explanation

An external reference formula pointing to the source file path keeps the summary linked, and enabling link updates lets the value refresh when the source changes. Static pastes and images do not update.

Question 39Office Automation Systems and Productivity Software

A macro-enabled workbook from an external supplier must be reviewed before any automated content runs. Which control most directly reduces risk before opening it?

  1. Rename the file extension to .xlsx
  2. Open the file and immediately run all macros to test them
  3. Move the file to a shared network folder
  4. Disable macros and open the file in Protected View before enabling anything Correct answer.

Explanation

Disabling macros and opening in Protected View prevents automated code from executing while the content is inspected. Renaming the extension does not remove the embedded code, and running macros to test them executes the very code in question.

Question 40Office Automation Systems and Productivity Software

A workbook uses several named ranges that feed dashboard charts. After a new row is inserted inside the data region of a named range, some charts stop updating the new row. Which explanation is most likely?

  1. The chart type does not support named ranges
  2. The workbook calculation mode was set to automatic
  3. Charts never read named ranges at all
  4. The named range was defined with fixed cell addresses rather than a dynamic formula Correct answer.

Explanation

A name defined with fixed addresses does not expand when rows are inserted inside the region, so the new row falls outside the referenced range. Defining the name with a dynamic formula such as OFFSET or a structured table reference lets the range grow.

Question 41Information Systems, Databases, and Data Management

In a relational database used to track maintenance work orders, which property of a primary key ensures that two different work orders can never share the same identifier?

  1. Atomicity
  2. Uniqueness Correct answer.
  3. Referential integrity
  4. Normalization

Explanation

A primary key must be unique, meaning no two rows in the table can hold the same key value, so each work order is individually identifiable. Referential integrity concerns matching foreign keys to existing parent rows, atomicity is a transaction property, and normalization is a design technique for reducing redundancy.

Question 42Information Systems, Databases, and Data Management

An office automation system stores each employee's department code in the employee record, and the department table holds the code plus the department name and manager. Which term describes the department code stored in the employee table?

  1. Foreign key Correct answer.
  2. Candidate key
  3. Surrogate key
  4. Composite key

Explanation

A foreign key is a column in one table that references the primary key of another table, which is exactly how the department code links employees to their department. Candidate keys are possible primary keys within the same table, a surrogate key is a system-generated identifier, and a composite key spans multiple columns.

Question 43Information Systems, Databases, and Data Management

Which SQL clause is used to filter individual rows returned by a query before any grouping is applied?

  1. GROUP BY
  2. ORDER BY
  3. HAVING
  4. WHERE Correct answer.

Explanation

The WHERE clause filters rows as they are read, before grouping or aggregation takes place. HAVING filters groups after aggregation, ORDER BY sorts the result, and GROUP BY forms the groups themselves.

Question 44Information Systems, Databases, and Data Management

A clerk needs to retrieve all records from a service-request table where the priority is exactly 'High'. Which SQL statement accomplishes this?

  1. SELECT * FROM service_request HAVING priority = 'High';
  2. SELECT * FROM service_request WHERE priority = 'High'; Correct answer.
  3. SELECT priority FROM service_request WHERE * = 'High';
  4. SELECT * FROM service_request ORDER BY priority = 'High';

Explanation

Row-level filtering on a column value uses WHERE with an equality predicate, so the first statement returns every column for rows whose priority equals 'High'. HAVING requires grouping context, the third statement misplaces the wildcard, and ORDER BY sorts rather than filters.

Question 45Information Systems, Databases, and Data Management

In a database, a transaction that transfers a stock item from one warehouse record to another completes fully or leaves both records unchanged. Which ACID property does this describe?

  1. Atomicity Correct answer.
  2. Isolation
  3. Durability
  4. Consistency

Explanation

Atomicity guarantees that a transaction is treated as a single indivisible unit, so either all of its changes are applied or none are. Durability concerns persistence after commit, isolation concerns concurrent transactions, and consistency concerns preserving declared rules.

Question 46Information Systems, Databases, and Data Management

Which data model organizes information as a set of two-dimensional tables with rows and columns and is queried with SQL?

  1. Hierarchical model
  2. Object-oriented model
  3. Key-value model
  4. Relational model Correct answer.

Explanation

The relational model represents data as tables (relations) of rows and columns and is queried with SQL. The hierarchical model uses parent-child trees, the object-oriented model stores objects with methods, and the key-value model maps keys to opaque values.

Question 47Information Systems, Databases, and Data Management

An administrative office wants to keep a single authoritative list of approved suppliers used by every purchasing form. Which data management practice best prevents duplicate, conflicting supplier entries?

  1. Archiving suppliers in monthly backup files
  2. Maintaining a master data record for suppliers referenced by all forms Correct answer.
  3. Copying the supplier list into each form's local file
  4. Letting each clerk type supplier names freely

Explanation

Master data management establishes one authoritative, shared record that all applications reference, which prevents divergent duplicates. Local copies, free-text entry, and backups each allow conflicting versions to proliferate.

Question 48Information Systems, Databases, and Data Management

Which statement correctly distinguishes a database from a spreadsheet when both are used to hold office records?

  1. A database cannot be queried, whereas a spreadsheet supports formulas.
  2. A database enforces shared constraints and concurrent multi-user access, while a spreadsheet is primarily a single-file calculation tool. Correct answer.
  3. A spreadsheet automatically enforces referential integrity across related tables.
  4. A database can only store numeric data, whereas a spreadsheet can store text.

Explanation

A database management system enforces integrity constraints and controls concurrent access by many users, which is its core advantage over a file-based spreadsheet. Databases store text as well as numbers, spreadsheets do not natively enforce cross-table referential integrity, and databases are explicitly queryable.

Question 49Information Systems, Databases, and Data Management

A query joins the work_order table to the technician table on technician_id. Which join type returns only work orders that have a matching technician and excludes unmatched work orders?

  1. CROSS JOIN
  2. INNER JOIN Correct answer.
  3. FULL OUTER JOIN
  4. LEFT OUTER JOIN

Explanation

An inner join returns only rows where the join condition finds a match in both tables, so unmatched work orders are dropped. A left outer join keeps unmatched left rows, a full outer join keeps unmatched rows from both sides, and a cross join produces every combination.

Question 50Information Systems, Databases, and Data Management

A table storing service tickets repeatedly stores the full department name and manager name on every ticket row. Which normalization step removes this redundancy by moving department attributes into a separate department table?

  1. Denormalization applied to add redundancy
  2. Third normal form applied to remove transitive dependencies Correct answer.
  3. Second normal form applied to remove partial dependencies
  4. First normal form applied to remove repeating groups

Explanation

When a non-key attribute such as manager name depends on another non-key attribute (department name) rather than directly on the primary key, the dependency is transitive, and third normal form removes it by separating the department entity. Second normal form addresses partial dependencies on part of a composite key, first normal form removes repeating groups, and denormalization deliberately adds redundancy.