Zusammenfassung der Ressource
Frage 1
Antworten
-
persistent store of un-organised data.
-
persistent store of organised data.
-
persistent store of carefully selected and well organised data.
Frage 2
Frage
Persistent storage is...
Antworten
-
non-volatile storage on a secondary storage medium such as a hard disk.
-
volatile storage on a secondary storage medium such as RAM.
-
storage on a secondary storage medium such as a hard disk.
Frage 3
Frage
Data duplication (also known as data redundancy) is...
Antworten
-
where the same data is stored more than once, unnecessarily.
-
where the same data is stored only once, unnecessarily.
-
where the same data is stored unnecessarily.
Frage 4
Frage
Data inconsistency is...
Antworten
-
where different versions of data become different because duplicate versions have been stored.
-
where different versions of data become different because duplicate versions have been updated differently.
-
where different versions of data become different because duplicate versions have been stored and updated differently.
Frage 5
Frage
A Database Management System (DBMS)...
Antworten
-
separates the applications from the data and provides features that allow database systems to be created,
interrogated and maintained.
-
separates the applications from the data and provides features that allow database systems to be interrogated
and maintained.
-
separates the applications from the data and provides features that allow database systems to be created and
maintained.
Frage 6
Frage
A flat file database is...
Antworten
-
a persistent organised store of data where data is stored in a single file organised into fields.
-
a persistent organised store of data where data is stored in a single file organised into fields and records.
-
an organised store of data where data is stored in a single file organised into fields and records.
Frage 7
Frage
A relational database is...
Antworten
-
a persistent organised store of data where data is stored as a collection of tables to minimise data redundancy.
-
a persistent store of data where data is stored as a collection of related tables to minimise data redundancy.
-
a persistent organised store of data where data is stored as a collection of related tables to minimise data
redundancy.
Frage 8
Frage
An entity is a real world object, about which data is stored in a database and corresponds to...
Antworten
-
a table in a relational database.
-
a field in a relational database.
-
a primary key in a relational database.
Frage 9
Frage
A table is a collection of data organised into records and fields within a relational database. A table represents a...
Antworten
-
foreign key
-
real-world entity.
-
report.
Frage 10
Frage
Data stored about one instance of an entity, i.e. one particular person or object is called...
Antworten
-
table.
-
a record.
-
a field.
Frage 11
Frage
One specific data item being stored such as a surname or shoe size is called...
Antworten
-
a primary key.
-
a table.
-
a field.
Frage 12
Frage
A field in a table that uniquely identifies a record is called a...
Antworten
-
foreign key.
-
primary key.
-
entity key.
Frage 13
Frage
A field in one table that is a primary key in another table and is used to create a relationship between those two tables is called...
Antworten
-
a primary key.
-
a foreign key.
-
a relationship key.
Frage 14
Frage
A database form is...
Antworten
-
an interactive window used for data entry that doesn't include validation routines.
-
an interactive window used for data entry that always includes validation routines.
-
an interactive window used for data entry that usually includes validation routines.
Frage 15
Frage
When the computer software checks that data entered is sensible.
Antworten
-
Validation
-
Verification
-
Verify
-
Validate
Frage 16
Frage
Where data is entered twice and checked that each version is the same, to avoid data being entered with typing
mistakes.
Antworten
-
Validation
-
Verification
-
Validate
-
Verify
Frage 17
Frage
Where data is entered twice and checked that each version is the same, to avoid data being entered with typing
mistakes.
Antworten
-
Validation
-
Verification
-
Validate
-
Verify
Frage 18
Frage
A feature of a DBMS that allows the database to be interrogated. It selects records from the database based on
specified criteria.
Frage 19
Frage
Data from a database that has been processed and presented on a page in a way that makes it information.
Designed for hard copy.