Selecting and using suitable test data: Normal; Boundary; Invalid; Erroneous
Track each student's skills and progress in your Mastery dashboards
Give this quiz to my class
Q 1/60
Score 0
Which SQL keyword is used to retrieve data from a database?
30
SELECT
DELETE
UPDATE
INSERT
Q 2/60
Score 0
What SQL clause is used to filter records returned by a query?
30
HAVING
ORDER BY
GROUP BY
WHERE
60 questions
Q.
Which SQL keyword is used to retrieve data from a database?
1
30 sec
2.2.3d
Q.
What SQL clause is used to filter records returned by a query?
2
30 sec
2.2.3d
Q.
In SQL, which keyword is used to sort the result set of a query alphabetically or numerically?
3
30 sec
2.2.3d
Q.
What SQL keyword is used to eliminate duplicate records from the results?
4
30 sec
2.2.3d
Q.
Which SQL function is used to calculate the total number of rows in a query result?
5
30 sec
2.2.3d
Q.
Which of the following is a common syntax error in Python programs?
6
30 sec
2.1.2d
Q.
What is a common logic error that can occur in loop structures?
7
30 sec
2.1.2d
Q.
Which of the following could lead to a runtime error in a Python program?
8
30 sec
2.1.2d
Q.
What is a common semantic error in programming?
9
30 sec
2.1.2d
Q.
Which of the following is an example of a type error in a Python program?
10
30 sec
2.1.2d
Q.
Which mistake can lead to a NameError in a Python program?
11
30 sec
2.1.2d
Q.
What kind of error might occur if you try to open a file that doesn’t exist in Python?
12
30 sec
2.1.2d
Q.
What might result in an IndexError in a Python list?
13
30 sec
2.1.2d
Q.
What type of error is likely if you attempt to convert a non-numeric string to an integer in Python?
14
30 sec
2.1.2d
Q.
Which error might occur if you try to access a dictionary key that does not exist?
15
30 sec
2.1.2d
Q.
Which of the following is NOT a typical component used in flowcharts to represent an algorithm?
16
30 sec
2.1.2c
Q.
In pseudocode, what keyword is typically used to begin a loop that executes a set number of times?
17
30 sec
2.1.2c
Q.
What does a diamond shape represent in a flowchart?
18
30 sec
2.1.2c
Q.
What is the primary purpose of pseudocode in algorithm design?
19
30 sec
2.1.2c
Q.
Which of the following statements is true about high-level programming languages?
20
30 sec
2.1.2c
Q.
In a flowchart, which symbol is typically used to indicate a process?
21
30 sec
2.1.2c
Q.
Which control structure is used in pseudocode to repeatedly execute a block of code as long as a condition is true?
22
30 sec
2.1.2c
Q.
In a flowchart, which shape is conventionally used to indicate the start or end of a process?
23
30 sec
2.1.2c
Q.
Which keyword in pseudocode is typically used to execute different blocks of code based on different conditions?
24
30 sec
2.1.2c
Q.
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?
25
30 sec
2.1.3b
Q.
Which sorting algorithm divides the array into halves, sorts them, and then merges them back together?
26
30 sec
2.1.3b
Q.
Which of the following statements about binary search is true?
27
30 sec
2.1.3a
Q.
What is the main difference between linear search and binary search?
28
30 sec
2.1.3a
Q.
In which situation is a linear search more suitable than a binary search?
29
30 sec
2.1.3a
Q.
Which principle of computational thinking involves breaking down a complex problem into smaller, more manageable parts?
30
30 sec
2.1.1a
Q.
What principle of computational thinking focuses on identifying the important parts of a problem while ignoring irrelevant details?
31
30 sec
2.1.1a
Q.
Which principle of computational thinking helps in creating a step-by-step solution to solve a problem?
32
30 sec
2.1.1a
Q.
Which principle of computational thinking is primarily used to reduce complexity by grouping common characteristics?
33
30 sec
2.1.1a
Q.
In computational thinking, which principle is used to divide a problem into smaller, more manageable tasks?
34
30 sec
2.1.1a
Q.
What is the process of converting a value from one data type to another called?
35
30 sec
2.2.2a
Q.
Which data type would be most appropriate to store a person's age?
36
30 sec
2.2.2a
Q.
In programming, what is a String typically used to represent?
37
30 sec
2.2.2a
Q.
Which data type would be best to store the outcome of a true/false quiz question?
38
30 sec
2.2.2a
Q.
What component of an Integrated Development Environment (IDE) is primarily responsible for converting source code into machine code?
39
30 sec
2.5.2a
Q.
In an Integrated Development Environment (IDE), what is the primary tool used for writing and modifying source code?
40
30 sec
2.5.2a
Q.
Which of the following expressions is true if A is true, B is false, and C is true?
41
30 sec
2.4.1c
Q.
Given that A is true, B is true, and C is false, which expression will evaluate to false?
42
30 sec
2.4.1c
Q.
What will be the output of concatenating the strings "Hello" and "World"?
43
30 sec
2.2.3a
Q.
In Python, which function would you use to convert a string '1234' into an integer?
44
30 sec
2.2.3a
Q.
Which method would you use in Python to remove white spaces from the beginning and end of a string?
45
30 sec
2.2.3a
Q.
In Python, which string method would you use to convert all characters in a string to lowercase?
46
30 sec
2.2.3a
Q.
What is the result of using the string method .find() in Python to locate the position of 'a' in the string 'banana'?
47
30 sec
2.2.3a
Q.
In Python, what will the expression 'hello'.upper() return?
48
30 sec
2.2.3a
Q.
Which technique is commonly used to prevent unauthorized access to online accounts by verifying a user's identity?
49
30 sec
2.3.1a
Q.
What is a common defensive design practice to anticipate misuse of a software system?
50
30 sec
2.3.1a
Q.
What is a primary purpose of two-factor authentication (2FA) in computer systems?
51
30 sec
2.3.1a
Q.
What is an example of multi-factor authentication?
52
30 sec
2.3.1a
Q.
Which term describes the process of ensuring only authorized users can access specific data or systems?
53
30 sec
2.3.1a
Q.
What is the purpose of implementing CAPTCHA in online forms?
54
30 sec
2.3.1a
Q.
What is the main purpose of password hashing in authentication systems?
55
30 sec
2.3.1a
Q.
Why is it important to use a secure recovery process for resetting passwords?
56
30 sec
2.3.1a
Q.
What is an important consideration when designing a secure password policy?
57
30 sec
2.3.1a
Q.
What is the primary goal of using session timeouts in web applications?
58
30 sec
2.3.1a
Q.
When testing a function that should only handle inputs of positive integers, which type of test data includes using inputs like -5?
59
30 sec
2.3.2d
Q.
If a function is supposed to accept numbers from 1 to 100, which input would be considered boundary test data?