bjduguid
Quiz by , created more than 1 year ago

Quiz on IFMG 300 Chapter 5, created by bjduguid on 20/09/2015.

7
0
0
bjduguid
Created by bjduguid about 9 years ago
Close

IFMG 300 Chapter 5

Question 1 of 41

1

Fill the blank spaces to complete the text.

Name the two major reasons for choosing to use a database rather than a spreadsheet: and ,

Explanation

Question 2 of 41

1

Fill the blank spaces to complete the text.

A database is made up of and

Explanation

Question 3 of 41

1

Fill the blank spaces to complete the text.

Columns are also known as while rows are also known as

Explanation

Question 4 of 41

1

A field is made up of a group of

Select one or more of the following:

  • bits

  • Bytes

  • Characters

Explanation

Question 5 of 41

1

Rows are also known as Fields

Select one of the following:

  • True
  • False

Explanation

Question 6 of 41

1

Fill the blank spaces to complete the text.

The components of a database are: , and .

Explanation

Question 7 of 41

1

Fill the blank space to complete the text.

A database uses a which is found in every record.

Explanation

Question 8 of 41

1

Fill the blank space to complete the text.

To remain , queries must be limited to determine only information required to run the business.

Explanation

Question 9 of 41

1

Fill the blank space to complete the text.

Metadata is data about

Explanation

Question 10 of 41

1

The following are Database Management Systems (DBMS) which must be licensed from the vendor.

Select one or more of the following:

  • DB2

  • Access

  • MySQL

  • SQL Server

  • Oracle Database

Explanation

Question 11 of 41

1

User permissions will allow a user to perform none, some, or all of the following operations:

Select one or more of the following:

  • Read

  • Insert

  • Modify

  • Delete

Explanation

Question 12 of 41

1

In order to query a database, most popular DBMSs use:

Select one or more of the following:

  • DB2

  • Access

  • SQL

Explanation

Question 13 of 41

1

Fill the blank spaces to complete the text.

One of thethree main duties of a database administrator are: Setting up a security system which involves , and .

Explanation

Question 14 of 41

1

Fill the blank spaces to complete the text.

Permissions determine who can , , and data.

Explanation

Question 15 of 41

1

Fill the blank spaces to complete the text.

A database security system involves creating , , and .

Explanation

Question 16 of 41

1

Fill the blank spaces to complete the text.

A database administrator has four main categories of tasks. They are: , , and .

Explanation

Question 17 of 41

1

Fill the blank spaces to complete the text.

A problem tracking system is created for the phase. A change tracking system is created for the phase.

Explanation

Question 18 of 41

1

Forms make it easier for users to:

Select one or more of the following:

  • View data

  • Insert new data

  • Update existing data

  • Delete existing data

  • Run reports

Explanation

Question 19 of 41

1

Queries allow users to search for data in an efficient manner.

Select one of the following:

  • True
  • False

Explanation

Question 20 of 41

1

Reports are less structured than queries.

Select one of the following:

  • True
  • False

Explanation

Question 21 of 41

1

Application programs query the database on behalf of the user.

Select one of the following:

  • True
  • False

Explanation

Question 22 of 41

1

Fill the blank spaces to complete the text.

A dynamic content report allows the user to click on a field to or

Explanation

Question 23 of 41

1

Multi-user processing problems occur when two or more users are simultaneously changing the same data.

Select one of the following:

  • True
  • False

Explanation

Question 24 of 41

1

Fill the blank space to complete the text.

Data models are used to determine entities and their relationships. These are required for database design.

Explanation

Question 25 of 41

1

A student's date of birth is an entity.

Select one of the following:

  • True
  • False

Explanation

Question 26 of 41

1

An identifier (or key) must be unique.

Select one of the following:

  • True
  • False

Explanation

Question 27 of 41

1

Each attribute has and entity.

Select one of the following:

  • True
  • False

Explanation

Question 28 of 41

1

Fill the blank space to complete the text.

1:N signifies a relationship.

Explanation

Question 29 of 41

1

Fill the blank space to complete the text.

N:M signifies a relationship.

Explanation

Question 30 of 41

1

A vertical bar on a crow's foot diagram means that one entity is required.

Select one of the following:

  • True
  • False

Explanation

Question 31 of 41

1

A small oval on a crow's foot diagram signifies that the relationship need not have an entity of that type.

Select one of the following:

  • True
  • False

Explanation

Question 32 of 41

1

Fill the blank spaces to complete the text.

The normalization of a data model means converting into .

Explanation

Question 33 of 41

1

Data integrity problems can result in:

Select one or more of the following:

  • Loss of confidence in the information

  • Incorrect or inconsistent information

  • A poor reputation for the system

  • Raises for everyone

Explanation

Question 34 of 41

1

Fill the blank space to complete the text.

Combining two tables into one can create problems with .

Explanation

Question 35 of 41

1

Fill the blank spaces to complete the text.

Each entity should have its own with one in each .

Explanation

Question 36 of 41

1

The final judge of whether a data model is accurate is

Select one of the following:

  • The database administrator

  • Experienced representatives of the business

Explanation

Question 37 of 41

1

Fill the blank space to complete the text.

A new types of DBMS called is becoming popular in situations where relational models aren't needed or don't fit.

Explanation

Question 38 of 41

1

Fill the blank spaces to complete the text.

The three main attributes of NoSQL are that it supports , and can be replicated on many servers in the cloud.

Explanation

Question 39 of 41

1

Fill the blank spaces to complete the text.

Examples of NoSQL are , and .

Explanation

Question 40 of 41

1

Conversion to NoSQL is being done by many companies because it is easy to learn and easy to convert older systems.

Select one of the following:

  • True
  • False

Explanation

Question 41 of 41

1

SQL injection is one of the most common form of attacks.

Select one of the following:

  • True
  • False

Explanation

Previous
Next