Computational Thinking Concepts

What is the primary goal of decomposition in computational thinking?

• To execute instructions in a specific order

• To combine multiple problems into one

• To break down a problem into smaller sub-problems

• To hide unnecessary details

Which of the following best describes abstraction?

• Breaking down a problem into smaller sub-problems

• Executing instructions in a specific order

• Removing unnecessary details to focus on important ones

• Combining multiple problems into one

In a flowchart, what shape is typically used to represent a decision?

• Rectangle

• Triangle

• Circle

• Diamond

What is the main advantage of binary search over linear search?

• It does not require a sorted list

• It is more efficient for large datasets

• It checks every single item

• It works for any list

Which sorting algorithm involves comparing pairs of values and swapping them if they are in the wrong order?

• Merge Sort

• Insertion Sort

• Bubble Sort

• Quick Sort

What is a key characteristic of a 2D array?

• It can store multiple arrays

• It can only store integers

• It is always sorted

• It cannot be indexed

What is the purpose of a local variable in a subprogram?

• It cannot be changed once set

• It is accessible throughout the entire program

• It is used to store global constants

• It is only accessible within the subprogram it is defined in

Which of the following is NOT a feature of an Integrated Development Environment (IDE)?

• Code editor with auto-suggestion

• Manual code translation

• Error diagnostics tools

• Runtime environment

What is the main purpose of using subprograms in programming?

• To avoid using variables

• To increase the size of the program

• To make the code harder to read

• To break down complex problems into smaller parts

What does the SQL command 'SELECT * FROM students WHERE year IN (9, 10)' do?

• Selects all fields from the 'students' table where the year is 9 or 10

• Deletes all records from the 'students' table where the year is 9 or 10

• Inserts new records into the 'students' table with year 9 or 10

• Updates the 'students' table to set the year to 9 or 10