Database

What is a primary key in a database?

• A field which uniquely identifies a record
• A table containing multiple fields
• A type of data structure in a database
• A software program used to create databases

What is the advantage of computerised databases over manual databases in terms of data storage?

• More data can be stored
• Data storage is more secure
• Data storage is cheaper
• Data storage is easier to access

What is a disadvantage of manual databases mentioned in the text?

• The same data may be duplicated since it is difficult to keep track of it
• Data is vulnerable to natural disasters
• It is difficult for more than one person to use at a time
• It is time consuming to add or retrieve data

Which data type consists of alphabets, numbers, and special characters?

• Text
• Date and time
• Unique value
• Numeric

What is the primary function of a primary key in a database?

• To uniquely identify a record
• To backup data
• To generate reports
• To sort data easily

What is a primary use of a database primary key?

• Facilitate search and retrieval
• Sort data alphabetically
• Store all data in one field
• Create new records

What is the purpose of designing the table structure in a database?

• Selecting correct datatype for each field
• Adding more fields
• Deleting fields
• Changing data format

What is a primary disadvantage of manual databases?

• Vulnerable to fire or natural disasters
• Limited storage space
• Time-consuming data analysis
• More difficult to retrieve data

What makes data analysis quicker in computerised databases?

• Reports are automatically generated
• Slow data retrieval
• Limited data storage
• Manual data entry

Which type of data consists of True/False or Yes/No values?

• Boolean
• Numeric
• Date and time
• Text