ITX203 Databases

ITX203 Databases

Multiple Choice

To put data in order in a database, you would

• Search

• Sort

• use a form

• design a table.

Multiple Choice

Which data type would be the best for a phone number?

• Text

• Autonumber

• Number

• None of these

Multiple Choice

Which of the following is an example of a record?

• 347

• ChannelType

• 351, Nature, Documentary, Bling, False

Multiple Choice

The HD field is using the data type Boolean

• True

• False

Multiple Choice

Which data type would be most suitable for Length?

• Number

• AutoNUmber

• Yes/No

• Short Text

Multiple Choice

Which of the following is an example of a field?

• TimesPlayed

• 004

• Holidays

Multiple Choice

Which of the following is a field in this database table?

• DistrictName

• 3

• Northend

• +

Multiple Select

Select the elements that make up the definition of a database

• Organised

• Collection of Information

• Manageable

• Fields

Multiple Choice

Microsoft Access is the only database software in use

• True

• False

Multiple Choice

The following two attributes from different tables will form a relationship:

• Supplier's ID and Item Supplier
• Quantity purchased and Quantity left
• Item name and supplier's ID

Multiple Choice

The following is not a valid type of a relationship:

• one-to-all
• one-to-one
• one-to-many
• many-to-many

Multiple Choice

Tables are set up to contain columns and rows of information. In a database table, the columns are called __________.

• Cell
• Field
• Column
• Record

Multiple Choice

Which attribute is the KEY IDENTIFIER or the PRIMARY KEY?

• EmpID
• Degree
• Name
• Birthday

Multiple Choice

This symbol indicates _____ relationship.

• one or many
• zero or many
• zero or one
• many to many

Multiple Choice

This symbol indicates _____ relationship.

• zero or one
  zero or one
• zero or many
• one or many
• many to many

Multiple Choice

Which data type would be the best for a post code?

• Text

• Autonumber

• Number

• None of these

Multiple Choice

Which view do you use to set up your tables?

• Query view

• Design view

• SQL view

• Datasheet view

Multiple Choice

Which is the best way for an end user to interact with our databases?

• Forms

• Tables

• Queries

• There is no best way

Multiple Choice

When adding buttons why would we use words?

• Easier for the user to understand

• Makes it boring for the person entering data

• Shows we can use good English

• Takes more time, so it must be better

Multiple Choice

Which symbol do we use for greater than or equal to?

• >=

• =>

• >:=

• >

Multiple Choice

To check if data entered is correct we use...

• Validation

• Queries

• Tables

• Forms

Multiple Select

Which two are types of relationships in a database?

• 1 to Many

• Many to Many

• Student and Teacher

• Teacher and Teacher

Multiple Choice

This is a...

• Form

• Table

• Report

• Spreadsheet

Multiple Choice

This is a....

• Table

• Form

• Report

• Spreadsheet

Multiple Select

Why do we use forms? (2 options)

• User friendly

• They can add data by themselves

• They can be customised for the company using the database

• Its just what we do

Multiple Choice

How can we limit the choice of data in a table?

• Lookup Wizard

• Be the only person to enter data into the database

• Don't do it, just let people put what they want

• People will know what to enter automatically

Multiple Choice

How would you define a relational database?

• A database consisting of data relating to families

• An online database

• A database linked to another database

• A database consisting of multiple tables, that are linked using keys

Multiple Choice

What is a flat-file database?

• A paper version of a database

• A compressed database

• A database consisting of one table only

• A database consisting of text only

Multiple Choice

A unique identifying field is a...

• Primary Key

• Integer

• Verification

• Boolean

Multiple Choice

A database search that can be saved as a separate file is a...

• Query

• Validation

• Filter

• Verification

Multiple Choice

A row in a database is a...

• Record

• Field

• Entity

• Table

Multiple Select

A phone book is an example of a 'Paper Database'.

• True

• False

Multiple Choice

What type of relationship should we not use in our database structure?

• One-to-One

• One-to-Many

• Many-to-Many

Multiple Choice

Complete the sentence below.

A _____ key is an attribute of a table that matches a primary key attribute in another table to create a relationship.

• Candidate

• Primary

• Foreign

• National

Multiple Choice

What is a candidate key?

• Any attribute, or group of attributes, that can uniquely identify a tuple in a relation.

• Any attribute, or group of attributes, that has no super key subsets.

• Any attribute, or group of attributes, that has been selected to be the unique identifier of each tuple in a relation.

• A combination of two fields that together can uniquely identify a record.

Multiple Choice

Complete the sentence below.

A ____________ relationship is where a single record of a table is related to a single record of another table.

• Many-to-many

• Many-to-one

• One-to-one

• One-to-many