T-Level Data quiz part 1

Identify two consistent items in a file-based structure.

• File name and file size

• File name and file extension

• File size and file location

• File extension and file location

What is a directory-based structure?

• A system that organises files into a single list

• A system that organises files into a hierarchy of folders

• A system that stores files in a database

• A system that uses tags to categorise files

What data modelling tool is used when creating a relational database?

• Flowchart

• Entity-Relationship Diagram (ERD)

• Gantt Chart

• Venn Diagram

Identify two features that can be used to reduce data redundancy.

• Data encryption and data compression

• Data normalisation and data indexing

• Data replication and data backup

• Data normalisation and data integrity constraints

What does SQL stand for?

• Structured Query Language

• Simple Query Language

• Standard Query Language

• System Query Language

Why should data be kept secure and private?

• To reduce storage costs

• To prevent unauthorised access and protect personal information

• To increase data redundancy

• To improve data processing speed

Identify one group that can maintain data.

• Data analysts

• Data scientists

• Database administrators

• Software developers

What does the digital system administrator control?

• The design of user interfaces

• The security and maintenance of digital systems

• The development of software applications

• The marketing of digital products

Identify one financial consideration of data storage.

• The speed of data retrieval

• The cost of data storage solutions

• The complexity of data structures

• The ease of data access

Why would new software have to be purchased?

• To increase the number of users

• To improve system compatibility and functionality

• To reduce the size of data files

• To enhance the colour scheme of the interface