Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

OCR Computing A Level LTS (Set 1) > Unit 4 Exchanging Data > Flashcards

Unit 4 Exchanging Data Flashcards

1
Q

What are the types of Compression?

A
  • Lossy
  • Lossless
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is Lossy Compression?

A

Removing non-essential data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is Lossless Compression?

A

Summarizing patterns in the data without permanently removing any data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is Run Length Encoding?

A

A basic method of coding that summarizes consecutive patterns of the same data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What does RLE work best on?

A

Image and sound data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is Dictionary Compression?

A

Spots regularly occurring data and stores it separately in a dictionary

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

How many bits is an ASCII character?

A

8

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is Encryption?

A

A way of making sure that data cant be read without a way to decrypt it

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is the Caesar Cypher?

A

A type of encryption where letters of the alphabet are shifted by a constant amount

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is a Brute Force Attack?

A

A method that attempts to apply every possible key to decrypt ciphertext until one works

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What is Frequency Analysis?

A

A method that looks at the most frequent characters in cypher text and comparing them to regular text

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is the Vernam Cypher?

A

A type of encryption, also know as the one-time pad. It is the only cypher text that is proven to be unbreakable

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What are the features of a Vernam Cypher key? (5)

A
  • Must be truly random
  • Must be greater or equal to the length of the plaintext
  • Must only be used once
  • Must be shared by hand separate to the original message
  • Must be destroyed immediately after use
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What is Symmetric Encryption?

A

Also known as private key encryption, the same key is used to encrypt and decrypt

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What is Asymmetric Encryption?

A

A type of encryption that uses 2 keys. One key (public key) is made public so that others can encrypt data before sending it to you. Another key (private key) is only known to you and can be used to decrypt the data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What is Hashing?

A

A type of encryption that is one-way and cannot go back to the original. Useful for storing encrypted PINs

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What is the simplest kind of Database?

A

A flat file consisting of information about a single entity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What is an Entity?

A

A category of object, person, event or thing of interest about which data needs to be recorded

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

What is an Entity Identifier?

A

A name which uniquely identifies a particular record (also known as primary key)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

What is a Composite Primary Key?

A

Where 2 or more attributes are needed to uniquely define a record

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

What are the Entity Relationships? (3)

A
  • One to one
  • One to many
  • Many to many
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

What is a Foreign Key?

A

An attribute that creates a join between 2 tables (relations)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

What is Referential Integrity?

A

Where no foreign key can reference a record that doesn’t exist in another table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Can a many to many relationship be directly linked?

A

No, an extra table is required

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

What is a Relational Database design? (5)

A
  • Data is held in tables called relations
  • One row holds one record
  • Each column represents one attribute
  • Each relation holds data about a single entity
  • A database has one or more relations
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

What is Normalization?

A

A process used to come up with the best possible design for a database where tables should be organized so data is not duplicated in the same table or different tables

27
Q

What is First Normal Form?

A

Contains no repeating attributes or groups of attributes

28
Q

What is Second Normal Form?

A

Contains no partial dependancies

29
Q

What is Third Normal Form?

A

No non-key dependencies

30
Q

What type of language is SQL?

A

Declarative

31
Q

What does the SELECT statement do?

A

Used to extract fields from one or more tables

32
Q

What is the order of the SELECT statement? (4)

A
  • SELECT
  • FROM
  • WHERE
  • ORDER BY
33
Q

What does the ORDER BY statement do?

A

Sorts the results of an SQL query. Can be ASC or DESC
e.g
ORDER BY Price DESC, productName ASC

34
Q

What does * mean in SQL?

A

All or one or many characters

35
Q

What does the LIKE statement do?

A

Searches for a pattern
e.g
WHERE subject LIKE “Comp*”

36
Q

What does the BETWEEN statement do?

A

Selects between a specified range

37
Q

How is the CREATE TABLE statement used?

A

Must state the name of the table and the limits of each attribute
e.g
CREATE TABLE tblProduct
(
ProductID CHAR(4) NOT NULL PRIMARY KEY,
Description VARCHAR(20) NOT NULL,
Price CURRENCY
)

38
Q

What is the CHAR(n) data type?

A

Character string or fixed length n

39
Q

What is the VARCHAR(n) data type

A

Character string variable length, max n

40
Q

What is the BOOLEAN data type?

A

True or false

41
Q

What is the INTEGER,INT data type?

A

Integer

42
Q

What is the FLOAT data type?

A

Number with a floating decimal point

43
Q

What is the DATE data type?

A

Day, month, year values

44
Q

What is the TIME data type?

A

Hour, minute, second values

45
Q

What is the CURRENCY data type?

A

Formats numbers in the currency used in your region

46
Q

What does the ALTER TABLE statement do?

A

Add, deletes or modifies columns in an existing table
e.g
ALTER TABLE tblProduct
ADD QtyInStock INTEGER
or
DROP QtyInStock
or
MODIFY COLUMN Description VARCHAR (30) NOT NULL

47
Q

What does the INSERT INTO statement do?

A

Inserts a new record into a table
e.g
INSERT INTO Product (ProductID, Description, Price),
VALUES (“A345”, “Pink Rabbit”, 7.50)

48
Q

What does the UPDATE statement do?

A

Updates a record in a table
e.g
INSERT INTO Product (ProductID, Description, Price),
VALUES (“A345”, “Pink Rabbit”, 7.50)

49
Q

What does the DELETE statement do?

A

Deletes a record in a table
e.g
DELETE FROM Product
WHERE ProductID = “A345”

50
Q

What is EDI?

A

Electronic Data Interchange
The computer-to-computer exchange of documents such as purchase orders, invoices and shipping documents. All documents must be a standard format s o the EDI translator can understand them

51
Q

What does ACID stand for? (4)

A
  • Atomicity
  • Consistency
  • Isolation
  • Durability
52
Q

What is Atomicity in ACID?

A

Requires that a transaction is completed fully or not at all

53
Q

What is Consistency in ACID?

A

Requires that every transaction meets the defined guidelines

54
Q

What is Isolation in ACID?

A

Requires that transactions done at the same time have the same result as if they were done one after the other

55
Q

What is Durability in ACID?

A

Requires that once a transaction has been completed it stays that way even in a power cut

56
Q

What is a problem with a Multi-User Database?

A

Allowing multiple users to simultaneously access a database could potentially cause one of the updates to be lost

57
Q

What is Record Locking and what does it prevent?

A

It prevents updates being lost or inconsistencies by locking access to objects that are being modified

58
Q

What is Deadlock?

A

A problem that occurs when two users are trying to update two records and neither can proceed

59
Q

What are the 2 types of Serialization?

A

Timestamp ordering, Commitment ordering

60
Q

What does Serialization do?

A

Makes sure that transactions do not overlap in time and therefore cannot interfere with each other or lead to updates being lost

61
Q

What is Timestamp Ordering?

A

Every object in the database has a read timestamp and a write timestamp. When a user tries to save an update, if the read timestamp is not the same as it was when they started the transaction, the DBMS knows another user has accessed the same object

62
Q

What is Commitment Ordering?

A

Transactions are ordered in terms of their dependencies on one another as well as the time they were initiated

63
Q

What is Redundancy?

A

Duplicate hardware, located in different geographical areas, mirrors every transaction that takes place on the main system. If the main system fails, this takes over

OCR Computing A Level LTS (Set 1) (13 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions