I85PREP
⌘ K
MATSEC AM Information Technology study materials
MATSEC AM Information Technology study resources

MATSEC AM Information Technology practice questions

One question at a time. Build your MATSEC AM Information Technology 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 1Information Technology

In a relational database, which key uniquely identifies each row of a table and cannot contain null values?

  1. Primary key Correct answer.
  2. Foreign key
  3. Alternate key
  4. Candidate key

Explanation

A primary key is the chosen candidate key that uniquely identifies every row and is constrained to be NOT NULL. Foreign keys reference other tables, candidate keys are any minimal unique identifiers, and alternate keys are candidates not chosen as primary.

Question 2Information Technology

A student table stores a repeating set of module codes in a single column as comma-separated text. Which normal form does this design violate first?

  1. Boyce-Codd normal form
  2. Second normal form
  3. First normal form Correct answer.
  4. Third normal form

Explanation

First normal form requires every attribute to hold a single atomic value; storing a list of module codes in one column is a repeating group. Violations of 2NF and 3NF presuppose a relation already in 1NF.

Question 3Information Technology

Which statement correctly describes the purpose of an SQL JOIN?

  1. It combines rows from two tables based on a related column. Correct answer.
  2. It merges two tables into a single permanent physical table.
  3. It removes duplicate rows from a result set.
  4. It sorts the result set by a chosen column.

Explanation

A JOIN produces a combined result set by matching rows from two tables on a related column, typically a foreign key to primary key pair. It does not alter the stored schema, deduplicate rows, or order output.

Question 4Information Technology

A query uses WHERE price > 100 AND category = 'books'. Which rows are returned?

  1. All rows costing more than 100 regardless of category
  2. Rows that are books or cost more than 100
  3. Rows that are books and cost more than 100 Correct answer.
  4. All books regardless of price

Explanation

AND requires both conditions to be true for a row to qualify, so only rows that are books priced above 100 are returned. OR would relax the test to either condition.

Question 5Information Technology

Which IP address range is reserved for private use under RFC 1918 in the class A block?

  1. 10.0.0.0 to 10.255.255.255 Correct answer.
  2. 172.16.0.0 to 172.31.255.255
  3. 169.254.0.0 to 169.254.255.255
  4. 192.168.0.0 to 192.168.255.255

Explanation

RFC 1918 defines three private ranges; the single class A range is 10.0.0.0/8. The other options list the class B private range, the class C private range, and the link-local range respectively.

Question 6Information Technology

A subnet mask of 255.255.255.192 is applied to a network. How many usable host addresses does each subnet provide?

  1. 30
  2. 62 Correct answer.
  3. 126
  4. 64

Explanation

The final octet 192 is 11000000, leaving six host bits. Two to the power six is 64 addresses, and subtracting the network and broadcast addresses gives 62 usable hosts.

Question 7Information Technology

Which protocol operates at the transport layer and provides reliable, connection-oriented delivery with acknowledgements?

  1. IP
  2. UDP
  3. ICMP
  4. TCP Correct answer.

Explanation

TCP is connection-oriented and uses sequence numbers, acknowledgements, and retransmission to provide reliable delivery. UDP is connectionless, IP is a network-layer protocol, and ICMP carries control and error messages.

Question 8Information Technology

A user types a domain name into a browser. Which service resolves that name to an IP address?

  1. DNS Correct answer.
  2. DHCP
  3. ARP
  4. NAT

Explanation

The Domain Name System maps human-readable names to IP addresses through a hierarchy of resolvers and name servers. DHCP assigns addresses, ARP maps IP to MAC, and NAT translates addresses.

Question 9Information Technology

Which statement best describes the role of a compiler?

  1. It converts assembly language into machine code.
  2. It translates all source code into machine code before execution. Correct answer.
  3. It executes source code one statement at a time.
  4. It links separately compiled object files into an executable.

Explanation

A compiler translates the whole source program into object or machine code ahead of execution, reporting errors across the entire program. Interpreters execute statement by statement, linkers combine object files, and assemblers handle assembly language.

Question 10Information Technology

In a high-level language, which construct is a count-controlled loop?

  1. IF statement
  2. FOR loop Correct answer.
  3. REPEAT...UNTIL loop
  4. WHILE loop

Explanation

A FOR loop runs a known number of iterations determined by its start, end, and step values, making it count-controlled. WHILE and REPEAT loops are condition-controlled, and IF is a selection construct.

Question 11Information Technology

A procedure is passed an integer parameter by value. What happens to the original variable in the calling program?

  1. It is deleted once the procedure finishes.
  2. It is shared with the procedure so both names refer to the same storage.
  3. It is unchanged because a copy of the value is passed. Correct answer.
  4. It is updated because the procedure receives a reference to it.

Explanation

Passing by value copies the argument into the parameter, so changes inside the procedure affect only the local copy. The caller's variable is altered only when a parameter is passed by reference.

Question 12Information Technology

A recursive function lacks a correct base case. What is the most likely consequence at run time?

  1. The call stack keeps growing until a stack overflow occurs. Correct answer.
  2. The function returns zero automatically.
  3. The loop counter is reset and the program restarts.
  4. The compiler rejects the program before execution.

Explanation

Without a base case, each call invokes another call and stack frames accumulate until the call stack is exhausted, producing a stack overflow. This is a run-time failure, not a compile-time error.

Question 13Information Technology

Which data structure follows a last-in, first-out order?

  1. Linked list
  2. Binary search tree
  3. Queue
  4. Stack Correct answer.

Explanation

A stack pushes and pops from the same end, so the most recently added item is removed first. A queue is first-in, first-out, while linked lists and trees are not defined by LIFO ordering.

Question 14Information Technology

In a binary search of a sorted array of 1000 elements, approximately how many comparisons are needed in the worst case?

  1. 10 Correct answer.
  2. 500
  3. 1000
  4. 100

Explanation

Binary search halves the search space each time, so the worst case is about log base 2 of 1000, which is close to 10 comparisons. Linear scanning would require up to 1000 comparisons.

Question 15Information Technology

Which sorting algorithm has an average time complexity of O(n log n) and repeatedly partitions the data around a pivot?

  1. Insertion sort
  2. Quicksort Correct answer.
  3. Bubble sort
  4. Selection sort

Explanation

Quicksort partitions the array around a pivot and recursively sorts the partitions, giving O(n log n) on average. Bubble, insertion, and selection sorts are all O(n squared) on average.

Question 16Information Technology

Which statement about the two's complement representation of signed integers is correct?

  1. It uses a separate sign bit and stores the magnitude unchanged.
  2. It cannot represent the value zero.
  3. It stores negative numbers as their positive binary value with a leading zero.
  4. It represents negative numbers by inverting the bits and adding one. Correct answer.

Explanation

In two's complement, a negative value is formed by inverting all bits of the positive value and adding one, which allows addition and subtraction to use the same circuitry. The method has a single representation of zero.

Question 17Information Technology

A bitmap image is 200 pixels wide by 100 pixels high with a colour depth of 8 bits. What is its uncompressed size in bytes?

  1. 2400
  2. 2000
  3. 20000 Correct answer.
  4. 160000

Explanation

The image has 200 times 100 equals 20000 pixels, and at 8 bits per pixel that is 20000 bytes. Multiplying by 8 would give bits rather than bytes.

Question 18Information Technology

Which statement distinguishes lossy from lossless compression?

  1. Lossy compression always produces larger files than lossless compression.
  2. Lossy compression removes redundant data and restores it exactly on decompression.
  3. Lossless compression only works on text files.
  4. Lossy compression discards some data permanently, whereas lossless compression allows exact reconstruction. Correct answer.

Explanation

Lossy methods such as JPEG discard detail that cannot be recovered, while lossless methods such as PNG allow the original data to be rebuilt exactly. Lossless compression is not restricted to text.

Question 19Information Technology

In the fetch-decode-execute cycle, which register holds the address of the next instruction to be fetched?

  1. Accumulator
  2. Program counter Correct answer.
  3. Instruction register
  4. Memory address register

Explanation

The program counter stores the address of the next instruction and is incremented after each fetch. The MAR holds an address currently being accessed, and the instruction register holds the fetched instruction itself.

Question 20Information Technology

Which memory type is volatile and loses its contents when power is removed?

  1. Flash memory
  2. ROM
  3. RAM Correct answer.
  4. Magnetic disk

Explanation

RAM is volatile semiconductor memory used for working storage and loses its contents without power. ROM, flash, and magnetic media retain data when powered off.

Question 21Information Technology

A system uses a relational database with a foreign key constraint between orders and customers. What happens if a user tries to insert an order with a customer ID that does not exist?

  1. A new customer record is created automatically.
  2. The order is stored and the constraint is checked only at the next backup.
  3. The order is stored with a null customer ID automatically.
  4. The insert is rejected because referential integrity is enforced. Correct answer.

Explanation

A foreign key enforces referential integrity, so a value must match an existing primary key in the referenced table. An unmatched value causes the insert to fail unless a rule such as ON DELETE or a default is explicitly defined.

Question 22Information Technology

A company moves a database to a client-server architecture instead of storing the file on a shared drive. Which is the clearest benefit?

  1. Backups become unnecessary because the server is always available.
  2. The database file can be edited by several users at once without any locking.
  3. The application logic must be duplicated on every client.
  4. Concurrent access is controlled centrally and only requested rows cross the network. Correct answer.

Explanation

In a client-server database the server enforces concurrency control and processes queries, returning only the requested rows rather than the whole file. This reduces network traffic and prevents conflicting edits, but backups remain essential.

Question 23Information Technology

A programmer writes a loop that reads records until a sentinel value of -1 is encountered. Which type of loop is most appropriate?

  1. A FOR loop counting from 1 to 100
  2. A pre-condition WHILE loop testing for the sentinel Correct answer.
  3. A nested FOR loop over a two-dimensional array
  4. A REPEAT loop that never tests the sentinel

Explanation

The number of records is unknown in advance, so a pre-condition WHILE loop testing for the sentinel is appropriate and also handles the case of zero records. A FOR loop requires a known iteration count, and a loop that never tests the sentinel cannot terminate correctly.

Question 24Information Technology

A network uses NAT on a home router. Which statement explains why an external host cannot normally initiate a connection to an internal host?

  1. The internal host uses a public address that is blocked by the ISP.
  2. The internal host has no globally routable address, so the router has no mapping for the incoming packet. Correct answer.
  3. The internal host does not have a MAC address.
  4. The router encrypts all inbound traffic so it cannot be read.

Explanation

NAT maps private internal addresses to a single public address using a translation table built from outbound connections. An unsolicited inbound packet has no matching entry, so the router cannot determine which internal host should receive it without a static port-forwarding rule.

Question 25Information Technology

An organisation stores a password by applying a fast cryptographic hash with no salt. Which weakness is most significant?

  1. The password becomes longer than the input limit of the login form.
  2. The hash can be reversed by anyone who knows the algorithm.
  3. The hash cannot be stored in a database column.
  4. Identical passwords produce identical hashes, enabling precomputed rainbow-table attacks. Correct answer.

Explanation

Without a salt, the same password always yields the same digest, so an attacker can use precomputed tables to match hashes in bulk. Salting makes each hash unique, and slow key-derivation functions further raise the cost of guessing.

Question 26Information Technology

Which number base is used internally by the processor when it executes machine instructions?

  1. Decimal
  2. Binary Correct answer.
  3. Octal
  4. Hexadecimal

Explanation

Digital circuits represent values using two voltage states, so the processor operates on binary digits. Hexadecimal and octal are simply compact notations used by humans to write binary values more briefly.

Question 27Information Technology

Which type of software is designed to control a single hardware device and provide an interface between that device and the operating system?

  1. Utility program
  2. Application suite
  3. Device driver Correct answer.
  4. Firmware updater

Explanation

A device driver is the low-level software that translates operating system requests into commands the specific hardware understands. It is installed for a particular device model so the OS does not need to know the device's details.

Question 28Information Technology

A file is stored on a magnetic hard disk. Which statement correctly describes how the data is retained?

  1. Data is held as charge trapped in floating-gate transistors
  2. Data is burned into a fused link array that cannot be rewritten
  3. Data is stored as magnetised regions that persist without power Correct answer.
  4. Data is held as electric charge in capacitors that must be refreshed

Explanation

Magnetic disks store bits as the orientation of magnetised domains on a coated platter, and this orientation remains after power is removed. Capacitor charge and floating-gate charge describe semiconductor memory, not magnetic media.

Question 29Information Technology

In a relational database, which key uniquely identifies each record in a table and must never be null?

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

Explanation

The primary key is the chosen candidate key that enforces uniqueness and the NOT NULL constraint for every row. Other keys may be unique but the primary key is the one designated to identify records.

Question 30Information Technology

Which of the following is an example of a system where a computer's outputs are used to control a physical process in real time?

  1. A word processor producing a printed report
  2. A spreadsheet recalculating a budget forecast
  3. A payroll batch run at the end of each month
  4. A traffic-light controller responding to sensor input Correct answer.

Explanation

A control system receives sensor data and produces output signals that actuate hardware within strict timing constraints, as in a traffic-light controller. The other examples process data for human use rather than regulating a physical process.

Question 31Information Technology

Which statement best describes the purpose of a protocol in a communications system?

  1. It defines agreed rules for how data is formatted and exchanged Correct answer.
  2. It encrypts all traffic between two hosts
  3. It assigns a unique hardware address to each network card
  4. It compresses data so that fewer bits are transmitted

Explanation

A protocol is a set of rules covering message format, sequencing, and expected responses so that different systems can interoperate. Compression, encryption, and addressing are separate functions that particular protocols may use but do not define.

Question 32Information Technology

Which item is an example of system documentation rather than user documentation?

  1. A data dictionary describing each field in the files Correct answer.
  2. A tutorial showing new users how to log in
  3. A quick-start guide shipped with the software
  4. An online help page for a menu option

Explanation

System documentation is produced for developers and maintainers and describes the internal design, including file layouts and field definitions. User documentation is written for the people who operate the software.

Question 33Information Technology

Which statement describes a characteristic of a wide area network (WAN) rather than a local area network (LAN)?

  1. It uses Ethernet switching for all internal traffic
  2. It connects devices within a single building using privately owned cabling
  3. It typically relies on links leased from a telecommunications provider Correct answer.
  4. It is normally administered by a single organisation on one site

Explanation

A WAN spans large geographical distances and generally uses circuits or services supplied by a telecoms carrier. LANs cover a limited area, are usually owned and managed by one organisation, and commonly use Ethernet switching.

Question 34Information Technology

A programmer needs to store a list of student names where the number of names is not known in advance and items will be added and removed frequently. Which structure is most suitable?

  1. A record with a fixed number of fields
  2. A linked list Correct answer.
  3. A two-dimensional array
  4. A fixed-size one-dimensional array

Explanation

A linked list allocates nodes as needed, so it grows and shrinks dynamically without a declared maximum size. Fixed arrays and fixed-field records require the size to be decided before the program runs.

Question 35Information Technology

A validation rule is applied to an input field for a person's age. Which rule best checks that the data is sensible rather than merely present?

  1. A range check that the value lies between 0 and 120 Correct answer.
  2. A presence check that the field is not empty
  3. A check digit appended to the value
  4. A format check that the value contains only digits

Explanation

A range check confirms the value falls within an acceptable span, catching values such as 300 that are present and numeric but not sensible for an age. Presence and format checks do not test whether the magnitude is reasonable.

Question 36Information Technology

A company processes orders with a batch system overnight. Which characteristic is a direct consequence of this approach?

  1. The system must handle many simultaneous interactive users
  2. Users receive immediate confirmation of each transaction
  3. Data is processed one record at a time as it arrives
  4. Results are only available after the batch run completes Correct answer.

Explanation

Batch processing collects transactions and processes them together at a scheduled time, so outputs appear only when the run finishes. Immediate confirmation and interactive concurrency are features of online transaction processing.

Question 37Information Technology

A network administrator assigns addresses from the range 192.168.10.0/24 to internal hosts. Which statement about these addresses is correct?

  1. They are public addresses routable on the internet
  2. They are multicast addresses used for streaming
  3. They are private addresses that require translation to reach the internet Correct answer.
  4. They are loopback addresses used for local testing

Explanation

The 192.168.0.0/16 block is reserved for private use, so these addresses are not routed on the public internet and need NAT to communicate externally. Loopback and multicast ranges are different reserved blocks.

Question 38Information Technology

A program reads a number from the user and must decide whether it is positive, negative, or zero. Which control structure is most appropriate?

  1. A procedure that takes no parameters
  2. A nested selection using IF and ELSE IF Correct answer.
  3. A post-condition loop
  4. A single assignment statement

Explanation

A multi-way selection tests the value against successive conditions and executes the matching branch, which fits three mutually exclusive outcomes. Loops repeat actions and assignments store values; neither chooses among cases.

Question 39Information Technology

A text file contains records separated by commas and newlines. Which concept describes the layout that tells the program how to interpret each field?

  1. The file organisation Correct answer.
  2. The file extension
  3. The file permission
  4. The file header

Explanation

File organisation describes how records and fields are arranged within a file so the program knows where each field starts and ends. The extension and permissions describe the file's type and access rights, not its internal layout.

Question 40Information Technology

A student writes a program that reads a value into a variable declared as an integer, but the user enters the word 'twelve'. Which type of error is most likely to occur?

  1. A rounding error in arithmetic
  2. A logic error in the algorithm
  3. A run-time error caused by invalid input Correct answer.
  4. A syntax error in the source code

Explanation

The source code is syntactically valid, but the input cannot be converted to an integer, so the failure occurs while the program runs. Syntax errors are detected before execution and logic errors produce wrong but valid results.

Question 41Information Technology

A database table of library loans stores the borrower's name in every loan record. Which design problem does this create?

  1. It enforces referential integrity automatically
  2. It introduces data redundancy and the risk of update anomalies Correct answer.
  3. It reduces the storage required for each record
  4. It guarantees that every loan has a unique identifier

Explanation

Repeating the borrower's name in every loan duplicates data, so a change such as a corrected spelling must be made in many places and may be missed. Normalisation moves such attributes to a separate table referenced by a key.

Question 42Information Technology

A company wants to allow staff to work from home and connect securely to the office network over the internet. Which technology is designed for this purpose?

  1. A proxy cache server
  2. A virtual private network Correct answer.
  3. A domain name system server
  4. A dynamic host configuration server

Explanation

A VPN creates an encrypted tunnel over the public internet so a remote device appears to be on the private network. Proxy, DHCP, and DNS servers provide caching, address assignment, and name resolution respectively.

Question 43Information Technology

In a spreadsheet model, cell C10 contains the formula =B10*$D$1 and is copied down to C11. What formula appears in C11?

  1. =B10*$D$2
  2. =B11*$D$2
  3. =B11*$D$1 Correct answer.
  4. =B10*$D$1

Explanation

Relative references adjust by the number of rows moved, so B10 becomes B11, while the absolute reference $D$1 stays fixed. Copying down one row therefore gives =B11*$D$1.

Question 44Information Technology

A user interface displays an error message as soon as a field is left empty, before the form is submitted. Which usability principle does this best illustrate?

  1. Reducing the memory load on the user
  2. Supporting undo of actions
  3. Maintaining internal consistency
  4. Providing immediate feedback Correct answer.

Explanation

Immediate feedback tells the user about a problem at the point where it occurs, so it can be corrected straight away. Consistency, memory load, and undo are separate principles about layout, recall, and reversibility.

Question 45Information Technology

A team maintains a project where several developers edit the same source files. Which tool is specifically designed to track changes and merge contributions?

  1. A debugger
  2. A linker
  3. A version control system Correct answer.
  4. A profiler

Explanation

A version control system records each revision, allows branching, and merges changes from multiple developers. Debuggers, profilers, and linkers support testing, performance analysis, and program construction rather than collaborative change tracking.

Question 46Information Technology

A program stores a queue of print jobs so that the first job submitted is printed first. Which abstract data type is being used?

  1. A queue Correct answer.
  2. A hash table
  3. A stack
  4. A binary tree

Explanation

A queue is a first-in, first-out structure, which matches the order in which print jobs should be served. A stack is last-in, first-out, while trees and hash tables organise data for search rather than arrival order.

Question 47Information Technology

A database designer wants to prevent any order record from referencing a customer identifier that does not exist in the customers table. Which constraint must be applied?

  1. A foreign key constraint on the customer identifier Correct answer.
  2. A default value for the customer identifier
  3. A unique constraint on the order identifier
  4. A check constraint limiting the order total

Explanation

A foreign key constraint requires each value in the referencing column to match an existing key in the parent table, which enforces referential integrity. Unique, check, and default constraints govern other aspects of the data.

Question 48Information Technology

A subroutine is called with a parameter passed by reference. Which statement describes the effect on the calling program?

  1. Changes made to the parameter inside the subroutine affect the original argument Correct answer.
  2. The subroutine cannot modify the parameter value at all
  3. A copy of the argument is used and the original is unchanged
  4. The argument is converted to a different data type before use

Explanation

Passing by reference supplies the address of the argument, so assignments to the parameter alter the caller's variable. Passing by value would instead copy the argument and leave the original untouched.

Question 49Information Technology

A team is choosing between a star and a mesh topology for a small office network. Which statement is the most significant disadvantage of a full mesh compared with a star?

  1. The number of links and interfaces grows rapidly with the number of nodes Correct answer.
  2. All traffic must pass through one central device
  3. It cannot support more than two computers
  4. A single cable failure isolates the entire network

Explanation

A full mesh needs a link between every pair of nodes, so the cabling and port count grows roughly with the square of the node count. A star instead concentrates connections on one central device, which is its own single point of failure.

Question 50Information Technology

A program must store records that are searched by a unique identifier and must support fast lookup without scanning every record. Which technique is most appropriate?

  1. Sorting the file and always reading it from the beginning
  2. Storing the records in an unsorted sequential file
  3. Compressing the file to reduce its size
  4. Hashing the identifier to compute a direct storage location Correct answer.

Explanation

Hashing converts the identifier into an address, so a record can generally be found with one calculation rather than a scan. Sequential search and compression do not provide direct access by key.