Quiz
IFMG 300 Chapter 5
This quiz has question types that open in the usual player.
Questions in this quiz (41)
1Name 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],
- Aorganize and keep track of things
- Bkeep track of multiple themes
2A database is made up of [blank_start]columns[blank_end] and [blank_start]rows.[blank_end]
- Acolumns
- Brows.
3Columns are also known as [blank_start]fields[blank_end] while rows are also known as [blank_start]records.[blank_end]
- Afields
- Brecords.
4A field is made up of a group of
- Abits
- BBytes
- CCharacters
5Rows are also known as Fields
- ATrue
- BFalse
6The 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].
- Atables (or files)
- Bthe relationships among the rows
- Cmetadata
7A database uses a [blank_start]key[blank_end] which is found in every record.
- Akey
8To remain [blank_start]ethical[blank_end], queries must be limited to determine only information required to run the business.
- Aethical
9Metadata is data about [blank_start]data.[blank_end]
- Adata.
10The following are Database Management Systems (DBMS) which must be licensed from the vendor.
- ADB2
- BAccess
- CMySQL
- DSQL Server
- EOracle Database
11User permissions will allow a user to perform none, some, or all of the following operations:
- ARead
- BInsert
- CModify
- DDelete
12In order to query a database, most popular DBMSs use:
- ADB2
- BAccess
- CSQL
13One 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].
- Auser accounts
- Bpasswords
- Cpermission
14Permissions 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.
- Achange
- Binsert
- Cread
- Ddelete
15A 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].
- Apassword rules
- Bpermissions
- Cprocessing limits
- Duser accounts
16A 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].
- Adevelopment
- Boperation
- Cbackup and recovery
- Dadaptation
17A 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.
- Aoperation
- Badaptation
18Forms make it easier for users to:
- AView data
- BInsert new data
- CUpdate existing data
- DDelete existing data
- ERun reports
19Queries allow users to search for data in an efficient manner.
- ATrue
- BFalse
20Reports are less structured than queries.
- ATrue
- BFalse
21Application programs query the database on behalf of the user.
- ATrue
- BFalse
22A 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]
- Aproduce other reports
- Btake other actions.
23Multi-user processing problems occur when two or more users are simultaneously changing the same data.
- ATrue
- BFalse
24Data models are used to determine entities and their relationships. These are required for [blank_start]efficient[blank_end] database design.
- Aefficient
25A student's date of birth is an entity.
- ATrue
- BFalse
26An identifier (or key) must be unique.
- ATrue
- BFalse
27Each attribute has and entity.
- ATrue
- BFalse
281:N signifies a [blank_start]one-to-many[blank_end] relationship.
- Aone-to-many
29N:M signifies a [blank_start]many-to-many[blank_end] relationship.
- Amany-to-many
30A vertical bar on a crow's foot diagram means that one entity is required.
- ATrue
- BFalse
31A small oval on a crow's foot diagram signifies that the relationship need not have an entity of that type.
- ATrue
- BFalse
32The 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].
- Aone poorly structured table
- Btwo or more well structured tables
33Data integrity problems can result in:
- ALoss of confidence in the information
- BIncorrect or inconsistent information
- CA poor reputation for the system
- DRaises for everyone
34Combining two tables into one can create problems with [blank_start]data integrity[blank_end].
- Adata integrity
35Each entity should have its own [blank_start]table[blank_end] with one [blank_start]attribute[blank_end] in each [blank_start]column[blank_end].
- Atable
- Battribute
- Ccolumn
36The final judge of whether a data model is accurate is
- AThe database administrator
- BExperienced representatives of the business
37A 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.
- ANoSQL
38The 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.
- Avery high transaction rates
- Brelatively simple data structures
39Examples of NoSQL are [blank_start]Dynamo[blank_end], [blank_start]Bigtable[blank_end] and [blank_start]Cassandra[blank_end].
- ADynamo
- BBigtable
- CCassandra
40Conversion to NoSQL is being done by many companies because it is easy to learn and easy to convert older systems.
- ATrue
- BFalse
41SQL injection is one of the most common form of attacks.
- ATrue
- BFalse
Information
- Description
- Quiz on IFMG 300 Chapter 5, created by bjduguid on 20/09/2015.
- Author
- bjduguid
- Language
- English
- Views
- 20
- Tags
- Rating
- No ratings yet Rate this quiz