What is the correct way to print `"Hello, World!"` in Python?

Which of the following are valid string operations in Python?

Which of the following are built-in data types in Python?

Which of the following is a valid variable name?

Which of the following statements about Python lists are correct?

Which of the following are valid Python loop constructs?

How do you get the length of a list `my_list`?

Which of the following methods are used with dictionaries?

Which of the following will correctly convert a string to an integer?

What keyword is used to define a function in Python?

Which of the following are valid ways to create a set in Python?

Match pairs for string operation function and its meaning

Which statement is used to exit a loop prematurely?

Match the descriptions with their correct expressions

Which keyword is used for exception handling in Python?

Match pairs for list operation and its meaning

Match the descriptions with their correct functions

Which of the following is used to include a module in Python?

Match pairs for loop or conditional part and its meaning

Core fundamentals of the Python programming language, encompassing basic syntax, standard data structures, variable assignment, and foundational control flow mechanisms.

Which of the following are valid SQL data types?

Which of the following SQL constraints ensure uniqueness?

Which SQL statement is used to retrieve data from a database?

Which of the following clauses can be used to filter query results?

Which SQL statements modify existing data in a table?

Which clause is used to filter records in SQL?

Which of the following are valid SQL aggregate functions?

Which SQL functions handle `NULL` values?

Which SQL clause is used to sort query results?

What actions can be performed using the `ALTER TABLE` command?

Match the SQL functions with their result

What keyword is used to remove duplicates from a result set?

Match the outputs with their aggregate functions

Match the types of joins with their description

How do you delete all rows from a table without removing its structure?

Match the categories with their correct SQL data types

Match the SQL operators with their function

What is the purpose of the `JOIN` operation in SQL?

Match the SQL execution order with its step

What is the default sorting order of `ORDER BY`?

Match the definitions with their SQL constraints

Foundational principles of Structured Query Language (SQL), covering basic data retrieval, record filtering mechanisms, syntax fundamentals, and elementary query construction.

What does the `enumerate()` function return?

Which of the following statements about Python's `is` operator are true?

Which of the following can be used as dictionary keys?

What is the purpose of the `__slots__` attribute in a Python class?

Which of the following statements about Python's `with` statement are true?

Which of the following are valid Python decorators?

Which of the following methods can be used to remove an element from a list?

Which of the following will cause a `ZeroDivisionError`?

What does the `@staticmethod` decorator do?

Which of the following operations modify a list in-place?

Match special Python variables with their meaning

Match descriptions with their Python file modes

What is the difference between `deepcopy()` and `copy()` in Python?

Match Python exception types with their causes

Match descriptions with Python dictionary methods

What does the `@classmethod` decorator do?

Match Python loop control statements with their behavior

Match descriptions with Python set operations

What happens if you try to modify a tuple?

Intermediate Python programming concepts, focusing on modular code development, custom functions, object-oriented programming principles, exception handling, and advanced data manipulation techniques.

What is the main advantage of using an index in SQL?

Which of the following statements about indexes are true?

Which type of `JOIN` returns only matching rows from both tables?

Which of these SQL functions can be used for string manipulation?

Which SQL function extracts a portion of a date?

Which statements are true about transactions in SQL?

Which of the following are aggregate functions?

Which of the following can be used to enforce data integrity in SQL?

Which of the following statements about SQL joins are true?

What is the purpose of a `COMMIT` statement in SQL?

Which SQL keywords are used for subqueries?

How do you find the highest salary from an "employees" table?

Match each SQL concept with its correct description

What does the following SQL query return?

Match each description with its correct SQL concept

Which SQL command is used to create a view?

What does the following SQL statement do?

Which SQL function returns the first non-NULL value from a list of arguments?

What is the default isolation level in most SQL databases?

What happens if you try to insert a `NULL` value into a column with a `NOT NULL` constraint?

How can you get the last inserted `ID` in a table?

Relational database operations and data analysis techniques, focusing on multi-table joins, data aggregation, structural manipulation, and complex subqueries.

What is the purpose of the `MERGE` statement in SQL?

Which of the following are characteristics of a clustered index?

Which isolation level prevents dirty reads, non-repeatable reads, but allows phantom reads?

Which of the following SQL statements can improve query performance?

What does the `WITH CHECK OPTION` in a SQL view do?

In a distributed database system, which techniques help ensure high availability?

What are the advantages of using `PARTITION BY` in window functions?

What are some key advantages of indexing in SQL?

What are the characteristics of database transactions?

What happens when you execute `DELETE FROM table_name` without a `WHERE` clause?

Which constraints help maintain data integrity in SQL databases?

Which of the following best describes an SQL window function?

How does `CLUSTERED INDEX` differ from a `NON-CLUSTERED INDEX`?

Match properties with SQL isolation levels

What does `SHARDING` in databases refer to?

Match definitions (ACID principles) with SQL transaction properties

What is a phantom read in SQL transactions?

Match SQL operations with their correct use cases

Match common SQL errors with their causes

Complex database querying and architectural optimization, encompassing analytical window functions, procedural database logic, execution plan analysis, and advanced relational concepts.

Select the correct way to declare an integer variable in Java. The question will provide several code snippets, and you must choose the one that correctly declares an integer variable.

Identify which data type is used to store decimal numbers in Java. The question will present multiple options such as int, double, char, etc.

Determine the value of a variable that is declared but not initialized inside a method in Java. The question will test your understanding of variable initialization and default values.

Explain what the System.out.println() statement does in Java. The question will provide several descriptions, and you must select the most accurate one.

Describe the difference between print() and println() in Java. The question will present several statements, and you must choose the correct explanation.

Calculate the result of the expression 5 + 2 * 3 in Java. The question will test your understanding of operator precedence.

Explain the function of the % (modulus) operator in Java. The question will provide several options describing its purpose.

Fill in the blanks: Provide the correct syntax for an if statement in Java. The question will present a code snippet with missing keywords or symbols, and you must fill in the blanks.

Analyze the following code and select what it will output:

int x = 10;
if (x > 5) {
    System.out.println("Yes");
} else {
    System.out.println("No");
}

Choose the correct output from the options.

Identify which type of loop is best suited when the number of iterations is known in advance. The question will present options such as for, while, and do-while.

Analyze the following code and select what it will print:

for (int i = 0; i < 3; i++) {
    System.out.print(i);
}

Choose the correct output from the options.

Define what a method is in Java. The question will provide several definitions, and you must select the most accurate one.

Explain the purpose of the return keyword in Java. The question will present several statements, and you must choose the correct explanation.

Fill in the blanks: Provide the correct syntax to declare an array of integers in Java. The question will present a code snippet with missing parts, and you must fill in the blanks.

Analyze a provided code snippet and select what it will output. The question will present a short Java code and multiple output options.

Explain what the SUM function does in Excel, including its primary purpose and typical usage scenarios.

Describe the difference between the SUM and SUMIF functions in Excel, highlighting when each should be used.

Given the formula =SUM(1, 2, 3), explain what value it returns and why.

Describe the purpose of the $ symbol in Excel formulas, including how it affects cell references.

Explain what the formula =AVERAGE(A1:A5) does, including what result it produces and how it is calculated.

Compare VLOOKUP and XLOOKUP functions in Excel, outlining their differences and advantages.

Given the formula =IF(5 > 3, "Yes", "No"), explain what value it returns and the logic behind it.

Describe the purpose of the COUNT function in Excel and provide an example of its use.

Explain the differences between COUNT, COUNTA, and COUNTIF functions in Excel, including what each counts.

Describe what the formula =CONCAT(A1, B1) does and provide an example of its output.

Explain the purpose of the LEFT and RIGHT functions in Excel, including how they are used to manipulate text.

Given the formula =LEN("Excel"), explain what value it returns and why.

Describe the purpose of the IFERROR function in Excel and provide a scenario where it is useful.

Explain what the formula =MAX(A1:A10) does, including how it determines its result.

Describe the difference between relative and absolute cell references in Excel, including examples of each.

What is the main advantage of using `asyncio` in Python?

What happens if an object has cyclic references in Python?

Which statements are true about `__slots__`?

How does Python's garbage collector determine when to free an object?

Which statements are true about Python's memory model?

How can you prevent accidental overriding of methods in subclasses?

What is the main purpose of `__slots__` in Python classes?

What are valid ways to share data between threads safely?

Which are valid use cases of metaclasses?

What is stored in Python's Thread-Local Storage (threading.local())?

What are valid ways to create custom exceptions in Python?

Match the concept with its correct description

What is the purpose of type annotations in Python?

How does Python prevent memory leaks with circular references?

Match the built-in module with its purpose

Match the descriptions with their correct Python memory management concepts

What is the function of the `@property` decorator in Python?

Match the Python feature with its correct explanation

Match the descriptions with their type annotations

How do metaclasses modify class behavior?

Complex Python architectures and advanced programming paradigms, including concurrency, high-level language features, memory management, and performance optimization methodologies.

Identify the function of the shortcut Ctrl + C in Excel. The question will present multiple options describing possible actions performed by this shortcut.

Select the correct shortcut used to paste copied data in Excel. The question will provide several shortcut options to choose from.

Explain what happens when you press Ctrl + Z in Excel. The question will offer multiple choices describing the effect of this shortcut.

Describe the function of Ctrl + Y in Excel. The question will present several possible actions for selection.

Choose the shortcut that selects the entire column of the active cell in Excel. Multiple shortcut options will be provided.

Identify the shortcut that selects the entire row of the active cell in Excel. The question will list several shortcut options.

Explain the effect of pressing Ctrl + Arrow Key in Excel. The question will provide multiple descriptions of what this shortcut does.

Select the shortcut used to quickly edit the active cell in Excel. Several shortcut options will be presented.

Describe the function of Ctrl + Shift + L in Excel. The question will offer multiple choices explaining what this shortcut accomplishes.

Choose the shortcut that inserts the current date into a cell in Excel. Multiple shortcut options will be provided.

Identify the shortcut that inserts the current time into a cell in Excel. The question will present several shortcut options.

Explain what happens when you press Alt + = in Excel. The question will provide multiple options describing the result of this shortcut.

Given the code snippet 'console.log(typeof null);', select the correct output from the options provided.

Given the code snippet 'let x; console.log(x);', choose the correct output that will be logged to the console.

Identify the JavaScript keyword used to declare a variable with block scope from the provided options.

Given the code snippet 'console.log(2 + "2");', select the correct output from the options.

Given the code snippet 'console.log(2 === "2");', choose the correct output that will be logged to the console.

Explain the difference between the '==' and '===' operators in JavaScript. Select the most accurate explanation from the options.

Given the code snippet:
let a = 5;
let b = a;
b = 10;
console.log(a);
Choose the correct output that will be logged to the console.

Given the code snippet:
const arr = [1, 2];
arr.push(3);
console.log(arr);
Select the correct output from the options.

Given the code snippet:
const x = 10;
x = 20;
What will happen when this code is executed? Choose the correct outcome from the options.

Given the code snippet 'console.log(Boolean(0));', select the correct output from the options.

Given the code snippet 'console.log("5" - 2);', choose the correct output that will be logged to the console.

Given the code snippet 'console.log(typeof []);', select the correct output from the options.

Explain the purpose of the <html> tag in an HTML document. The question will present multiple choices describing the function of the <html> tag.

Identify which HTML tag is used to define the main content of a webpage. The question will provide several tag options to choose from.

Describe what the <p> tag represents in HTML. The question will offer multiple choices about the semantic meaning of the <p> tag.

Select the correct attribute used to specify a link’s destination in an <a> tag. The question will list several attribute options.

Explain the purpose of the alt attribute in an <img> tag. The question will provide multiple choices regarding the function of the alt attribute.

Compare the <div> and <span> tags in HTML. The question will ask for the main difference between these two tags, with several options provided.

Given the following code snippet:
<p>Hello</p>
<p>World</p>
Choose what will be displayed on the webpage. The question will present several possible outputs.

Identify which CSS property is used to change the color of text. The question will provide a list of CSS properties to choose from.

Explain how to apply a CSS class to an HTML element. The question will present several code snippets and ask which one correctly applies a class.

Describe the difference between a class and an id in CSS. The question will offer multiple choices explaining their usage and uniqueness.

Given the following CSS code:
p {
  color: red;
}
Explain what effect this CSS will have on a webpage. The question will provide several possible outcomes.

Explain the purpose of the margin property in CSS. The question will present multiple choices about what margin controls.

Describe the difference between margin and padding in CSS. The question will offer several explanations to choose from.

Given the following HTML code:
<div style="background-color: blue;">
  Text
</div>
Choose what effect this code will have on the displayed content. The question will present several possible visual outcomes.

Identify which CSS property is used to control the space inside an element. The question will provide a list of CSS properties to choose from.

Question about declaring an integer variable in C++. Includes a code snippet with four options for correct syntax.

Fill in the blanks: Complete the code to declare a float variable named 'temperature' and assign it the value 36.6.

Question on identifying the correct data type for storing a decimal number in C++.

Match pairs: Match the C++ data type to the kind of value it stores (e.g., int, double, char, bool).

Question about the output of a simple cout statement. Includes a code snippet and asks what will be printed.

Question on using cin to read user input into a variable. Includes a code snippet with a missing line to be identified.

Question about the result of a basic arithmetic operation (addition, subtraction, multiplication, or division) in C++. Includes a code snippet.

Testaa koodausosaamistasi

Tee nopea testi nähdäksesi, missä olet, tunnista aukot ja paranna

kohdennetulla harjoittelulla. Seuraa edistymistäsi ja kehitä taitojasi.

Taso

Technology

Järjestä