Databases Knowledge Review Unit 2

Databases Knowledge Review Unit 2

Lets review the knowledge you have learned for databases

Multiple Choice

A tool used to organize, store, retrieve and communicate (report on) groups of related information.

• Spreadsheet

• Database

• Word Processing

• Desktop Publishing

Multiple Choice

What are the Four main objects in a database?

• Balance, Proximity, Unity, Consistency

• Spell Check, Grammar, Ruler, Tools

• Tables, Queries, Forms, Reports

• Cells, Columns, Rows, Entry

Multiple Choice

Students in a database are listed from shortest to tallest. This sort is an example of:

• ascending

• descending

Multiple Choice

Which is an example of a field that can be formatted with an input mask?

• Adult/Child

• Male/Female

• Yes/No

• Post code

Multiple Choice

What does Normalisation allow a database designer to do?

• Design their database efficiently, removing the chance of redundancy and inaccuracies.

• Remove additional records from the tables.

• Add as much data as they like.

• Draw an ERD.

Multiple Choice

A table where all attributes are dependent on the primary key and are independent of each other, and no row contains two or more multivalued facts about an entity, is said to be in ____.

• 1NF

• 2NF

• 3NF

• 4NF

Multiple Choice

To be in 2NF:

• Any field not relating to the PK is placed in a separate table

• The records all relate easily

• Each table has a foreign key

• There are no redundancies

Multiple Choice

Is this table in 2NF: purchase (customerID, storeID, storeLocation)?

• Yes

• No

Multiple Choice

To be in 3NF:

• Records do not depend on anything other than the table's PK

• The PK is not added

• The FKs are limited to one only

• The tables all relate to one another

Multiple Choice

What type of entity relationships always require a link table?

• One-to-one

• One-to-many

• Many-to-many

Multiple Choice

The ____ model views the data as part of a table or collection of tables in which all key values must be identified.

• relational

• object-oriented

• conceptual

• external

Multiple Choice

When you normalize a relation by breaking it into two smaller relations, what must you do to maintain data integrity?

• Remove any functional dependencies from both relations

• Assign both relations the same primary key field(s)

• Create a primary key(s) link for the new relation

Multiple Choice

A relation is in 1NF if it doesn't contain any ____________?

• Determinants

• Repeating groups

• Null values in primary key fields

• Functional dependencies

Multiple Choice

What is a foreign key?

• A unique identifier in a database

• A primary key of one table that appears in another table

• A field that should not be in a table and needs removing

Multiple Choice

What is an atomic field?

• A field that contains multiple items of data

• A field that is repeated

• A field that contains only one item of data

Multiple Choice

An advantage of normalisation is:

• The storage space needed for a normalised database is likely to be smaller

• The process of normalising a database is very easy and doesn’t require any skill

• It is possible to see previous details that have been changed, such as a customer’s address, as we can look back at an older entry

Multiple Choice

A disadvantage of normalisation is:

• The data loses its integrity as some of it is removed in the normalisation process

• The process of searching the database may be slower due to a higher demand on the central processing unit (CPU)

• Removing redundant data means that links cannot be created between tables

Multiple Choice

Which field in the Doctors Table makes each record unique?

• Doctor ID

• Last Name

• First Name

• Phone

Multiple Choice

In Figure F, the relationship of Doctors to Billing is:

• one-to-one.

• one-to-many.

• many-to-many.

• many-to-one.

Multiple Choice

A collection of fields that appear as a row in a database or table.

• Record

• Field

• Table

• Column

Multiple Choice

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

• Text

• Autonumber

• Number

• None of these

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? NOT examples!

• one to Many

• one to one

• Subject and Teacher

• Teacher and Teacher

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

What does SQL stand for?

• Structure Query Language

• Structured Queried Languages

• Standard Query Lingo

• Single Quandary Language

Multiple Choice

SINGLE ROW OF A TABLE IS CALLED

• TUPLE

• DOMAIN

• ATTRIBUTES

• COLUMN

Multiple Choice

Information Redundancy is Duplication of data due to storing the same data multiple times.

• True

• False

Multiple Select

Which type of relationship does the ERD represent?

• One-to-many

• Many-to-many

• One-to-one

Multiple Select

Which type of relationship does the ERD represent?

• One-to-many

• Many-to-many

• One-to-one

Multiple Choice

What is a composite primary key?

• A primary key that can be duplicated in the same table

• An attribute that is a primary key in another table

• A foreign key that is a primary key in more than one other table

• A primary key made up from two or more attributes

Multiple Choice

Identify the key field.

• Car registration number

• Amount paid

• Teacher name

• Car make

Multiple Choice

State how many different data types have been used in this database.

• 3

• 2

• 5

• 4

Multiple Choice

States that table relationships must be consistent. In other words, any foreign key field must agree with the primary key that is referenced by the foreign key.

• Foreign Key

• Primary Key

• Entity integrity

• Referential integrity