Question 1

Typical key words used in a structured query language (SQL) search include all of the following except _____.&#10;A) FROM&#10;B) HOW&#10;C) WHERE&#10;D) SELECT

Accepted Answer

"FROM", "WHERE", and "SELECT" are common keywords used in SQL searches to specify the source of the data, the conditions for filtering, and the columns to retrieve, respectively. "HOW" is not a standard keyword in SQL and would not be recognized by the search engine.

Question 2

Which of the following statements about normalization is NOT true?&#10;A) One of the goals of normalization is to eliminate redundant data elements.&#10;B) Normalization is a methodology for organizing attributes into tables.&#10;C) Normalization can help maximize data integrity.&#10;D) All of these statements are true.

Accepted Answer

All the statements A, B, and C about normalization are true, making option D incorrect.

Question 3

Which of the following statements about query by example (QBE) is not true?&#10;A) QBE and SQL are the same languages and perform searches in the same manner.&#10;B) It is easier to find information in a database by using SQL than it is by using QBE.&#10;C) It is easier to find information in a database by using QBE than it is by using SQL.&#10;D) In QBE, the user fills out a form to construct a description of the data desired.

Accepted Answer

C

Question 4

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

Accepted Answer

The degree of a relationship in a database refers to the number of entity types that participate in that relationship.

Question 5

In an entity-relationship (ER) diagram, _____ are pictured in rectangles, and _____ are described on the line between two entities.&#10;A) entities; attributes&#10;B) entities; relationships&#10;C) attributes; entities&#10;D) attributes; relationships

Accepted Answer

In an ER diagram, entities are represented as rectangles, while relationships are represented as lines connecting the entities. Attributes are the characteristics or properties of an entity and are described within the entity rectangle. Therefore, the correct answer is B (entities; relationships).

Question 6

Entity-relationship (ER) diagrams consist of _____.&#10;A) entities, business rules, and relationships&#10;B) attributes, business rules, and relationships&#10;C) entities, attributes, and relationships&#10;D) entities, attributes, and data dictionaries

Accepted Answer

ER diagrams consist of entities, attributes, and relationships. Entities are the objects or concepts within a system, while attributes describe the properties or characteristics of those entities. Relationships define the associations or interactions between entities. ER diagrams do not typically include business rules or data dictionaries, although these may be used alongside the diagram. Therefore, the best choice is C.

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