Question 1

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

Accepted Answer

SELECT

Answer

DELETE

Answer

UPDATE

Answer

INSERT

Question 2

What SQL clause is used to filter records returned by a query?

Accepted Answer

WHERE

Answer

HAVING

Answer

ORDER BY

Answer

GROUP BY

Question 3

In SQL, which keyword is used to sort the result set of a query alphabetically or numerically?

Accepted Answer

ORDER BY

Answer

LIMIT

Answer

WHERE

Answer

GROUP BY

Question 4

What SQL keyword is used to eliminate duplicate records from the results?

Accepted Answer

DISTINCT

Answer

REMOVE

Answer

UNIQUE

Answer

FILTER

Question 5

Which SQL function is used to calculate the total number of rows in a query result?

Accepted Answer

COUNT

Answer

TOTAL

Answer

SUM

Answer

AGGREGATE

Question 6

Which of the following is a common syntax error in Python programs?

Accepted Answer

Missing punctuation, such as colons or commas

Answer

Infinite loops due to improper loop conditions

Answer

Using reserved keywords as variable names

Answer

Accessing elements out of the index range of a list

Question 7

What is a common logic error that can occur in loop structures?

Accepted Answer

Incorrect loop condition leading to off-by-one errors

Answer

Missing semicolons at the end of statements

Answer

Using tabs instead of spaces for indentation

Answer

Forgetting to declare variables

Question 8

Which of the following could lead to a runtime error in a Python program?

Accepted Answer

Dividing a number by zero

Answer

Misnaming a variable

Answer

Forgetting to import a module

Answer

Using single quotes instead of double quotes for strings

Question 9

What is a common semantic error in programming?

Accepted Answer

Using the wrong variable for a calculation

Answer

Misspelling a keyword

Answer

Forgetting to close a string with quotes

Answer

Using a loop without an exit condition

Question 10

Which of the following is an example of a type error in a Python program?

Accepted Answer

Attempting to add a string and an integer without conversion

Answer

Forgetting to initialize a variable

Answer

Using the wrong indentation level

Answer

Including unnecessary parentheses around conditions

Question 11

Which mistake can lead to a NameError in a Python program?

Accepted Answer

Trying to access a variable that hasn’t been defined

Answer

Running a function without parentheses

Answer

Incorrectly ordered logical operators

Answer

Using a for loop for counting iterations

Question 12

What kind of error might occur if you try to open a file that doesn’t exist in Python?

Accepted Answer

FileNotFoundError

Answer

ValueError

Answer

TypeError

Answer

SyntaxError

Question 13

What might result in an IndexError in a Python list?

Accepted Answer

Accessing an element at a position greater than the list length minus one

Answer

Modifying elements while iterating

Answer

Using a list of mixed data types

Answer

Using a non-integer index

Question 14

What type of error is likely if you attempt to convert a non-numeric string to an integer in Python?

Accepted Answer

ValueError

Answer

SyntaxError

Answer

TypeError

Answer

IndentationError

Question 15

Which error might occur if you try to access a dictionary key that does not exist?

Accepted Answer

KeyError

Answer

TypeError

Answer

AttributeError

Answer

IndexError

Question 16

Which of the following is NOT a typical component used in flowcharts to represent an algorithm?

Accepted Answer

Folder

Answer

Process

Answer

Decision

Answer

Start/End

Question 17

In pseudocode, what keyword is typically used to begin a loop that executes a set number of times?

Accepted Answer

FOR

Answer

IF

Answer

WHILE

Answer

REPEAT

Question 18

What does a diamond shape represent in a flowchart?

Accepted Answer

Decision

Answer

Process

Answer

Start/End

Answer

Input/Output

Question 19

What is the primary purpose of pseudocode in algorithm design?

Accepted Answer

To describe the steps of an algorithm in a human-readable format

Answer

To generate machine code

Answer

To only document inputs and outputs of a function

Answer

To execute the algorithm directly on a computer

Question 20

Which of the following statements is true about high-level programming languages?

Accepted Answer

They are closer to human languages than machine code.

Answer

They are written in binary code directly executable by the computer.

Answer

They require no further translation to be run by a computer.

Answer

They cannot be used to implement algorithms.

Question 21

In a flowchart, which symbol is typically used to indicate a process?

Accepted Answer

Rectangle

Answer

Oval

Answer

Diamond

Answer

Parallelogram

Question 22

Which control structure is used in pseudocode to repeatedly execute a block of code as long as a condition is true?

Accepted Answer

WHILE

Answer

CASE

Answer

IF

Answer

FOR

Question 23

In a flowchart, which shape is conventionally used to indicate the start or end of a process?

Accepted Answer

Oval

Answer

Rectangle

Answer

Parallelogram

Answer

Diamond

Question 24

Which keyword in pseudocode is typically used to execute different blocks of code based on different conditions?

Accepted Answer

IF

Answer

FOR

Answer

WHILE

Answer

RETURN

Question 25

Which sorting algorithm works by repeatedly stepping through the list to be sorted, comparing each pair of adjacent items and swapping them if they are in the wrong order?

Accepted Answer

Bubble sort

Answer

Quick sort

Answer

Insertion sort

Answer

Merge sort

Question 26

Which sorting algorithm divides the array into halves, sorts them, and then merges them back together?

Accepted Answer

Merge sort

Answer

Bubble sort

Answer

Insertion sort

Answer

Selection sort

Question 27

Which of the following statements about binary search is true?

Accepted Answer

Binary search requires the array to be sorted beforehand.

Answer

Binary search can be used on unsorted arrays.

Answer

Binary search always starts at the first element of the array.

Answer

Binary search is slower than linear search on average.

Question 28

What is the main difference between linear search and binary search?

Accepted Answer

Linear search checks each element one by one, while binary search divides the array to find the target.

Answer

Linear search is always faster than binary search.

Answer

Binary search checks each element one by one, while linear search divides the array.

Answer

Linear search only works on sorted arrays, while binary search works on any array.

Question 29

In which situation is a linear search more suitable than a binary search?

Accepted Answer

When the list is unsorted.

Answer

When constant time complexity is required.

Answer

When the list is sorted and very large.

Answer

When the search needs to be completed in logarithmic time.

Question 30

Which principle of computational thinking involves breaking down a complex problem into smaller, more manageable parts?

Accepted Answer

Decomposition

Answer

Abstraction

Answer

Algorithmic thinking

Answer

Iteration

Question 31

What principle of computational thinking focuses on identifying the important parts of a problem while ignoring irrelevant details?

Accepted Answer

Abstraction

Answer

Pattern recognition

Answer

Decomposition

Answer

Algorithmic thinking

Question 32

Which principle of computational thinking helps in creating a step-by-step solution to solve a problem?

Accepted Answer

Algorithmic thinking

Answer

Automation

Answer

Abstraction

Answer

Decomposition

Question 33

Which principle of computational thinking is primarily used to reduce complexity by grouping common characteristics?

Accepted Answer

Abstraction

Answer

Algorithmic thinking

Answer

Backtracking

Answer

Decomposition

Question 34

In computational thinking, which principle is used to divide a problem into smaller, more manageable tasks?

Accepted Answer

Decomposition

Answer

Algorithmic thinking

Answer

Abstraction

Answer

Pattern recognition

Question 35

What is the process of converting a value from one data type to another called?

Accepted Answer

Casting

Answer

Compiling

Answer

Encrypting

Answer

Parsing

Question 36

Which data type would be most appropriate to store a person's age?

Accepted Answer

Integer

Answer

Character

Answer

Boolean

Answer

String

Question 37

In programming, what is a String typically used to represent?

Accepted Answer

A sequence of characters

Answer

A true or false value

Answer

A single character

Answer

An integer number

Question 38

Which data type would be best to store the outcome of a true/false quiz question?

Accepted Answer

Boolean

Answer

String

Answer

Character

Answer

Integer

Question 39

What component of an Integrated Development Environment (IDE) is primarily responsible for converting source code into machine code?

Accepted Answer

Translators

Answer

Run-time environment

Answer

Editors

Answer

Error diagnostics

Question 40

In an Integrated Development Environment (IDE), what is the primary tool used for writing and modifying source code?

Accepted Answer

Editors

Answer

Translators

Answer

Error diagnostics

Answer

Run-time environment

Question 41

Which of the following expressions is true if A is true, B is false, and C is true?

Accepted Answer

A AND B OR NOT C

Answer

NOT A AND B OR C

Answer

A OR NOT B AND C

Answer

A AND NOT B OR C

Question 42

Given that A is true, B is true, and C is false, which expression will evaluate to false?

Accepted Answer

B AND C

Answer

A AND NOT C

Answer

NOT B OR C

Answer

A OR C

Question 43

What will be the output of concatenating the strings "Hello" and "World"?

Accepted Answer

HelloWorld

Answer

HWorld

Answer

Hellod

Answer

Hello World

Question 44

In Python, which function would you use to convert a string '1234' into an integer?

Accepted Answer

int()

Answer

float()

Answer

len()

Answer

str()

Question 45

Which method would you use in Python to remove white spaces from the beginning and end of a string?

Accepted Answer

strip()

Answer

split()

Answer

join()

Answer

replace()

Question 46

In Python, which string method would you use to convert all characters in a string to lowercase?

Accepted Answer

lower()

Answer

title()

Answer

upper()

Answer

capitalize()

Question 47

What is the result of using the string method .find() in Python to locate the position of 'a' in the string 'banana'?

Accepted Answer

1

Answer

3

Answer

2

Answer

0

Question 48

In Python, what will the expression 'hello'.upper() return?

Accepted Answer

HELLO

Answer

hello

Answer

hELLO

Answer

Hello

Question 49

Which technique is commonly used to prevent unauthorized access to online accounts by verifying a user's identity?

Accepted Answer

Authentication

Answer

Encryption

Answer

Compression

Answer

Defragmentation

Question 50

What is a common defensive design practice to anticipate misuse of a software system?

Accepted Answer

Input validation

Answer

Interface design

Answer

Code obfuscation

Answer

Feature extension

Question 51

What is a primary purpose of two-factor authentication (2FA) in computer systems?

Accepted Answer

To enhance security by requiring two forms of verification

Answer

To speed up the login process

Answer

To compress data for transmission

Answer

To reduce network latency

Question 52

What is an example of multi-factor authentication?

Accepted Answer

A password and a fingerprint scan

Answer

Answering a security question

Answer

Captcha verification only

Answer

Just a username

Question 53

Which term describes the process of ensuring only authorized users can access specific data or systems?

Accepted Answer

Access control

Answer

Data redundancy

Answer

Load balancing

Answer

Firewall configuration

Question 54

What is the purpose of implementing CAPTCHA in online forms?

Accepted Answer

To distinguish between human users and bots

Answer

To compress form data

Answer

To encrypt user data

Answer

To log user activity

Question 55

What is the main purpose of password hashing in authentication systems?

Accepted Answer

To securely store passwords by converting them into hash values

Answer

To synchronize passwords across multiple devices

Answer

To compress passwords for storage efficiency

Answer

To encrypt data for secure transmission

Question 56

Why is it important to use a secure recovery process for resetting passwords?

Accepted Answer

To prevent unauthorized users from accessing accounts

Answer

To provide users with password hints

Answer

To make it easier to remember passwords

Answer

To allow faster access to accounts

Question 57

What is an important consideration when designing a secure password policy?

Accepted Answer

Requiring a mix of letters, numbers, and symbols

Answer

Setting a very short minimum password length

Answer

Allowing password reuse

Answer

Restricting passwords to a single word

Question 58

What is the primary goal of using session timeouts in web applications?

Accepted Answer

To reduce the risk of unauthorized access by ending inactive sessions

Answer

To allow multiple users to share an account

Answer

To ensure data is encrypted

Answer

To improve website loading speed

Question 59

When testing a function that should only handle inputs of positive integers, which type of test data includes using inputs like -5?

Accepted Answer

Invalid

Answer

Erroneous

Answer

Boundary

Answer

Normal

Question 60

If a function is supposed to accept numbers from 1 to 100, which input would be considered boundary test data?

Accepted Answer

1

Answer

50

Answer

101

Answer

0

Related quizzes

Related quizzes