IFMG 300 Chapter 5

Description

Quiz on IFMG 300 Chapter 5, created by bjduguid on 20/09/2015.
bjduguid
Quiz by bjduguid, updated more than 1 year ago
bjduguid
Created by bjduguid over 9 years ago
8
0

Resource summary

Question 1

Question
Name the two major reasons for choosing to use a database rather than a spreadsheet: [blank_start]organize and keep track of things[blank_end] and [blank_start]keep track of multiple themes[blank_end],
Answer
  • organize and keep track of things
  • keep track of multiple themes

Question 2

Question
A database is made up of [blank_start]columns[blank_end] and [blank_start]rows.[blank_end]
Answer
  • columns
  • rows.

Question 3

Question
Columns are also known as [blank_start]fields[blank_end] while rows are also known as [blank_start]records.[blank_end]
Answer
  • fields
  • records.

Question 4

Question
A field is made up of a group of
Answer
  • bits
  • Bytes
  • Characters

Question 5

Question
Rows are also known as Fields
Answer
  • True
  • False

Question 6

Question
The components of a database are: [blank_start]tables (or files)[blank_end], [blank_start]the relationships among the rows[blank_end] and [blank_start]metadata[blank_end].
Answer
  • tables (or files)
  • the relationships among the rows
  • metadata

Question 7

Question
A database uses a [blank_start]key[blank_end] which is found in every record.
Answer
  • key

Question 8

Question
To remain [blank_start]ethical[blank_end], queries must be limited to determine only information required to run the business.
Answer
  • ethical

Question 9

Question
Metadata is data about [blank_start]data.[blank_end]
Answer
  • data.

Question 10

Question
The following are Database Management Systems (DBMS) which must be licensed from the vendor.
Answer
  • DB2
  • Access
  • MySQL
  • SQL Server
  • Oracle Database

Question 11

Question
User permissions will allow a user to perform none, some, or all of the following operations:
Answer
  • Read
  • Insert
  • Modify
  • Delete

Question 12

Question
In order to query a database, most popular DBMSs use:
Answer
  • DB2
  • Access
  • SQL

Question 13

Question
One of thethree main duties of a database administrator are: Setting up a security system which involves [blank_start]user accounts[blank_end], [blank_start]passwords[blank_end] and [blank_start]permission[blank_end].
Answer
  • user accounts
  • passwords
  • permission

Question 14

Question
Permissions determine who can [blank_start]insert[blank_end], [blank_start]read[blank_end], [blank_start]change[blank_end] and [blank_start]delete[blank_end] data.
Answer
  • change
  • insert
  • read
  • delete

Question 15

Question
A database security system involves creating [blank_start]user accounts[blank_end], [blank_start]password rules[blank_end], [blank_start]permissions[blank_end] and [blank_start]processing limits[blank_end].
Answer
  • password rules
  • permissions
  • processing limits
  • user accounts

Question 16

Question
A database administrator has four main categories of tasks. They are: [blank_start]development[blank_end], [blank_start]operation[blank_end], [blank_start]backup and recovery[blank_end] and [blank_start]adaptation[blank_end].
Answer
  • development
  • operation
  • backup and recovery
  • adaptation

Question 17

Question
A problem tracking system is created for the [blank_start]operation[blank_end] phase. A change tracking system is created for the [blank_start]adaptation[blank_end] phase.
Answer
  • operation
  • adaptation

Question 18

Question
Forms make it easier for users to:
Answer
  • View data
  • Insert new data
  • Update existing data
  • Delete existing data
  • Run reports

Question 19

Question
Queries allow users to search for data in an efficient manner.
Answer
  • True
  • False

Question 20

Question
Reports are less structured than queries.
Answer
  • True
  • False

Question 21

Question
Application programs query the database on behalf of the user.
Answer
  • True
  • False

Question 22

Question
A dynamic content report allows the user to click on a field to [blank_start]produce other reports[blank_end] or [blank_start]take other actions.[blank_end]
Answer
  • produce other reports
  • take other actions.

Question 23

Question
Multi-user processing problems occur when two or more users are simultaneously changing the same data.
Answer
  • True
  • False

Question 24

Question
Data models are used to determine entities and their relationships. These are required for [blank_start]efficient[blank_end] database design.
Answer
  • efficient

Question 25

Question
A student's date of birth is an entity.
Answer
  • True
  • False

Question 26

Question
An identifier (or key) must be unique.
Answer
  • True
  • False

Question 27

Question
Each attribute has and entity.
Answer
  • True
  • False

Question 28

Question
1:N signifies a [blank_start]one-to-many[blank_end] relationship.
Answer
  • one-to-many

Question 29

Question
N:M signifies a [blank_start]many-to-many[blank_end] relationship.
Answer
  • many-to-many

Question 30

Question
A vertical bar on a crow's foot diagram means that one entity is required.
Answer
  • True
  • False

Question 31

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

Question 32

Question
The normalization of a data model means converting [blank_start]one poorly structured table[blank_end] into [blank_start]two or more well structured tables[blank_end].
Answer
  • one poorly structured table
  • two or more well structured tables

Question 33

Question
Data integrity problems can result in:
Answer
  • Loss of confidence in the information
  • Incorrect or inconsistent information
  • A poor reputation for the system
  • Raises for everyone

Question 34

Question
Combining two tables into one can create problems with [blank_start]data integrity[blank_end].
Answer
  • data integrity

Question 35

Question
Each entity should have its own [blank_start]table[blank_end] with one [blank_start]attribute[blank_end] in each [blank_start]column[blank_end].
Answer
  • table
  • attribute
  • column

Question 36

Question
The final judge of whether a data model is accurate is
Answer
  • The database administrator
  • Experienced representatives of the business

Question 37

Question
A new types of DBMS called [blank_start]NoSQL[blank_end] is becoming popular in situations where relational models aren't needed or don't fit.
Answer
  • NoSQL

Question 38

Question
The three main attributes of NoSQL are that it supports [blank_start]very high transaction rates[blank_end], [blank_start]relatively simple data structures[blank_end] and can be replicated on many servers in the cloud.
Answer
  • very high transaction rates
  • relatively simple data structures

Question 39

Question
Examples of NoSQL are [blank_start]Dynamo[blank_end], [blank_start]Bigtable[blank_end] and [blank_start]Cassandra[blank_end].
Answer
  • Dynamo
  • Bigtable
  • Cassandra

Question 40

Question
Conversion to NoSQL is being done by many companies because it is easy to learn and easy to convert older systems.
Answer
  • True
  • False

Question 41

Question
SQL injection is one of the most common form of attacks.
Answer
  • True
  • False
Show full summary Hide full summary

Similar

Chapter 9 quiz
bjduguid
IFMG Chapter 11 quiz
bjduguid
Managing Information Systems
Clair Hat
Prefixe
biologa.dri
Multiple Choice type questions
Kingsley Enyiorj
CIS 200
Madalyn Geuke
MIS quiz
Ben Swift
IFMG Chapter 4
bjduguid
IFMG Chapter 10 quiz
bjduguid
IFMG 300 |Chapter 12
bjduguid