Chapter 11 Multiple Choice (Database)

Select the best answer for each question below. When you are finished, check your answers by clicking the 'Check Answers' button at the bottom of the page.

1. The perspective of viewing data that focuses on the meaning, content, and context of the data.

a- hierarchal b- logical c- physical d- relational

2. A collection of related fields is called a:

a- database b- file c- record d- relation

3. Also known as online, this type of processing occurs at the same time as the transaction occurs.

a- direct b- immediate c-method d- real-time

4. The part of the database management system that provides tools for maintaining and analyzing data is known as the:

a- data manipulation subsystem b- organizational data subsystem

c- processing subsystem d- SQL

5. A specialized database programming language:

a- Ajax b- Java c- C++ d- SQL

6. Which DBMS structure uses data cubes to represent multiple dimensions?

a- multidimensional b- network c- object-oriented d- relational

7. Compared to other data structures, this DBMS structure is more flexible and stores data as well as instructions to manipulate the data.

a- multidimensional b- network c- object-oriented d- relational

8. Object-oriented databases organize data using classes, objects, attributes, and:

a- methods b- relations c- space d- time

9. Also known as information utilities or data banks, these types of database are developed by organizations to cover particular subjects.

a- commercial b- company c- distributed d- individual

10. A technique used to search a data warehouse looking for related information and patterns is known as data:

a- browsing b- mining c- processing d- querying

True/False questions

  1. The part of the database management system that provides tools for maintaining and analyzing data is known as the→data manipulation subsystem True.
  2. A collection of related fields is called a→record True.
  3. Also known as information utilities or data banks, these types of database are developed by organizations to cover particular subjects→commercial True
  4. A specialized database programming language→SQL True
  5. Object-oriented databases organize data using classes, objects, attributes, and→SQL

False.

  1. Compared to other data structures, this DBMS structure is more flexible and stores data as well as instructions to manipulate the data→multidimensional False
  2. A technique used to search a data warehouse looking for related information and patterns is known as data→mining True
  3. Also known as online, this type of processing occurs at the same time as the transaction occurs→real-time True
  4. The perspective of viewing data that focuses on the meaning, content, and context of the data→methods False

Q3: Matching

Match the definitions with the terms in the box to the right by entering the letter for each term next to its correct definition below. When you are finished, check your answers by clicking the 'Check Answers' button at the bottom of the page.

1. / A collection of related records.
2. / An integrated collection of logically related tables.
3. / Also known as real-time, this type of processing occurs at the same time as the transaction occurs.
4. / Software used to create, modify, and gain access to a database.
5. / The part of the DBMS that provides tools and specialized programming languages is known as the _____ generation subsystem.
6. / Type of relationship when a child node has more than one parent node.
7. / DBMS structure that uses data cubes.
/ a. DBMS
b. database
c. many-to-many
d. multidimensional
e. online
f. application
j. table

Writing Questions:

  • Describe the five logical data groups or categories.
  • Identify and define the five part of DBMS programs.
  • What are the five types of databases?