Database System DKC4312

What are databases mainly used for?

• To store archived data

• To store and organise data

• To analyse data

Which of the following statements best defines the word 'database'?

• A database is a collection of data or information which is stored in a logical and structured way

• A database is a collection of statistics stored only for computers.

• A database does not collect data or information.

What is the difference between an entity and an attribute?

• An attribute is a table in a database and an entity is a field

• An attribute is a record in a database and an entity is a table

• An attribute is a field in a database and an entity is a table

Why would you create a primary key?

• To make each record in a database unique

• To make each field in a database unique

• To make each query in a database unique

A column name is otherwise known as a _____.

• field
• table
• row
• record

Which is the best example of a primary key?

• Driver's License Number
• Home Runs Hit
• Price
• First and Last Name

Data _____ helps ensure that an incorrect entry isn't made.

• validation
• checks
• accuracy
• integrity

A quick way to find data in a database is to use _____.

• queries
• quandries
• questions
• file folders

SQL stands for _____.

• structured query language
• sustainable query language
• structured question language
• sustainable question language

In a TABLE, a row is known as a...

• Information

• Column

• Data

• Record