Copy and Edit

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 about 9 years ago
6
0
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

Want to create your own Quizzes for free with GoConqr? Learn more.

Similar

Chapter 9 quiz
bjduguid
IFMG Chapter 11 quiz
bjduguid
Managing Information Systems
Clair Hat
MIS
Harry Riley
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
Browse Library