Question 1

Which of the following is a license-free, open-source database management system?

Accepted Answer

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

Question 2

In a data model, entities always represent physical objects.

Accepted Answer

A) True 
 B)False  False

Question 3

The data integrity problem occurs only if data are duplicated.

Accepted Answer

A) True 
 B)False  True

Question 4

Attributes describe the characteristics of an entity.

Accepted Answer

A) True 
 B)False

Question 5

Joanna wants to find a particular report containing the sales analyses of the company for the second and third quarters of the year. After accessing the DBMS, she should type in the keyword into a ________ to locate what she is looking for.

Accepted Answer

A)  surrogate key 
B)  foreign key 
C)  query form 
D)  data model 
A)  surrogate key 
B)  foreign key 
C)  query form 
D)  data model

Question 6

Normalization is the only criterion for evaluating database designs.

Accepted Answer

A) True 
 B)False

Question 7

An identifier is an attribute (or group of attributes)whose value is associated with one and only one entity instance.

Accepted Answer

A) True 
 B)False

Question 8

A ________ is a collection of forms, reports, queries, and application programs that use the DBMS to process a database.

Accepted Answer

A)  foreign key 
B)  surrogate key 
C)  database application 
D)  data model 
A)  foreign key 
B)  surrogate key 
C)  database application 
D)  data model

Question 9

One of the development tasks of the database administrator is to develop a system to record and manage resolution of problems.

Accepted Answer

A) True 
 B)False

Question 10

A single database can have only one application and user.

Accepted Answer

A) True 
 B)False

Question 11

________ refers to the number of entities that can be involved in a relationship.

Accepted Answer

A)  Attribute 
B)  Normal form 
C)  Identifier 
D)  Cardinality 
A)  Attribute 
B)  Normal form 
C)  Identifier 
D)  Cardinality

Question 12

When there are same number of entities on each side of the relationship, an N:M relationship can be referred to as an N:N relationship.

Accepted Answer

A) True 
 B)False

Question 13

Bytes are grouped into columns, which are also called ________.

Accepted Answer

A)  rows 
B)  fields 
C)  files 
D)  bits 
A)  rows 
B)  fields 
C)  files 
D)  bits

Question 14

One of the functions of a DBMS is to provide tools to assist in the administration of the database.

Accepted Answer

A) True 
 B)False

Question 15

In which of the following cases would the user(s)use a personal rather than an enterprise DBMS?

Accepted Answer

A)  A startup company needs a database that can accommodate its 150 employees and be expanded to include more users. 
B)  A professor needs to maintain a database of his students' attendance and marks for the term. 
C)  Gensys needs a DBMS that is accessible across its locations around the world. 
D)  A university needs a database that can be accessed by students from all its departments. 
A)  A startup company needs a database that can accommodate its 150 employees and be expanded to include more users. 
B)  A professor needs to maintain a database of his students' attendance and marks for the term. 
C)  Gensys needs a DBMS that is accessible across its locations around the world. 
D)  A university needs a database that can be accessed by students from all its departments.

Question 16

All entity relationships are represented using crow's foot diagrams.

Accepted Answer

A) True 
 B)False

Question 17

Qtopia Inc. needs a database system which can support approximately 20 trillion bytes of data and 5000 users within the organization. Which of the following DBMS products would be appropriate?

Accepted Answer

A)  Paradox 
B)  FoxPro 
C)  Access 
D)  SQL Server 
A)  Paradox 
B)  FoxPro 
C)  Access 
D)  SQL Server

Question 18

In a relational database, every table must have a key.

Accepted Answer

A) True 
 B)False

Question 19

The database is a self-describing collection of integrated records.

Accepted Answer

A) True 
 B)False

Question 20

A group of similar rows or records is called a field.

Accepted Answer

A) True 
 B)False

Which of the following is a license-free, open-source database management system?

In a data model, entities always represent physical objects.

The data integrity problem occurs only if data are duplicated.

Attributes describe the characteristics of an entity.

Joanna wants to find a particular report containing the sales analyses of the company for the second and third quarters of the year. After accessing the DBMS, she should type in the keyword into a ________ to locate what she is looking for.

Normalization is the only criterion for evaluating database designs.

An identifier is an attribute (or group of attributes)whose value is associated with one and only one entity instance.

A ________ is a collection of forms, reports, queries, and application programs that use the DBMS to process a database.

One of the development tasks of the database administrator is to develop a system to record and manage resolution of problems.

A single database can have only one application and user.

________ refers to the number of entities that can be involved in a relationship.

When there are same number of entities on each side of the relationship, an N:M relationship can be referred to as an N:N relationship.

Bytes are grouped into columns, which are also called ________.

One of the functions of a DBMS is to provide tools to assist in the administration of the database.

In which of the following cases would the user(s)use a personal rather than an enterprise DBMS?

All entity relationships are represented using crow's foot diagrams.

Qtopia Inc. needs a database system which can support approximately 20 trillion bytes of data and 5000 users within the organization. Which of the following DBMS products would be appropriate?

In a relational database, every table must have a key.

The database is a self-describing collection of integrated records.

A group of similar rows or records is called a field.

Introduction to MIS

Business Processes, Information Systems, and Information

Hardware, Software, and Networks

Using IS to Improve Processes

Supporting Processes with ERP Systems

Supporting the Procurement Process with SAP

Supporting the Sales Process with SAP

Collaboration Processes and Information Systems

The Impact of Web 2.0 and Social Media on Business Processes

Business Intelligence

MIS Management Processes: Process Management, Systems Development, and Security

Filters

Exam 4: Database Processing

Which of the following is a license-free, open-source database management system?

In a data model, entities always represent physical objects.

The data integrity problem occurs only if data are duplicated.

Attributes describe the characteristics of an entity.

Joanna wants to find a particular report containing the sales analyses of the company for the second and third quarters of the year. After accessing the DBMS, she should type in the keyword into a ________ to locate what she is looking for.

Normalization is the only criterion for evaluating database designs.

An identifier is an attribute (or group of attributes)whose value is associated with one and only one entity instance.

A ________ is a collection of forms, reports, queries, and application programs that use the DBMS to process a database.

One of the development tasks of the database administrator is to develop a system to record and manage resolution of problems.

A single database can have only one application and user.

________ refers to the number of entities that can be involved in a relationship.

When there are same number of entities on each side of the relationship, an N:M relationship can be referred to as an N:N relationship.

Bytes are grouped into columns, which are also called ________.

One of the functions of a DBMS is to provide tools to assist in the administration of the database.

In which of the following cases would the user(s)use a personal rather than an enterprise DBMS?

All entity relationships are represented using crow's foot diagrams.

Qtopia Inc. needs a database system which can support approximately 20 trillion bytes of data and 5000 users within the organization. Which of the following DBMS products would be appropriate?

In a relational database, every table must have a key.

The database is a self-describing collection of integrated records.

A group of similar rows or records is called a field.

Introduction to MIS

Business Processes, Information Systems, and Information

Hardware, Software, and Networks

Using IS to Improve Processes

Supporting Processes with ERP Systems

Supporting the Procurement Process with SAP

Supporting the Sales Process with SAP

Collaboration Processes and Information Systems

The Impact of Web 2.0 and Social Media on Business Processes

Business Intelligence

MIS Management Processes: Process Management, Systems Development, and Security

Filters