Management Information System:

Please answer the following question correctly:

QUESTION 1

1. In a database, rows are also called ________.

   		records
   		fields
   		tables
   		files

QUESTION 2

1. In a database, columns are also called ________.

   		fields
   		files
   		records
   		tables

QUESTION 3

1. In a database, a table is formally referred to as a ________.

   		relation
   		record
   		field
   		matrix

QUESTION 4

1. In a database, a group of similar rows is called a ________.

   		record
   		table
   		field
   		matrix

QUESTION 5

1. In a database, a column or group of columns that identifies a unique row in a table is known as a ________.

   		key
   		record
   		field
   		file

QUESTION 6

1. One of the important functions of a database management system (DBMS) is to provide the necessary tools for ________.

   		encrypting emails
   		administering the database
   		testing program codes
   		encapsulating data objects

QUESTION 7

1. In a database, columns that are keys of a different table than the one in which they reside are known as ________ keys.

   		foreign
   		relational
   		alternate
   		candidate

QUESTION 8

1. SQL stands for ________.

   		Secondary Query Language
   		Simplified Query Language
   		Standard Query Language
   		Structured Query Language

QUESTION 9

1. The purpose of a database is to ________.

   		test and troubleshoot newly installed software
   		store lists of data involving multiple themes
   		describe and build computer architectures
   		design the source code for computer programs

QUESTION 10

1. Which of the following best describes the metadata in a database?

   		special data that is unique to a specific user
   		data that is stored in a Web site
   		special data that describes the structure of a database
   		programs used to create, process, and administer a database

QUESTION 11

1. Which of the following is a database management system (DBMS) product from Microsoft?

   		SQL Server
   		Sybase ASE
   		DB2
   		MySQL

QUESTION 12

1. With ________ like Microsoft Access, the application, DBMS, and database all reside on the user's computer.

   		a spreadsheet
   		a common database
   		a single user database
   		a simple query applications

QUESTION 13

1. ________ is a popular enterprise database management system (DBMS) product from IBM.

   		MySQL
   		SQL Server
   		Access
   		DB2

QUESTION 14

1. You would use Query by Example, if _____.

   	a.	you build a query from an example
   	b.	you use a template for reports
   	c.	you wish to use a visual approach to query building
   	d.	wish teach SQL with examples

QUESTION 15

1. All of the following are major functions of a database management system except:

   		Creating new databases and database applications
   		Identifying insufficient data processing or storage needs
   		Maintaining the quality of the data in an organization's databases
   		Using the databases of an organization to provide the information needed by its end users