stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
General Revision 2 Flashcards | StudBud
Explore
/
General Revision 2
General Revision 2
14 terms
·
StudBud Administration
·
26 plays
Imported from external platform
Flashcards
14 cards
F
Practice quiz
P
Host live
L
Questions
14
Answers
1
What is the correct definition of the database term: 'Isolation'
A transaction should fully complete or not save at all
A transaction must only change the data in a DB following its rules
One transaction can't overwrite another one happening concurrently
Once a transaction starts it must be saved even if there is power loss
2
Keywords to use when discussing flat file vs relational databases:
Integrity
Redundancy/Duplication
Instantiates
Consistency
3
Why are protocols important on a network?
Allows devices to communicate
Ensures devices follow the same standards
Ensures there are no errors
So they interpret signals in the same way
4
What is the 'damping factor'
d
in the PageRank algorithm?
A value representing page links in
The probability of someone stopping clicking through links
A value representing page links out
A number between 0 and 1
5
What does a network switch do?
Joins devices on a LAN
Translates incoming packets of data from the internet
Links two different networks together
Sends and receives packets of data to the correct port/device
6
How do we ensure transactions are isolated (can't overwrite each other)
Entity Relationships
Validation/Verification
Record Locking
Referential Integrity
7
Data Mining. Your key points are?
Used for modelling/ planning for future/ making recommendations
Vast quantities of data are worked on by algorithms/AI
Has massive processing requirements
Uses pattern matching/ anomaly detection
8
Which formats/methods could the airport use to provide data to other airlines so they can use it in their own apps.
SQL
APIs
CSV files
JSON files
9
What affects how high up a page comes in results from a search engine?
The page rank of sites that link to it
The keywords in the meta data
The number of outgoing links from the site
The number of sites that link to that site
10
Artificial Intelligence: What is it?
Computers that can be trained to think, learn, make decisions
Things like speech recognition, recommendation engines, computer vision
Machine learning algorithms / neural networks
Robots that can do jobs instead of humans e.g. in manufacturing etc
11
What is the correct definition of the database term: 'Durable/ Durability'
A transaction should fully complete or not save at all
A transaction must only change the data in a DB following its rules
One transaction can't overwrite another one happening concurrently
Once a transaction starts it must be saved even if there is power loss
12
Which are
advantages
of storing the CSS externally rather than embedding it within HTML.
You can change CSS for different needs/ devices
Page content and formatting are separate
All pages are consistent
Updates affect all pages in a website
13
What is the difference between an ID attribute and a class attribute?
A DIV element uses an ID attribute/ a table uses a class
Only one element can use an ID/ a class can me used many times
Many elements can share an ID/ only one can use a class
An ID attribute is embedded in HTML code/ A class is external CSS
14
What is the correct definition of the database term: 'Atomic'
One transaction can't overwrite another one happening concurrently
A transaction should fully complete or not save at all
A transaction must only change the data in a DB following its rules
Once a transaction starts it must be saved even if there is power loss
