Kopieren und bearbeiten

IFMG 300 Chapter 5

Beschreibung

Quiz am IFMG 300 Chapter 5, erstellt von bjduguid am 20/09/2015.
bjduguid
Quiz von bjduguid, aktualisiert more than 1 year ago
bjduguid
Erstellt von bjduguid vor mehr als 8 Jahre
2
0
0

Zusammenfassung der Ressource

Frage 1

Frage
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],
Antworten
  • organize and keep track of things
  • keep track of multiple themes

Frage 2

Frage
A database is made up of [blank_start]columns[blank_end] and [blank_start]rows.[blank_end]
Antworten
  • columns
  • rows.

Frage 3

Frage
Columns are also known as [blank_start]fields[blank_end] while rows are also known as [blank_start]records.[blank_end]
Antworten
  • fields
  • records.

Frage 4

Frage
A field is made up of a group of
Antworten
  • bits
  • Bytes
  • Characters

Frage 5

Frage
Rows are also known as Fields
Antworten
  • True
  • False

Frage 6

Frage
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].
Antworten
  • tables (or files)
  • the relationships among the rows
  • metadata

Frage 7

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

Frage 8

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

Frage 9

Frage
Metadata is data about [blank_start]data.[blank_end]
Antworten
  • data.

Frage 10

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

Frage 11

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

Frage 12

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

Frage 13

Frage
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].
Antworten
  • user accounts
  • passwords
  • permission

Frage 14

Frage
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.
Antworten
  • change
  • insert
  • read
  • delete

Frage 15

Frage
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].
Antworten
  • password rules
  • permissions
  • processing limits
  • user accounts

Frage 16

Frage
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].
Antworten
  • development
  • operation
  • backup and recovery
  • adaptation

Frage 17

Frage
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.
Antworten
  • operation
  • adaptation

Frage 18

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

Frage 19

Frage
Queries allow users to search for data in an efficient manner.
Antworten
  • True
  • False

Frage 20

Frage
Reports are less structured than queries.
Antworten
  • True
  • False

Frage 21

Frage
Application programs query the database on behalf of the user.
Antworten
  • True
  • False

Frage 22

Frage
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]
Antworten
  • produce other reports
  • take other actions.

Frage 23

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

Frage 24

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

Frage 25

Frage
A student's date of birth is an entity.
Antworten
  • True
  • False

Frage 26

Frage
An identifier (or key) must be unique.
Antworten
  • True
  • False

Frage 27

Frage
Each attribute has and entity.
Antworten
  • True
  • False

Frage 28

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

Frage 29

Frage
N:M signifies a [blank_start]many-to-many[blank_end] relationship.
Antworten
  • many-to-many

Frage 30

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

Frage 31

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

Frage 32

Frage
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].
Antworten
  • one poorly structured table
  • two or more well structured tables

Frage 33

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

Frage 34

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

Frage 35

Frage
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].
Antworten
  • table
  • attribute
  • column

Frage 36

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

Frage 37

Frage
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.
Antworten
  • NoSQL

Frage 38

Frage
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.
Antworten
  • very high transaction rates
  • relatively simple data structures

Frage 39

Frage
Examples of NoSQL are [blank_start]Dynamo[blank_end], [blank_start]Bigtable[blank_end] and [blank_start]Cassandra[blank_end].
Antworten
  • Dynamo
  • Bigtable
  • Cassandra

Frage 40

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

Frage 41

Frage
SQL injection is one of the most common form of attacks.
Antworten
  • True
  • False
Zusammenfassung anzeigen Zusammenfassung ausblenden

Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.

ähnlicher Inhalt

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
Bibliothek durchsuchen