ITX203 Databases

Presentation

•

Computers

•

11th - 12th Grade

•

Hard

Andre Purcell

Used 9+ times

FREE Resource

26 Slides • 36 Questions

ITX203 Databases

Multiple Choice

To put data in order in a database, you would

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

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

ITX203 Databases

Show answer

Auto Play

Slide 1 / 62

SLIDE

Similar Resources on Wayground

58 questions

Regencia 2nd term quiz short

Presentation

•

59 questions

ECONOMICS TOPIC 3 LESSON 7 & 8

Presentation

•

12th Grade

51 questions

EmTechWk2Lesson1.2

Presentation

•

11th - 12th Grade

55 questions

Cliet Server

Presentation

•

12th Grade

52 questions

português - Termos da oração

Presentation

•

59 questions

Redes sociales

Presentation

•

57 questions

Human Body Tissues

Presentation

•

10th - 12th Grade

53 questions

Recap: Unit 1 Information Technology Systems - Summer Term

Presentation

•

12th Grade

Popular Resources on Wayground

24 questions

PBIS-HGMS Day 10

Quiz

•

6th - 8th Grade

10 questions

HCS SCI 03 Summer School Review 3

Quiz

•

3rd Grade

11 questions

Home Scope

Quiz

•

7th - 8th Grade

15 questions

HCS SCI 05 Summer School Assessment 3 Review

Quiz

•

5th Grade

35 questions

Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz

•

7th Grade

18 questions

Geo 11.3 Area of Circles and Sectors

Quiz

•

9th - 11th Grade

Discover more resources for Computers

18 questions

Geo 11.3 Area of Circles and Sectors

Quiz

•

9th - 11th Grade