Question 1

Explain the different types of DBMS products.

Accepted Answer

DBMS products fall into two broad catego

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

A primary key used in a database is a ________.

Accepted Answer

A)  group of rows that are formed to identify a unique table or file 
B)  column or group of columns that identifies a unique row in a table 
C)  character or byte that represents fields or columns 
D)  group of tables or files formed to identify a unique field or row 
A)  group of rows that are formed to identify a unique table or file 
B)  column or group of columns that identifies a unique row in a table 
C)  character or byte that represents fields or columns 
D)  group of tables or files formed to identify a unique field or row

Question 4

Metadata are ________.

Accepted Answer

A)  data stored on the main server 
B)  error logs of databases 
C)  data that describe data 
D)  encrypted data transmissions 
A)  data stored on the main server 
B)  error logs of databases 
C)  data that describe data 
D)  encrypted data transmissions

Question 5

Minimum cardinalities in an E-R diagram refer to the minimum number of entities required in a(n)________.

Accepted Answer

A)  department 
B)  database 
C)  attribute 
D)  relationship 
A)  department 
B)  database 
C)  attribute 
D)  relationship

Question 6

Describe a DBMS and its functions.List some of the popular DBMS softwares.

Accepted Answer

A database management system (DBMS)is a

Question 7

In data models, physical objects are represented as entities, whereas logical constructs and transactions are represented as attributes.

Accepted Answer

A) True 
 B)False

Question 8

The columns in a database are called ________.

Accepted Answer

A)  records 
B)  tables 
C)  files 
D)  fields 
A)  records 
B)  tables 
C)  files 
D)  fields

Question 9

Which of the following is a developmental task of database administration?

Accepted Answer

A)  creating and staffing the DBA function 
B)  monitoring backup procedures 
C)  conducting training for users 
D)  managing configuration changes in systems 
A)  creating and staffing the DBA function 
B)  monitoring backup procedures 
C)  conducting training for users 
D)  managing configuration changes in systems

Question 10

The data integrity problem occurs if data are duplicated.

Accepted Answer

A) True 
 B)False

Question 11

Brad, a project manager, wants to build a database to integrate information about employees and tasks that they handle.Brad wants to track information such as task name, percentage completed, and employee name.These aspects that Brad wants to track are called ________.

Accepted Answer

A)  identifiers 
B)  records 
C)  primary keys 
D)  entities 
A)  identifiers 
B)  records 
C)  primary keys 
D)  entities

Question 12

Constraints on the 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 13

A database design team transforms entities into tables and expresses relationships by defining ________.

Accepted Answer

A)  cardinalities 
B)  attributes 
C)  foreign keys 
D)  departments 
A)  cardinalities 
B)  attributes 
C)  foreign keys 
D)  departments

Question 14

A data integrity problem will occur only if ________.

Accepted Answer

A)  there are multiple administrators 
B)  data are duplicated 
C)  the database is very large 
D)  there are complex relationships 
A)  there are multiple administrators 
B)  data are duplicated 
C)  the database is very large 
D)  there are complex relationships

Question 15

Which of the following is an international standard language for processing a database?

Accepted Answer

A)  Paradox 
B)  DB2 
C)  SQL 
D)  MS Access 
A)  Paradox 
B)  DB2 
C)  SQL 
D)  MS Access

Question 16

DBMS is used to set up security systems involving user accounts, passwords, permissions, and limits for processing the database.

Accepted Answer

A) True 
 B)False

Question 17

A crow's foot notation would indicate the minimum cardinality of a relationship.

Accepted Answer

A) True 
 B)False

Question 18

A database application is a collection of forms, reports, queries, and application programs that process a database.

Accepted Answer

A) True 
 B)False

Question 19

Most organizations develop their own DBMS software in order to obtain control over data.

Accepted Answer

A) True 
 B)False

Question 20

Facebook developed a nonrelational data store called Bigtable.

Accepted Answer

A) True 
 B)False

Explain the different types of DBMS products.

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

A primary key used in a database is a ________.

Metadata are ________.

Minimum cardinalities in an E-R diagram refer to the minimum number of entities required in a(n)________.

Describe a DBMS and its functions.List some of the popular DBMS softwares.

In data models, physical objects are represented as entities, whereas logical constructs and transactions are represented as attributes.

The columns in a database are called ________.

Which of the following is a developmental task of database administration?

The data integrity problem occurs if data are duplicated.

Brad, a project manager, wants to build a database to integrate information about employees and tasks that they handle.Brad wants to track information such as task name, percentage completed, and employee name.These aspects that Brad wants to track are called ________.

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

A database design team transforms entities into tables and expresses relationships by defining ________.

A data integrity problem will occur only if ________.

Which of the following is an international standard language for processing a database?

DBMS is used to set up security systems involving user accounts, passwords, permissions, and limits for processing the database.

A crow's foot notation would indicate the minimum cardinality of a relationship.

A database application is a collection of forms, reports, queries, and application programs that process a database.

Most organizations develop their own DBMS software in order to obtain control over data.

Facebook developed a nonrelational data store called Bigtable.

The Importance of MIS

Collaboration Information Systems

Strategy and Information Systems

Hardware and Software

Data Communication and the Cloud

Structured Processes and Information Systems

Social Media Information Systems

Business Intelligence Systems

Business Process and Information Systems Development

Information Systems Management

Information Security Management

The International Dimension

Filters

Exam 5: Database Processing

Explain the different types of DBMS products.

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

A primary key used in a database is a ________.

Metadata are ________.

Minimum cardinalities in an E-R diagram refer to the minimum number of entities required in a(n)________.

Describe a DBMS and its functions.List some of the popular DBMS softwares.

In data models, physical objects are represented as entities, whereas logical constructs and transactions are represented as attributes.

The columns in a database are called ________.

Which of the following is a developmental task of database administration?

The data integrity problem occurs if data are duplicated.

Brad, a project manager, wants to build a database to integrate information about employees and tasks that they handle.Brad wants to track information such as task name, percentage completed, and employee name.These aspects that Brad wants to track are called ________.

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

A database design team transforms entities into tables and expresses relationships by defining ________.

A data integrity problem will occur only if ________.

Which of the following is an international standard language for processing a database?

DBMS is used to set up security systems involving user accounts, passwords, permissions, and limits for processing the database.

A crow's foot notation would indicate the minimum cardinality of a relationship.

A database application is a collection of forms, reports, queries, and application programs that process a database.

Most organizations develop their own DBMS software in order to obtain control over data.

Facebook developed a nonrelational data store called Bigtable.

The Importance of MIS

Collaboration Information Systems

Strategy and Information Systems

Hardware and Software

Data Communication and the Cloud

Structured Processes and Information Systems

Social Media Information Systems

Business Intelligence Systems

Business Process and Information Systems Development

Information Systems Management

Information Security Management

The International Dimension

Filters