Principles of Business Information Systems

The basic storage structure in a relational database is the _________.
1. DBMS
2. Attribute
3. Entity
4. Table
A field that uniquely identifies a record is the ________.
1. Main field
2. Major key
3. Primary key
4. Foreign field
The number of entities involved in a relationship is known as the ________.
1. Degree
2. Key
3. Cardinality
4. Field
________ is an example of a DDL.
1. DML
2. SQL
3. CML
4. DBMS
A webpage that is freshly created every time someone visits it, using data from a database is _________.
1. HTML
2. Dynamic
3. Relational
4. Static
The process of trying to discover relationships and patterns in data that have not bee seen before is known as _________.
1. Data warehousing
2. Data mining
3. Counterintelligence
4. Database administration
Which of the following is not a common data mining application?
1. Fraud detection
2. Market basket analysis
3. Trend analysis
4. Transaction processing
A database spread across several smaller databases connected via telecomunications devices is __________.
1. Large
2. A warehouse
3. Distributed
4. Replicated
Software that allows users to explore data from different perspectives is known as _________.
1. OLAP
2. TSQL
3. DDL
4. DML
Police officers investigating a crime scene area may benefit from _______.
1. Live data
2. Object-oriented data
3. Current data
4. Spatial data
A(n) ____ is a skilled IS professional who directs all activities related to an organization’s database.
1. DBMS
2. DBA
3. IDBP
4. DBS
Many object-oriented databases have their own query language, called ____.
1. OQL
2. SQL
3. OOQL
4. ORQL
____ is a visual approach to developing database queries or requests.
1. DDL
2. QBE
3. DML
4. DAL
The ____ is a database model that describes data in which all data elements are placed in two-dimensional tables.
1. Table model
2. Relational model
3. Flat model
4. Object-oriented model
A ____ is a collection of instructions and commands used to define and describe data and data relationships in a specific database.
1. DDL
2. DAL
3. Data dictionary
4. DML

Principles of Business Information Systems – Chapter 5

Quiz