stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
SLR 10 - Database Basics Flashcards | StudBud
Explore
/
SLR 10 - Database Basics
SLR 10 - Database Basics
24 terms
·
StudBud Administration
·
6 plays
SLR 10 - Database Basics OCR A Level Computer Science
Flashcards
24 cards
F
Practice quiz
P
Host live
L
Questions
24
Answers
1
DMLs are one way manage databases. The other is a DBMS, which stands for ...
Database management system
Database management structure
Database maintenance system
Database maintenance structure
2
We do indexing so that a database can be...
linked using a foreign key
searched quickly
encrypted easily
stored in a smaller amount of space
3
Something about which data will be stored e.g. a customer, a car
Field
Attribute
Record
Entity
4
The C in ACID stands for ...
Credible
Continuous
Commitment
Consistency
5
The I in ACID stands for ...
Innate
Instant
Isolation
Integrity
6
Select all file types commonly used for exchanging data.
JPEG
MP4
JSON
CSV
TXT
XML
7
A transaction can only contain one operation.
True
False
8
Which key term do we use to add data to an existing database?
APPEND
ADD
INSERT
EXTEND
9
Select all methods of collecting data
optical mark recognition
optical character recognition
barcode reader
magentic stripe
paper based forms
database management systems
10
Which of the following are used as wildcards?
%
_ (underscore)
*
#
11
Which wildcard is used to represent a single character?
%
_ (underscore)
*
12
The A in ACID stands for ...
Absolutely
Accompany
Atomicity
Asynchronously
13
Which wildcard is used to represent a zero, one or multiple characters?
%
*
_ (underscore)
14
The D in ACID stands for ...
Decode
Denote
Durability
Duration
15
A relational database only has one table.
True
False
16
Which of these is the technique used to prevent deadlock?
Commitment observering
Concurrent observering
Commitment ordering
Concurrrent ordering
17
Which key term do we use to remove an entire table or database?
DELETE
REMOVE
DROP
RETIRE
18
Which key term do we use to remove specific data from a table?
REMOVE
IGNORE
CUT
DELETE
19
Which wildcard is used to mean "all"?
%
*
_ (underscore)
20
SQL queries always need what at the end?
.
,
:
;
21
Record locking always prevents access to the entire database.
False
True
22
Concurrent processing allows transactions to happen ...
one after another
at the same time
23
A property/characteristic of an entity
Entity
Field
Record
Attribute
24
SQL is an example of a Database Management Language.
False
True
