Copiar e Editar

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 mais de 9 anos atrás
8
0
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

Quer criar seus próprios Quizzes gratuitos com a GoConqr? Saiba mais.

Semelhante

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
Explore a Biblioteca