allows you to specify multiple values in a where

What is a Caesar Cipher?

A type of simple substitution cipher with a fixed shift of letters

Combining elements to create effects in design

What does the COUNT statement return?

number of records that match criteria

How does "texture" contribute to visual communication?

Emphasises physical and visual qualities, creating illusions

Choosing whether code should run or not based on a condition.

What are functions used for?

Define a sequence of code by a name.

system's ability to provide all necessary functionality

Define Entity Relationship Diagrams

Flowchart that shows how entities relate to eachother

How can utility be improved?

Flexibility and efficiency of use

What is Kasiski Examination?

A decrypting technique exploiting repeated letters

What is a Vigenère Cipher?

A polyalphabetic cipher using a keyword to shift letters

How can an organisation/ agency use disclosed personal information?

For the reason why is was collected

Which of these is NOT an example of a string?

variable = ["Cat", "Dog", "Fish"]

What is a simple substitution cipher?

A type of substitution cipher with a constant letter shift

How does "balance" contribute to the effectiveness of visual communication?

Creates equal distribution of elements for symmetry

ability of users to do the work they need to do on the system

Making decisions using identified patterns in numbers or facts

What is a polyalphabetic cipher?

An encryption method where the letter shifts remain constant

What is a substitution cipher?

A method of encryption where each letter is replaced with another

What is the primary function of "contrast" in visual communication?

It creates visual differences to make elements stand out.

studbud

Year 11 Digital Solutions Revision

97 termsStudBud Administration22 plays

Imported from external platform

Flashcards97 cardsFPractice quizPHost liveL

Questions 97

Answers

1
What are sequence, iteration, selection, and modularistaton examples of?
Types of variables
Coding languages
Principles of visual design
Programming constructs
2
Which two SQL statements can be used interchangeably?
where/having
order by/group by
min/max
or/in
3
Which of these is NOT an example of iteration?
If statements
While loops
For loops
Do while loops
4
Data
Making decisions using identified patterns in numbers or facts
Identifying patterns in numbers or facts
Numbers or facts with context
Raw numbers or facts
5
What does IN do?
substitute for where
returns which categories records are in
allows you to specify multiple values in a where
idk
6
What programming construct is this an example of: putting steps in a logical order
Order
Selection
Sequence
Modularisation
7
Which is not a calculation function?
avg
min
count
desc
8
What is a Caesar Cipher?
A type of polyalphabetic cipher with a fixed shift of letters
A type of simple substitution cipher with a variable shift of letters
A type of simple substitution cipher with a fixed shift of letters
A type of polyalphabetic cipher with a variable shift of letters
9
Which of these is an example of modularistation?
Replacing simple code with complex code
Repeating instructions
Having only one table in a database
Use of functions
10
Which of these is not an example of a condition?
x >= y
k + 1
y == "why"
variable > 20.4
11
Which string does not have a length limit?
text
varchar
enum
char
12
How many principles of visual communicaiton are there?
5
8
6
7
13
How many elements of visual communication are there?
10
9
8
7
14
Which is the most accurate for storing decimals?
float
bit
int
double
15
Form
An artistic expression
Combining elements to create effects in design
Representation of three-dimensional objects
Visualization of concepts
16
What does the COUNT statement return?
primary keys of records that match criteria
count dracula
number of records that match criteria
all records that match criteria
17
How does "texture" contribute to visual communication?
It focuses on the emotional implications of color.
It represents materials and depth.
It represents a pleasing combination or arrangement of elements.
Emphasises physical and visual qualities, creating illusions
18
What does FROM select from?
a database
a statement
a table
a record
19
What is selection?
When users are able to access the website on any device they choose.
Choosing whether code should run or not based on a condition.
A type of variable which contains a whole number.
Entering new data into a table.
20
What are functions used for?
Storing numbers with more than 6 decimal places.
Define a sequence of code by a name.
Helping users with diabilities access the website.
Editing records in a table.
21
How do you select all records from a database?
SELECT tableName
SELECT %
SELECT ALL
SELECT *
22
Utility
system's ability to provide all necessary functionality
ability of users to do the work they need to do on the system
23
Define Entity Relationship Diagrams
A diagram used to simplify a database
Diagrams that present the order of the table
Displays the database and the order of its columns
Flowchart that shows how entities relate to eachother
24
A WHERE statement is for…
sorting results
filtering records
partial matching
selecting data
25
How can utility be improved?
Flexibility and efficiency of use
Consistancyand standards
error prevention
recognition rather than recall
26
What is Kasiski Examination?
A decrypting technique exploiting repeated sentences
A decrypting technique exploiting repeated phrases
A decrypting technique exploiting repeated letters
27
What is a Vigenère Cipher?
A simple substitution cipher using keyword letters to shift letters
A simple substitution cipher using keyword numbers to shift letters
A polyalphabetic cipher using a keyword to shift letters
A polyalphabetic cipher using a drawing to shift letters
28
20 tins of baked beans' is an example of
data
wisdom
information
knowledge
29
How can an organisation/ agency use disclosed personal information?
For Direct Marketing
Sell to Advertisers
Share info overseas
For the reason why is was collected
30
Who should be able to understand what your pseudocode does?
Just you
You and your external exam marker
You and people you explain it to
Everyone
31
An ORDER BY statement…
creates summary rows
brings peace to the land after the fire nation attack
puts primary keys in ascending order
sorts records by chosen value
32
For the last 5 years, over half of the store customers bought 20 tins of baked beans in Feb' is an example of
wisdom
data
knowledge
information
33
Which of these is NOT an example of a string?
variable = "kahoot"
variable = ["Cat", "Dog", "Fish"]
variable = "12345"
variable = "12.00234 cats"
34
What does SQL stand for?
Silly Quokka's Leaping
Serious Query Language
Structured Query Language
Stop (the) Queen Laughing
35
What is a simple substitution cipher?
A type of substitution cipher with a constant letter shift
A type of substitution cipher with no letter shift
A type of substitution cipher with a variable letter shift
A type of substitution cipher with a randomized letter shift
36
How does "balance" contribute to the effectiveness of visual communication?
It creates a sense of calmness or relaxation.
It provides an organized structure.
It focuses on the relationship between elements.
Creates equal distribution of elements for symmetry
37
Effectiveness
ability of users to do the work they need to do on the system
system's ability to provide all necessary functionality
38
Wisdom
Identifying patterns in numbers or facts
Numbers or facts with context
Making decisions using identified patterns in numbers or facts
Raw numbers or facts
39
What is a polyalphabetic cipher?
An encryption method where the letter shifts are randomized
An encryption method where there are no letter shifts
An encryption method where the letter shifts remain constant
An encryption method where the letter shifts change
40
Which type of variable is this: variable = "hello"?
Float
String
Integer
Boolean
41
Which programming construct is this an example of: if x == 2 then let y = 23
Selection
Iteration
Modularisation
If statement
42
What is condition?
True or false statements
Loops
All of the different types of variables
Disabilities which affect user's ability to use a website
43
What is the difference between a pseudocode FUNCTION and PROCEDURE?
PROCEDURE must include a RETURN
PROCEDURE doesn't exist
FUNCTION must include a RETURN
They are both the same
44
What is a substitution cipher?
A method of encryption where each letter is duplicated in the message
A method of encryption where each letter is replaced with another
A method of encryption where each letter is removed from the message
A method of encryption where each letter is scrambled in the message
45
How can safety be improved? (multiple answers)
minimalist design
thoubleshooting guide
visibility of system status
error prevention
46
How can effectivenenss be improved? (multiple answers)
Flexibility and effeicency of use)
Visibility of system status
troubleshooting guide
help and documentation
47
A GROUP BY statement is often used with…
where statements
select statemensts
used everywhere
calculation statements
48
What are rows called in Databases?
Records
Columns
Fields
Rows
49
What is the primary function of "contrast" in visual communication?
It guides a viewer's eye through the design.
It creates visual differences to make elements stand out.
It creates a sense of unity and harmony.
It ensures balance and harmony.
50
20' is an example of
wisdom
data
information
knowledge
51
Which programming construct is this an example of: while x <= 12 do x = x + 1
Selection
Repetition
Iteration
Function
52
For the last 5 years, lots of customers bought 20 tins of baked beans in Feb so we should stock more in Feb' is
information
knowledge
data
wisdom
53
How can "line" be used effectively in visual communication?
It emphasizes visual tension or energy.
it can be used to stress, connect, or dicide elemets in a design
It is a collection of dots in order.
It serves as an indication of boundaries.
54
What is iteration?
Using the same name for multiple variables.
Selecting whether a section of code will run based on a condition.
Using loops (repeated instructions) to avoid repeating unneccesary code.
The ability of users to recover from errors.
55
What is one-time pad encryption?
Unique key, msg length, not reused, sender+reciever have key
Unique key, shorter than msg, not reused
Unique key, msg length, only sender has key, not reused
Non-unique key, msg length, not reused
56
Knowledge
Numbers or facts with context
Raw numbers or facts
Making decisions using identified patterns in numbers or facts
Identifying patterns in numbers or facts
57
What is modularisation?
Using variables to store data.
Choosing whether code should run or not based on a condition.
Reducing complexity by breaking code up into units/modules.
Repeated instructions.
58
What does APP 7 state?
Agency that collects info must have a reasonable explanation for collecting
Organisations that share info overseas are responsible for how info is used
Organisation can not use info for direct marketing
Agency can only use personal information for the reason it was collected
59
Learnability
how easy a sytem is to teach
Ease of learning a system
60
Scale
A systematic series of ordered values
Relative size or extent of something
Size of an element relative to others in a design
A measurement tool
61
An if statement is an example of:
Sequence
Modularisation
Variable
Selection
62
What does an underscore do in SQL?
combines keywords
signifies unknown character
removes character limit
breaks up code
63
What does "proximity" refer to in visual communication?
the closeness of elements within a design space.
a relationship or connection between elements.
sense of cohesion and unity among design elements.
the size of elements relative to others in a design.
64
Accessibility
Ability to be used by few people, including people with diabilities
Ability to be used by many people including those with disabilities
Ability to be used by many people, excluding people with diabilities
Ability to be used by few people, excluding people with diabilities
65
What are variables?
Containers that store (remember) data so that we can use it elsewhere.
Different coding languages.
Different types of data.
A set of whole numbers greater than 0.
66
What does APP 2 state?
Collection of solicited personal information
Ability of a website to be used by anyone including the disabled
Anonymity and pseudonymity
Dealing with Unsolicited personal information
67
What is the correct datetime format?
CCYY-MM-DD, HH:MM:SS
CCYY-DD-MM, SS:MM:HH
DD-MM-YYCC, MM:HH:SS
american
68
How many usebility principles are there?
3
5
4
2
69
How can learnability be improved (multiple answers)
aesthetic and minimalist design
recognition rather than recall
Match between system and real world
consistancy and standards
70
Color
Used for contrast, emphasis, and emotional implications
An emotional reaction to light
Representation of different wavelengths of light
A reflection of a surface
71
What is sequence?
A type of variable which contains only letters.
A series of steps or instructions that follow one after the other.
A set of numbers.
Instructions that are repeated.
72
True or False: Hashing is one-directional
FALSE
TRUE
73
What does "repetition" do?
represent consistent visual characteristics in a design.
establish visual hierarchy.
makes it easier to create systems since things can be reused
create visual tension or energy.
74
Information
Numbers or facts with context
Making decisions using identified patterns in numbers or facts
Raw numbers or facts
Identifying patterns in numbers or facts
75
Which is not used for partial matching?
underscore
percent
having
like
76
Which is not a numeric data type?
decimal
int
float
binary
77
What is the primary purpose of "space" in visual communication?
It is the area available for design, used wisely to avoid clutter.
It refers to everything outside the earth's atmosphere.
It symbolizes the dimensions of length, width, and height.
It implies a particular extent of surface.
78
Which of these is not a real pseudocode keyword?
OUTPUT
END
CONDITION
INCREMENT
79
What is a Gronsfeld Cipher?
simple substitution cipher similar to Vigenère with a letter key directly
simple substitution cipher similar to Vigenère with a number key directly
A polyalphabetic cipher similar to Vigenère but uses a letter key directly
A polyalphabetic cipher similar to Vigenère but uses a number key directly
80
Safety
ensuring users can recover from mistakes
Protecting user's data and privacy
81
Which of these is an example of hashed text?
Wb7Q*sb&!2HW##!@B
92005ecf3788faea
ShWnXwbdXWU
cdmwqmqu
82
What is brute-force decryption?
A decrypting method trying all possible word frequencies
A decrypting method trying all possible letter combinations
A decrypting method trying all possible word lengths
A decrypting method trying all possible letter shifts
83
Shape
A flat, two-dimensional object
A three-dimensional object
Indicating volume and mass
Can be natural, abstract, or geometric, symbolically representing actions
84
Which SQL injection input would destroy the database?
" UNION SELECT * FROM users
John Smith
"; DROP TABLE users --
" OR 1=1
85
What is the difference between datetime and timestamp?
they have different vibes
one accounts for timezones
one accounts for weather (temp, humidity etc.)
one works internationally
86
What are Primary Keys used for?
To secure table information
A unique identifyer that is given to each record in the table
Aid in normalising a database
To organise information and data
87
How does "hierarchy" contribute to visual communication?
It establishes relationships or connections among elements.
creates a dominant-subdominant relationship among design elements
It creates visual tension or energy.
88
Why should passwords be hashed?
To avoid passwords being identical
So that if a hacker discovers the passwords, they will be unreadable
To speed up the SQL posting
So that passwords are never transferred in plaintext
89
How does "proportion" contribute to visual communication?
It ensures balance by comparing sizes between objects.
It emphasizes contrast among design elements.
Creates visual balance through the size of parts relative to others.
It creates a sense of visual tension or energy.
90
What is Friedman (Kappa Test)?
A method to decrypt substitution-permutation ciphers
A method to decrypt polyalphabetic ciphers
A method to decrypt transposition ciphers
A method to decrypt simple substitution ciphers
91
What is "tone" in visual communication?
It symbolizes a degree of saturation.
It refers to an emotional reaction.
It represents the perceived temperature of a color.
It is the lightness or darkness of an object's color, used for attention.
92
Martin LeBlanc quote
"A good user interface should be intuitive and easy to use."
"Users should be at the center of the design process."
"The user interface is a joke. If you have to explain it its not that good"
The success of a system depends on its usability."
93
Usebility
The effectiveness, efficiency, and satisfaction of a system
ability of system ot be used
A user-centered design approach
A quality attribute
94
Alignment
A way to create visual order or structure
A design technique
Arranging elements to create imaginary lines in a composition
A way to guide a viewer's eye
95
Harmony
A design goal
A lack of conflict or tension
Pleasing effect of combining similar elements in a design
A sense of visual cohesion or unity
96
Which APP refers to dealing with unsolicited information?
APP8
APP4
APP6
APP14
97
How can accessibility be improved? (multiple answers)
Error prevention
Flexibility and effeciency of use
Consistancy and standards
Minimalist design

Year 11 Digital Solutions Revision Flashcards | StudBud