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 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 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.

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.

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

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 _____.