What is a simple substitution cipher?

A type of substitution cipher with a constant letter shift

What is a Gronsfeld Cipher?

A polyalphabetic cipher similar to Vigenère but uses a number key directly

A series of steps or instructions that follow one after the other.

Identifying patterns in numbers or facts

Containers that store (remember) data so that we can use it elsewhere.

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

What is Kasiski Examination?

A decrypting technique exploiting repeated letters

What are Primary Keys used for?

A unique identifyer that is given to each record in the table

Pleasing effect of combining similar elements in a design

What is a Vigenère Cipher?

A polyalphabetic cipher using a keyword to shift letters

allows you to specify multiple values in a where

How can utility be improved?

Flexibility and efficiency of use

What is a Caesar Cipher?

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

What are functions used for?

Define a sequence of code by a name.

Define Entity Relationship Diagrams

Flowchart that shows how entities relate to eachother

How does "proportion" contribute to visual communication?

Creates visual balance through the size of parts relative to others.

Making decisions using identified patterns in numbers or facts

Ability to be used by many people including those with disabilities

Used for contrast, emphasis, and emotional implications

What does "repetition" do?

represent consistent visual characteristics in a design.

Size of an element relative to others in a design

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

How does "hierarchy" contribute to visual communication?

creates a dominant-subdominant relationship among design elements

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

Year 11 Digital Solutions Revision Flashcards | StudBud