Question 1

Describe entities in the context of data models.

Accepted Answer

An entity is something that the users wa

Question 2

Users are the final judges as to what data the database should contain and how the records in that database should be related to one another.

Accepted Answer

A) True 
 B)False

Question 3

________ allow users to read, insert, modify, and delete data in a database.

Accepted Answer

A)  Reports 
B)  Forms 
C)  Queries 
D)  Operations 
A)  Reports 
B)  Forms 
C)  Queries 
D)  Operations

Question 4

Browser-based applications ________.

Accepted Answer

A)  are thick-client applications 
B)  can display only static content 
C)  support graphical queries 
D)  process queries using C++ 
A)  are thick-client applications 
B)  can display only static content 
C)  support graphical queries 
D)  process queries using C++

Question 5

A(n) ________ is a program used to create, process, and administer a database.

Accepted Answer

A)  operating system 
B)  database management system 
C)  information system 
D)  database system 
A)  operating system 
B)  database management system 
C)  information system 
D)  database system

Question 6

Each table in a database must have two or more primary keys.

Accepted Answer

A) True 
 B)False

Question 7

Normalization is the process of combining two or more tables into a single table.

Accepted Answer

A) True 
 B)False

Question 8

Normalized tables are faster to process than tables that haven't been normalized.

Accepted Answer

A) True 
 B)False

Question 9

A database application is a collection of forms, reports, queries, and application programs that serves as an intermediary between users and database data.

Accepted Answer

A) True 
 B)False

Question 10

A many-to-many (N:M) relationship means that more than one entity is allowed on each side of the relationship and that the number of entities on each side can be different.

Accepted Answer

A) True 
 B)False

Question 11

Reports refer to the structured presentation of data using sorting, grouping, filtering, and other operations.

Accepted Answer

A) True 
 B)False

Question 12

A database management system (DBMS) is a program used to create, process, and administer a database.

Accepted Answer

A) True 
 B)False

Question 13

Constraints on the minimum number of entities in a relationship are called ________ cardinalities.

Accepted Answer

A)  specific 
B)  minimum 
C)  primary 
D)  critical 
A)  specific 
B)  minimum 
C)  primary 
D)  critical

Question 14

Which of the following is an example of a database management system?

Accepted Answer

A)  MS Excel 
B)  BigData 
C)  NoSQL 
D)  Access 
A)  MS Excel 
B)  BigData 
C)  NoSQL 
D)  Access

Question 15

MySQL is an open source DBMS product that is license-free for most database applications.

Accepted Answer

A) True 
 B)False

Question 16

Identify an open source DBMS product.

Accepted Answer

A)  MySQL 
B)  DB2 
C)  Access 
D)  Oracle Database 
A)  MySQL 
B)  DB2 
C)  Access 
D)  Oracle Database

Question 17

A key is a column or group of columns that identifies a unique row in a table.

Accepted Answer

A) True 
 B)False

Question 18

Browser applications are thin-client applications that ________.

Accepted Answer

A)  use COBOL as the standard language for user-side processing 
B)  are processed using VisualBasic and C++ 
C)  need not be pre installed on the users' computers 
D)  depend on internal networks and not the Internet to transmit data 
A)  use COBOL as the standard language for user-side processing 
B)  are processed using VisualBasic and C++ 
C)  need not be pre installed on the users' computers 
D)  depend on internal networks and not the Internet to transmit data

Question 19

A student management system allows students to have multiple majors, and advisers are assigned to handle multiple students and courses. This is an example of a(n) ________ relationship.

Accepted Answer

A)  1:N 
B)  1:1 
C)  N:M 
D)  M:1 
A)  1:N 
B)  1:1 
C)  N:M 
D)  M:1

Question 20

Browser applications are thin-client applications that need to be pre-installed on the users' computers.

Accepted Answer

A) True 
 B)False

Describe entities in the context of data models.

Users are the final judges as to what data the database should contain and how the records in that database should be related to one another.

________ allow users to read, insert, modify, and delete data in a database.

Browser-based applications ________.

A(n) ________ is a program used to create, process, and administer a database.

Each table in a database must have two or more primary keys.

Normalization is the process of combining two or more tables into a single table.

Normalized tables are faster to process than tables that haven't been normalized.

A database application is a collection of forms, reports, queries, and application programs that serves as an intermediary between users and database data.

A many-to-many (N:M) relationship means that more than one entity is allowed on each side of the relationship and that the number of entities on each side can be different.

Reports refer to the structured presentation of data using sorting, grouping, filtering, and other operations.

A database management system (DBMS) is a program used to create, process, and administer a database.

Constraints on the minimum number of entities in a relationship are called ________ cardinalities.

Which of the following is an example of a database management system?

MySQL is an open source DBMS product that is license-free for most database applications.

Identify an open source DBMS product.

A key is a column or group of columns that identifies a unique row in a table.

Browser applications are thin-client applications that ________.

A student management system allows students to have multiple majors, and advisers are assigned to handle multiple students and courses. This is an example of a(n) ________ relationship.

Browser applications are thin-client applications that need to be pre-installed on the users' computers.

The Importance of MIS

Collaboration Information Systems

Strategy and Information Systems

Hardware, Software, and Mobile Systems

The Cloud

Processes, Organizations, and Information Systems

Social Media Information Systems

Business Intelligence Systems

Information Systems Security

Information Systems Management

Information Systems Development

Filters

Exam 5: Database Processing

Describe entities in the context of data models.

Users are the final judges as to what data the database should contain and how the records in that database should be related to one another.

________ allow users to read, insert, modify, and delete data in a database.

Browser-based applications ________.

A(n) ________ is a program used to create, process, and administer a database.

Each table in a database must have two or more primary keys.

Normalization is the process of combining two or more tables into a single table.

Normalized tables are faster to process than tables that haven't been normalized.

A database application is a collection of forms, reports, queries, and application programs that serves as an intermediary between users and database data.

A many-to-many (N:M) relationship means that more than one entity is allowed on each side of the relationship and that the number of entities on each side can be different.

Reports refer to the structured presentation of data using sorting, grouping, filtering, and other operations.

A database management system (DBMS) is a program used to create, process, and administer a database.

Constraints on the minimum number of entities in a relationship are called ________ cardinalities.

Which of the following is an example of a database management system?

MySQL is an open source DBMS product that is license-free for most database applications.

Identify an open source DBMS product.

A key is a column or group of columns that identifies a unique row in a table.

Browser applications are thin-client applications that ________.

A student management system allows students to have multiple majors, and advisers are assigned to handle multiple students and courses. This is an example of a(n) ________ relationship.

Browser applications are thin-client applications that need to be pre-installed on the users' computers.

The Importance of MIS

Collaboration Information Systems

Strategy and Information Systems

Hardware, Software, and Mobile Systems

The Cloud

Processes, Organizations, and Information Systems

Social Media Information Systems

Business Intelligence Systems

Information Systems Security

Information Systems Management

Information Systems Development

Filters