Question 1

Typical key words used in a structured query language (SQL) search include all of the following except _____.

Accepted Answer

A)  FROM 
B)  HOW 
C)  WHERE 
D)  SELECT 
A)  FROM 
B)  HOW 
C)  WHERE 
D)  SELECT B

Question 2

In an entity-relationship (ER) diagram, _____ are pictured in rectangles, and _____ are described on the line between two entities.

Accepted Answer

A)  entities; attributes 
B)  entities; relationships 
C)  attributes; entities 
D)  attributes; relationships 
A)  entities; attributes 
B)  entities; relationships 
C)  attributes; entities 
D)  attributes; relationships B

Question 3

The degree of a relationship indicates the number of entities associated with a relationship.

Accepted Answer

A) True 
 B)False  True

Question 4

Which of the following statements about normalization is NOT true?

Accepted Answer

A)  One of the goals of normalization is to eliminate redundant data elements. 
B)  Normalization is a methodology for organizing attributes into tables. 
C)  Normalization can help maximize data integrity. 
D)  All of these statements are true. 
A)  One of the goals of normalization is to eliminate redundant data elements. 
B)  Normalization is a methodology for organizing attributes into tables. 
C)  Normalization can help maximize data integrity. 
D)  All of these statements are true.

Question 5

Which of the following statements about query by example (QBE) is not true?

Accepted Answer

A)  QBE and SQL are the same languages and perform searches in the same manner. 
B)  It is easier to find information in a database by using SQL than it is by using QBE. 
C)  It is easier to find information in a database by using QBE than it is by using SQL. 
D)  In QBE, the user fills out a form to construct a description of the data desired. 
A)  QBE and SQL are the same languages and perform searches in the same manner. 
B)  It is easier to find information in a database by using SQL than it is by using QBE. 
C)  It is easier to find information in a database by using QBE than it is by using SQL. 
D)  In QBE, the user fills out a form to construct a description of the data desired.

Question 6

Entity-relationship (ER) diagrams consist of _____.

Accepted Answer

A)  entities, business rules, and relationships 
B)  attributes, business rules, and relationships 
C)  entities, attributes, and relationships 
D)  entities, attributes, and data dictionaries 
A)  entities, business rules, and relationships 
B)  attributes, business rules, and relationships 
C)  entities, attributes, and relationships 
D)  entities, attributes, and data dictionaries

Typical key words used in a structured query language (SQL) search include all of the following except _____.

In an entity-relationship (ER) diagram, _ are pictured in rectangles, and _ are described on the line between two entities.

The degree of a relationship indicates the number of entities associated with a relationship.

Which of the following statements about normalization is NOT true?

Which of the following statements about query by example (QBE) is not true?

Entity-relationship (ER) diagrams consist of _____.

Introduction to Information Systems

Organizational Strategy, Competitive Advantage, and Information Systems

Data and Knowledge Management

Telecommunications and Networking

Business Analytics

Ethics and Privacy

Information Security

Social Computing

E-Business and E-Commerce

Wireless, Mobile Computing, and Mobile Commerce

Information Systems Within the Organization

Customer Relationship Management

Supply Chain Management

Acquiring Information Systems and Applications

Plug It in 1 Business Processes and Business Process Management

Plug It in 2 Hardware and Soft Ware

Plug IT In 4 Cloud Computing

Plug IT In 5 Artificial Intelligence

Plug IT In 6 Project Management

Filters

Exam 17: Plug IT In 3 Fundamentals of Relational Database Operations

Typical key words used in a structured query language (SQL) search include all of the following except _____.

In an entity-relationship (ER) diagram, _____ are pictured in rectangles, and _____ are described on the line between two entities.

The degree of a relationship indicates the number of entities associated with a relationship.

Which of the following statements about normalization is NOT true?

Which of the following statements about query by example (QBE) is not true?

Entity-relationship (ER) diagrams consist of _____.

Introduction to Information Systems

Organizational Strategy, Competitive Advantage, and Information Systems

Data and Knowledge Management

Telecommunications and Networking

Business Analytics

Ethics and Privacy

Information Security

Social Computing

E-Business and E-Commerce

Wireless, Mobile Computing, and Mobile Commerce

Information Systems Within the Organization

Customer Relationship Management

Supply Chain Management

Acquiring Information Systems and Applications

Plug It in 1 Business Processes and Business Process Management

Plug It in 2 Hardware and Soft Ware

Plug IT In 4 Cloud Computing

Plug IT In 5 Artificial Intelligence

Plug IT In 6 Project Management

Filters

In an entity-relationship (ER) diagram, _ are pictured in rectangles, and _ are described on the line between two entities.