IFMG 300 Chapter 5

Descrição

Quiz sobre IFMG 300 Chapter 5, criado por bjduguid em 20-09-2015.
bjduguid
Quiz por bjduguid, atualizado more than 1 year ago
bjduguid
Criado por bjduguid aproximadamente 9 anos atrás
7
0

Resumo de Recurso

Questão 1

Questão
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],
Responda
  • organize and keep track of things
  • keep track of multiple themes

Questão 2

Questão
A database is made up of [blank_start]columns[blank_end] and [blank_start]rows.[blank_end]
Responda
  • columns
  • rows.

Questão 3

Questão
Columns are also known as [blank_start]fields[blank_end] while rows are also known as [blank_start]records.[blank_end]
Responda
  • fields
  • records.

Questão 4

Questão
A field is made up of a group of
Responda
  • bits
  • Bytes
  • Characters

Questão 5

Questão
Rows are also known as Fields
Responda
  • True
  • False

Questão 6

Questão
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].
Responda
  • tables (or files)
  • the relationships among the rows
  • metadata

Questão 7

Questão
A database uses a [blank_start]key[blank_end] which is found in every record.
Responda
  • key

Questão 8

Questão
To remain [blank_start]ethical[blank_end], queries must be limited to determine only information required to run the business.
Responda
  • ethical

Questão 9

Questão
Metadata is data about [blank_start]data.[blank_end]
Responda
  • data.

Questão 10

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

Questão 11

Questão
User permissions will allow a user to perform none, some, or all of the following operations:
Responda
  • Read
  • Insert
  • Modify
  • Delete

Questão 12

Questão
In order to query a database, most popular DBMSs use:
Responda
  • DB2
  • Access
  • SQL

Questão 13

Questão
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].
Responda
  • user accounts
  • passwords
  • permission

Questão 14

Questão
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.
Responda
  • change
  • insert
  • read
  • delete

Questão 15

Questão
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].
Responda
  • password rules
  • permissions
  • processing limits
  • user accounts

Questão 16

Questão
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].
Responda
  • development
  • operation
  • backup and recovery
  • adaptation

Questão 17

Questão
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.
Responda
  • operation
  • adaptation

Questão 18

Questão
Forms make it easier for users to:
Responda
  • View data
  • Insert new data
  • Update existing data
  • Delete existing data
  • Run reports

Questão 19

Questão
Queries allow users to search for data in an efficient manner.
Responda
  • True
  • False

Questão 20

Questão
Reports are less structured than queries.
Responda
  • True
  • False

Questão 21

Questão
Application programs query the database on behalf of the user.
Responda
  • True
  • False

Questão 22

Questão
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]
Responda
  • produce other reports
  • take other actions.

Questão 23

Questão
Multi-user processing problems occur when two or more users are simultaneously changing the same data.
Responda
  • True
  • False

Questão 24

Questão
Data models are used to determine entities and their relationships. These are required for [blank_start]efficient[blank_end] database design.
Responda
  • efficient

Questão 25

Questão
A student's date of birth is an entity.
Responda
  • True
  • False

Questão 26

Questão
An identifier (or key) must be unique.
Responda
  • True
  • False

Questão 27

Questão
Each attribute has and entity.
Responda
  • True
  • False

Questão 28

Questão
1:N signifies a [blank_start]one-to-many[blank_end] relationship.
Responda
  • one-to-many

Questão 29

Questão
N:M signifies a [blank_start]many-to-many[blank_end] relationship.
Responda
  • many-to-many

Questão 30

Questão
A vertical bar on a crow's foot diagram means that one entity is required.
Responda
  • True
  • False

Questão 31

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

Questão 32

Questão
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].
Responda
  • one poorly structured table
  • two or more well structured tables

Questão 33

Questão
Data integrity problems can result in:
Responda
  • Loss of confidence in the information
  • Incorrect or inconsistent information
  • A poor reputation for the system
  • Raises for everyone

Questão 34

Questão
Combining two tables into one can create problems with [blank_start]data integrity[blank_end].
Responda
  • data integrity

Questão 35

Questão
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].
Responda
  • table
  • attribute
  • column

Questão 36

Questão
The final judge of whether a data model is accurate is
Responda
  • The database administrator
  • Experienced representatives of the business

Questão 37

Questão
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.
Responda
  • NoSQL

Questão 38

Questão
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.
Responda
  • very high transaction rates
  • relatively simple data structures

Questão 39

Questão
Examples of NoSQL are [blank_start]Dynamo[blank_end], [blank_start]Bigtable[blank_end] and [blank_start]Cassandra[blank_end].
Responda
  • Dynamo
  • Bigtable
  • Cassandra

Questão 40

Questão
Conversion to NoSQL is being done by many companies because it is easy to learn and easy to convert older systems.
Responda
  • True
  • False

Questão 41

Questão
SQL injection is one of the most common form of attacks.
Responda
  • True
  • False

Semelhante

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