I85PREP
⌘ K
Saarland Vocational Informatics, basic level - independent foundations study materials
Saarland Vocational Informatics, basic level - independent foundations study resources

Saarland Vocational Informatics, basic level - independent foundations practice questions

One question at a time. Build your Saarland Vocational Informatics, basic level - independent foundations understanding.

First 50 of 190 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 1Programming, object modelling and software development

JavaScript code embedded in a webpage typically runs:

  1. In the user's web browser (client-side) Correct answer.
  2. Exclusively on the company's physical mail server
  3. Only on a printed document
  4. Only inside a database management system

Explanation

JavaScript embedded in a webpage typically executes directly in the visitor's web browser, enabling client-side interactivity.

Question 2Programming, object modelling and software development

A JavaScript "Funktion" (function) is used to:

  1. Group a reusable block of code that can be executed when called Correct answer.
  2. Physically connect a printer to a computer
  3. Design a webpage's color scheme directly
  4. Store a company's financial records permanently

Explanation

A function groups a reusable block of JavaScript code that can be executed (called) whenever needed, avoiding repeated code and improving organization.

Question 3Programming, object modelling and software development

In JavaScript, a "Variable" is used to:

  1. Store a value that can be referenced and potentially changed later in the script Correct answer.
  2. Permanently fix a value that can never be read again
  3. Physically label a network cable
  4. Design a company's logo

Explanation

A JavaScript variable stores a value that can be referenced, used in calculations, and potentially updated as the script runs.

Question 4Programming, object modelling and software development

The JavaScript "Konsole" (console) is commonly used by developers to:

  1. View output messages and debug information while testing a script Correct answer.
  2. Physically power on a computer
  3. Print a document on paper
  4. Design a company's business cards

Explanation

The JavaScript console (accessible via browser developer tools) displays output messages, errors, and debug information, helping developers test and troubleshoot scripts.

Question 5Programming, object modelling and software development

Comments in JavaScript code are used to:

  1. Add explanatory notes for developers that are ignored during code execution Correct answer.
  2. Increase a program's execution speed
  3. Encrypt sensitive user data
  4. Automatically fix all coding errors

Explanation

Comments are non-executable notes within source code that explain the code's purpose or logic to human readers, without affecting program execution.

Question 6Programming, object modelling and software development

A JavaScript "Bedingung" (conditional statement), such as an if-statement, allows a script to:

  1. Execute different code depending on whether a specified condition is true or false Correct answer.
  2. Always execute every line of code identically, regardless of any condition
  3. Physically connect to a network router
  4. Permanently delete a webpage

Explanation

A conditional statement (like an if-statement) allows a script to branch its execution path, running different code depending on whether a specified condition evaluates to true or false.

Question 7Programming, object modelling and software development

In JavaScript, the data type "boolean" represents:

  1. A value that is either true or false Correct answer.
  2. A sequence of text characters
  3. A network IP address
  4. A physical hardware component

Explanation

A boolean data type holds one of exactly two possible values: true or false, commonly used in conditional logic.

Question 8Programming, object modelling and software development

In JavaScript, the data type "string" represents:

  1. A sequence of text characters Correct answer.
  2. A value that is only ever true or false
  3. A type of network cable
  4. A file compression format

Explanation

A string data type represents a sequence of text characters, such as a name, sentence, or any other textual data.

Question 9Programming, object modelling and software development

The Document Object Model (DOM), which JavaScript can access and manipulate, represents:

  1. A structured, tree-like representation of an HTML page's elements that a script can read or modify Correct answer.
  2. A physical document stored only on paper
  3. A type of network security certificate
  4. A database backup file format

Explanation

The DOM is a tree-structured representation of an HTML page's elements, which JavaScript can read and modify to dynamically update webpage content.

Question 10Programming, object modelling and software development

An "Eventhandler" in JavaScript, such as responding to a button click, allows a webpage to:

  1. Execute specific code in response to a user's action Correct answer.
  2. Physically manufacture a new button
  3. Permanently disable all user interaction
  4. Automatically compress an image file

Explanation

An event handler defines code that runs in response to a specific user action, such as clicking a button or submitting a form, enabling interactive webpage behavior.

Question 11Programming, object modelling and software development

JavaScript can be embedded into an HTML page:

  1. Directly within a <script> tag, or by linking to an external JavaScript file Correct answer.
  2. Only by physically rewriting the entire operating system
  3. Only through a printed manual, never electronically
  4. Only by using a database query language exclusively

Explanation

JavaScript can be added to an HTML page either inline within a <script> tag or by linking to a separate external .js file, both common and standard approaches.

Question 12Programming, object modelling and software development

A common reason developers place ordinary parser-blocking JavaScript <script> tags without async or defer near the end of the HTML <body> is to:

  1. Allow the HTML content to load first, improving perceived page load performance before the script executes Correct answer.
  2. Prevent the JavaScript from ever executing under any circumstances
  3. Ensure the script always executes before any HTML content exists
  4. Physically reduce the webpage's file size to zero

Explanation

Placing scripts near the end of the <body> allows the browser to render the visible HTML content first, often improving perceived page load speed before JavaScript execution begins.

Question 13Programming, object modelling and software development

A JavaScript "Schleife" (loop), such as a for-loop, is used to:

  1. Repeat a block of code a specified number of times or while a condition remains true Correct answer.
  2. Permanently disable a webpage's styling
  3. Physically connect to a printer
  4. Encrypt an entire website

Explanation

A loop repeats a block of code either a specified number of times or as long as a condition remains true, avoiding the need to manually repeat code.

Question 14Programming, object modelling and software development

In JavaScript, an "Array" (or list/field) is used to:

  1. Store multiple related values together under a single variable name Correct answer.
  2. Store only a single, unchangeable value
  3. Physically connect network devices
  4. Compress a video file

Explanation

An array stores multiple related values (e.g., a list of names) together under a single variable, allowing organized access to each item.

Question 15Programming, object modelling and software development

The primary purpose of adding JavaScript to a webpage, beyond HTML and CSS, is to:

  1. Add interactivity and dynamic behavior that responds to user actions Correct answer.
  2. Define the page's basic textual content structure
  3. Define the page's visual color scheme and layout exclusively
  4. Store the website's files on a physical server rack

Explanation

JavaScript adds interactivity and dynamic behavior to a webpage, complementing HTML's content structure and CSS's visual styling.

Question 16Algorithms, recursion and complexity

In computer science, abstraction is best described as which of the following?

  1. Hiding unnecessary details so a problem or system can be understood and managed at a higher level Correct answer.
  2. Writing out every single low-level instruction a processor executes
  3. Translating source code into machine language
  4. Measuring the time complexity of an algorithm

Explanation

Abstraction means focusing on the essential features of a problem while ignoring or hiding unnecessary details, which lets people reason about complex systems at a manageable level. The GACE objective treats abstraction as a foundational concept of computer science.

Question 17Algorithms, recursion and complexity

What is the decimal (base-10) value of the binary number 1011?

  1. 11 Correct answer.
  2. 13
  3. 9
  4. 23

Explanation

Each binary digit represents a power of two from right to left: 1x8 + 0x4 + 1x2 + 1x1 = 8 + 0 + 2 + 1 = 11. Converting between number bases is an explicit GACE Algorithms and Computational Thinking objective.

Question 18Algorithms, recursion and complexity

What is the hexadecimal representation of the decimal number 255?

  1. FF Correct answer.
  2. 100
  3. 0F
  4. F0

Explanation

Hexadecimal is base 16, where F equals 15. The value 255 equals 15x16 + 15 = FF, the largest two-digit hexadecimal number. Analyzing and converting representations of numbers in different bases is a GACE objective.

Question 19Algorithms, recursion and complexity

A student breaks the task of building a school website into smaller subtasks: design the layout, write the content, code the navigation, and test the pages. This approach best demonstrates which computational thinking practice?

  1. Problem decomposition Correct answer.
  2. Number base conversion
  3. Data encryption
  4. Operator precedence

Explanation

Problem decomposition is the practice of breaking a large, complex problem into smaller, more manageable subproblems that can be solved individually. Dividing the website project into layout, content, navigation, and testing tasks is a clear example.

Question 20Algorithms, recursion and complexity

An algorithm performs a single pass through a list of n items, doing constant work for each item. Which describes its time complexity?

  1. Linear, O(n) Correct answer.
  2. Quadratic, O(n^2)
  3. Logarithmic, O(log n)
  4. Constant, O(1)

Explanation

When the number of operations grows in direct proportion to the input size n, the running time is linear, written O(n). A single pass doing constant work per element is the canonical example of linear time.

Question 21Algorithms, recursion and complexity

A binary search is performed on a sorted list of 16 elements. What is the maximum number of comparisons needed to determine whether a target value is present?

  1. 5 Correct answer.
  2. 16
  3. 8
  4. 4

Explanation

Binary search halves the search space with each comparison, so the maximum number of comparisons is floor(log2 n) + 1. For 16 elements, log2(16) = 4, giving a maximum of 5 comparisons. Calculating comparisons for binary search is a stated GACE objective.

Question 22Algorithms, recursion and complexity

Which essential component must every recursive algorithm include to avoid running forever?

  1. A base case (stopping condition) Correct answer.
  2. A nested loop
  3. A global variable
  4. A sorting step

Explanation

A recursive algorithm calls itself on smaller inputs and must include a base case, a condition under which it stops recursing and returns a direct result. Without a base case, the recursion never terminates. Identifying the base case is an explicit GACE objective.

Question 23Algorithms, recursion and complexity

Which problem is best characterized as one that cannot be solved exactly within a practical time, making a heuristic solution appropriate?

  1. Finding the absolute shortest route that visits hundreds of cities exactly once (the traveling salesman problem) Correct answer.
  2. Adding two integers together
  3. Finding the largest value in a list of ten numbers
  4. Reversing a short string of characters

Explanation

The traveling salesman problem grows so quickly with the number of cities that finding the guaranteed optimal route becomes computationally impractical for large inputs, so heuristics that find good-enough solutions are used. Recognizing when heuristic solutions are useful is a GACE objective.

Question 24Algorithms, recursion and complexity

A teacher explains the difference between random and pseudorandom numbers. Which statement is correct?

  1. Pseudorandom numbers are generated by a deterministic algorithm from a seed and will repeat if the same seed is used Correct answer.
  2. Pseudorandom numbers can never be reproduced under any circumstances
  3. Truly random numbers are always produced by software loops
  4. Pseudorandom and truly random numbers are identical in every way

Explanation

Pseudorandom number generators use a deterministic algorithm starting from a seed value, so the same seed always produces the same sequence, which makes them reproducible. This distinguishes them from truly random sources, which derive from physical, unpredictable phenomena.

Question 25Algorithms, recursion and complexity

Consider the recursive definition: factorial(0) = 1, and factorial(n) = n * factorial(n - 1) for n > 0. What value does factorial(4) produce?

  1. 24 Correct answer.
  2. 12
  3. 16
  4. 10

Explanation

Tracing the recursion: factorial(4) = 4 * 3 * 2 * 1 * factorial(0) = 4 * 3 * 2 * 1 * 1 = 24. Tracing simple recursive algorithms such as n factorial is an explicit GACE objective.

Question 26Algorithms, recursion and complexity

A flowchart uses a diamond shape at a decision point. What does the diamond most commonly represent in standard flowchart notation?

  1. A condition or decision that branches the flow based on yes/no or true/false Correct answer.
  2. The start or end of the algorithm
  3. A simple process or calculation step
  4. Input or output of data

Explanation

In standard flowchart notation, the diamond represents a decision: a condition is evaluated and the flow branches based on the result, typically yes/no or true/false. Interpreting flowchart symbols and tracing algorithms in different formats is a GACE objective.

Question 27Algorithms, recursion and complexity

A student is given a table showing input values 1, 2, 3, 4 paired with outputs 1, 4, 9, 16. Which rule best describes the pattern that produces the outputs?

  1. Each output is the input squared Correct answer.
  2. Each output is the input plus three
  3. Each output is the input multiplied by four
  4. Each output is double the input

Explanation

Checking the pairs: 1^2 = 1, 2^2 = 4, 3^2 = 9, 4^2 = 16. The output equals the square of the input. Identifying patterns in a table of values and the algorithm that produces them is a GACE pattern-recognition objective.

Question 28Algorithms, recursion and complexity

An algorithm using nested loops compares every element of a list to every other element. As the list size n grows large, which growth rate best describes the number of comparisons?

  1. Quadratic, proportional to n^2 Correct answer.
  2. Linear, proportional to n
  3. Logarithmic, proportional to log n
  4. Constant, independent of n

Explanation

When an inner loop runs n times for each of the n iterations of an outer loop, the total number of comparisons is proportional to n times n, which is n^2, or quadratic growth. The GACE objective asks teachers to identify and compare linear, quadratic, exponential, and logarithmic algorithms.

Question 29Algorithms, recursion and complexity

Which list of items represents an abstraction hierarchy correctly ordered from the lowest (most detailed) level to the highest (most abstract) level?

  1. Transistors, logic gates, integrated circuits, computer Correct answer.
  2. Computer, integrated circuits, logic gates, transistors
  3. Logic gates, transistors, computer, integrated circuits
  4. Integrated circuits, computer, transistors, logic gates

Explanation

Abstraction hierarchies build from the most detailed physical components upward. Transistors combine into logic gates, gates form integrated circuits, and circuits make up the complete computer, moving from low (detailed) to high (abstract). Ordering an abstraction hierarchy is a GACE objective.

Question 30Entity modelling, relational algebra and SQL

A "Datenbank" (database) is best described as:

  1. An organized collection of structured data that can be accessed, managed, and updated Correct answer.
  2. A single, unstructured text document
  3. A physical filing cabinet with no digital component
  4. A type of computer monitor

Explanation

A database is an organized, structured collection of data designed to be efficiently accessed, managed, and updated by software.

Question 31Entity modelling, relational algebra and SQL

In a database table, each column typically represents:

  1. A specific attribute or field of the data (e.g., "Name" or "Email") Correct answer.
  2. A single, complete record
  3. A network protocol
  4. A file compression algorithm

Explanation

Each column in a database table represents a specific attribute or field describing one aspect of the stored data, such as a customer's name or email address.

Question 32Entity modelling, relational algebra and SQL

In a database table, each row typically represents:

  1. A single, complete record of related data Correct answer.
  2. A single attribute or field type
  3. A network cable connection
  4. A CSS style rule

Explanation

Each row in a database table represents one complete record, containing values for all the columns/attributes defined for that table.

Question 33Entity modelling, relational algebra and SQL

A "Primärschlüssel" (primary key) ensures that:

  1. Each record (row) in a table can be uniquely identified Correct answer.
  2. All records in a table share an identical value for every field
  3. A table can never contain more than one record
  4. A database cannot store any text data

Explanation

A primary key is a column (or set of columns) whose values are unique for every row, ensuring that each record can be reliably and uniquely identified.

Question 34Entity modelling, relational algebra and SQL

SQL, which stands for Structured Query Language, is primarily used to:

  1. Create, manage, and query data within a relational database Correct answer.
  2. Design a webpage's visual layout
  3. Compress image files for the web
  4. Establish a physical network connection

Explanation

SQL is the standard language used to create, manage, query, and update data within a relational database.

Question 35Entity modelling, relational algebra and SQL

Which SQL command retrieves data from a database table?

  1. SELECT Correct answer.
  2. DELETE
  3. DROP
  4. UPDATE

Explanation

SELECT is the SQL command specifically used to query and retrieve data from one or more database tables.

Question 36Entity modelling, relational algebra and SQL

Which SQL command modifies existing data already stored in a database table?

  1. UPDATE Correct answer.
  2. SELECT
  3. CREATE
  4. DROP

Explanation

UPDATE is the SQL command used to change the values of existing records already stored in a database table.

Question 37Entity modelling, relational algebra and SQL

Which SQL command permanently removes an entire table structure from a database?

  1. DROP Correct answer.
  2. SELECT
  3. INSERT
  4. WHERE

Explanation

DROP is the SQL command used to permanently delete an entire table (structure and data) from a database.

Question 38Entity modelling, relational algebra and SQL

In SQL, the "WHERE" clause is used to:

  1. Filter query results to include only rows matching a specified condition Correct answer.
  2. Physically wire a network cable
  3. Design a webpage's font style
  4. Compress a database file

Explanation

The WHERE clause filters query results, returning only the rows that meet a specified condition.

Question 39Entity modelling, relational algebra and SQL

In SQL, "ORDER BY" is used to:

  1. Sort the results of a query in a specified order (e.g., ascending or descending) Correct answer.
  2. Delete records from a table
  3. Establish a network connection
  4. Compress an image

Explanation

ORDER BY sorts the results of a SQL query according to specified columns, in either ascending or descending order.

Question 40Entity modelling, relational algebra and SQL

An SQL "JOIN" combines data from:

  1. Two or more related tables based on a shared column, such as a foreign key Correct answer.
  2. A single table only, with no relation to any other table
  3. A network router and a printer
  4. Two separate, unrelated CSS files

Explanation

A JOIN combines data from two or more related tables based on a common column, typically a primary key/foreign key relationship.

Question 41Entity modelling, relational algebra and SQL

"Datenredundanz" (data redundancy) in a poorly designed database refers to:

  1. The same piece of data being unnecessarily duplicated across multiple records or tables, increasing the risk of inconsistency Correct answer.
  2. A database that stores no data at all
  3. A network with too many redundant cables
  4. A CSS style applied redundantly to a single element

Explanation

Data redundancy occurs when the same piece of information is unnecessarily duplicated across a database, increasing storage waste and the risk of inconsistent updates.

Question 42Entity modelling, relational algebra and SQL

A well-designed relational database aims to minimize data redundancy primarily by:

  1. Structuring related data into separate, linked tables rather than duplicating it repeatedly Correct answer.
  2. Storing all data in a single, unstructured text file
  3. Removing all primary and foreign keys from every table
  4. Avoiding the use of any tables whatsoever

Explanation

Splitting related data into separate, appropriately linked tables (using keys) minimizes redundant duplication, a core goal of relational database design.

Question 43Entity modelling, relational algebra and SQL

When a PHP script needs to display data from a database on a webpage, it typically:

  1. Connects to the database, executes an SQL query, and formats the returned results as HTML output Correct answer.
  2. Directly modifies the physical hard drive sectors with no database software involved
  3. Compiles the database into a video file
  4. Establishes a printer connection instead of a database connection

Explanation

A PHP script typically connects to the database, runs an SQL query to retrieve data, and then formats that data as HTML to display on the webpage.

Question 44Entity modelling, relational algebra and SQL

In a database used to manage a company's inventory, a "Fremdschlüssel" (foreign key) might link:

  1. An order record to the specific customer who placed it Correct answer.
  2. A CSS file to an HTML page
  3. A network cable to a router
  4. An image file to a video file

Explanation

A foreign key connects related records across tables - for example, linking an order record to the customer table entry for the customer who placed that order.

Question 45Entity modelling, relational algebra and SQL

When designing a database for an online bookstore, storing a customer's order history as a separate, linked table (rather than repeating customer details in every order record) primarily achieves:

  1. Reduced data redundancy and easier maintenance of customer information Correct answer.
  2. Slower query performance in every possible case
  3. Complete elimination of the need for any primary keys
  4. Automatic encryption of all stored data

Explanation

Separating orders and customer data into linked tables avoids repeatedly duplicating customer details in every order, reducing redundancy and simplifying updates.

Question 46Entity modelling, relational algebra and SQL

Which SQL command adds a completely new table structure to a database?

  1. CREATE Correct answer.
  2. SELECT
  3. DELETE
  4. UPDATE

Explanation

CREATE (specifically CREATE TABLE) is the SQL command used to define and add a new table structure to a database.

Question 47Entity modelling, relational algebra and SQL

An "Index" in a database table is used primarily to:

  1. Speed up the retrieval of records by allowing faster searching on specified columns Correct answer.
  2. Automatically delete duplicate records
  3. Design the visual appearance of a webpage
  4. Compress an image file

Explanation

A database index improves the speed of data retrieval by creating an efficient lookup structure for specified columns, similar to an index in a book.

Question 48Entity modelling, relational algebra and SQL

A key advantage of storing data in a structured database rather than a plain text file is:

  1. Data can be efficiently searched, filtered, sorted, and related to other data Correct answer.
  2. Structured databases can never be updated once created
  3. Structured databases require no software to manage them at all
  4. Plain text files always provide better data organization

Explanation

Structured databases enable efficient searching, filtering, sorting, and relating of data - capabilities that are far more limited or manual with plain text files.

Question 49Computer systems, networks and distributed communication

What is the primary role of a computer's operating system?

  1. To manage and coordinate hardware and software resources and interactions Correct answer.
  2. To compile every program into binary before it can run
  3. To provide internet access only
  4. To store the user's personal documents permanently

Explanation

An operating system is the program that controls and coordinates interactions between hardware and software components, managing resources such as the processor, memory, storage, and devices. Knowing that operating systems control hardware-software interactions is a GACE Computing Systems objective.

Question 50Computer systems, networks and distributed communication

A smart thermostat that contains a small processor dedicated to controlling heating and cooling is an example of which kind of system?

  1. An embedded system Correct answer.
  2. A mainframe cluster
  3. A general-purpose desktop computer
  4. A cloud data center

Explanation

An embedded system is a computer built into a larger device to perform a dedicated function, such as a thermostat's processor controlling temperature. The GACE objective asks teachers to describe embedded systems and the Internet of Things.