A database management system can be thought of as replacing an organisations:

Select one:

a.

Records

b.

Computers

c.

Telephone

d.

Filing cabinet

Question text

Primary keys are used to identify a unique set of records.

Select one:TrueFalse

Question text

Which of the following is not one of the strengths of the database approach?

Select one:

a.

Data can be kept more secure.

b.

Updating data is easier, as there is only one place where the data is housed.

c.

A database can ensure that each piece of data is recorded in only one place; therefore, one can control redundancy and prevent inconsistencies.

d.

Anyone can set up and edit a database.

Question text

Which of the following terms can be described as data that has been organised into tables from which data can be retrieved in a number of ways, with various views, without having to restructure the database tables themselves?

Select one:

a.

Relational database

b.

Data warehouse

c.

Entity relationship model

d.

Spreadsheet

Question text

This is the standard programming language used for creating, editing, and accessing data from a relational database:

Select one:

a.

Structured Query Language (SQL)

b.

Primary key

c.

Microsoft Access

d.

Oracle

Question text

You want to create a database that includes data about your 100 favourite songs of all time. Your database will include data related to the song title, artist, album, release date, etc. In your top 100 table, each record will represent:

Select one:

a.

A song

b.

An album

c.

An artist

d.

Release date

Question text

Which of the following holds a single piece of data?

Select one:

a.

Field

b.

Table

c.

Primary key

d.

Record

Question text

An attribute can be defined as a property of an entity or a relationship type.

Select one:TrueFalse

Information

Information text

Questions 913 relate to Figure 1 below:

Figure 1: Entity relationship model

Question text

Which one of the following statements is correct?

Select one:

a.

A hiring manager may oversee the work of one or more recruiters, but not all hiring managers necessarily oversee the work of any recruiters.

b.

A recruiter can only be assigned one hiring manager at a time.

c.

Each hiring manager oversees at least one recruiters work, and each recruiter has at least one hiring manager.

d.

Each hiring manager must oversee at least one recruiter.

Question text

The relationship between the Hiring manager and Job posting tables indicates that each job posting can only be registered under one hiring manager, and each hiring manager is assigned at least one job posting.

Select one:TrueFalse

Question text

The relationship between the Application and Applicant table indicates that:

Select one:

a.

There is a many-to-many relationship.

b.

There can be only one application per applicant.

c.

Not every application is linked to an applicant.

d.

Each application record is linked to only one applicant.

Question text

Which table will have more than two foreign keys?

Select one:

a.

Recruiter

b.

Hiring manager

c.

Application

d.

Job posting

Question text

Each hiring recruiter has at least one hiring manager.

Select one:TrueFalse

Question text

Databases prevent multiple users from accessing the data at the same time.

Select one:TrueFalse

Question text

A column that is used to enforce a relationship between two tables, so that the same data can be represented in more than one table without having to be re-entered, is called a:

Select one:

a.

Join

b.

Primary key

c.

Foreign key

d.

Entity relationship

Information Questions 913 relate to Figure 1 below: HIRING MANAGER JOB POSTING RECRUITER APPLICATION APPLICANT Ho Figure 1: Entity relationship model