View the step-by-step solution to:

QUESTION 1 1. The conceptual model is the basis for the description of the main data objects, avoiding details. True/False QUESTION 2 1.

QUESTION 1

1.        The conceptual model is the basis for the description of the main data objects, avoiding details.

 True/False

QUESTION 2

1.        ____________ is a technique that might be employed to improve query performance.

 a.       Performance tuning

 b.       Denormalization

 c.       Indexing

 d.       All of the above

QUESTION 3

1.        When a table"s attributes depend on the 'key, the whole key, and nothing but the key,' the table exhibits ___________.

a.        partial dependency

 b.       denormalization

 c.       full-functional dependency

 d.       normalization

QUESTION 4

1.        If you need to determine the value of inventory held on hand, and you want to display the results in a column labeled TotValue, which of the following would you use?

 

a.        SELECT P_DESCRIPT, P_ONHAND, P_PRICE, (P_ONHAND + P_PRICE) COLUMN AS TOTVALUE FROM PRODUCT;

 b.       SELECT P_DESCRIPT, P_ONHAND, P_PRICE, (P_ONHAND - P_PRICE) AS TOTVALUE FROM PRODUCT;

 c.       SELECT P_DESCRIPT, P_ONHAND, P_PRICE, (P_ONHAND * P_PRICE) AS TOTVALUE FROM PRODUCT;

 d.       SELECT P_DESCRIPT, P_ONHAND, P_PRICE, (P_ONHAND / P_PRICE) HEADING AS TOTVALUE FROM PRODUCT;

QUESTION 5

1.        All attributes for a specific entity can be grouped together as a(n)

 a.       object.

 b.       table.

 c.       element.

 d.       database.

6) The hierarchical database model depicts a set of _______________relationships.

 a.       one-to-one

 b.       many-to-one

 c.       one-to-many

 d.       many-to-many

QUESTION 7

1.        A database model is a collection of logical constructs used to represent the data structure and relationship. Database models are

 a.       implementation and relationship.

 b.       conceptual and Implementation.

 c.       conceptual and Relationship.

 d.       conceptual.

QUESTION 8

1.        Denormalization produces a lower normal form and is often recommended for small databases with few users.

 True/False

QUESTION 9

1.        Which of the following situation demonstrates data redundancy?

 a.       A customer"s address is stored in the Customer File and a sales agent"s address is stored in the Sales Agent File

 

b.        A customer"s address is stored in the Customer File and the Invoice File.

c.        A customer"s address is stored in the Customer File.

 d.       All of the above

QUESTION 10

1.        Which of the following is NOT true regarding aggregate functions?

 a.       All aggregate functions may be used on numeric data.

 b.       The Count(column) function will count all non-null values in the specified column.

 c.       All aggregate functions may be used on character data.

d.        The Count(*) function will count all rows whether null values exist or not.

QUESTION 11

1.        Because a partial dependency can exist only if a table"s primary key is composed of several attributes, a table whose primary key consists of only a single attribute must automatically be in 2NF if it is in 1NF.

 True/False

QUESTION 12

1.        Data fragmentation is a situation where a database is divided into subsets of data and stored at multiple locations.

 True

 False

QUESTION 13

1.        MPSD is a distributed database environment with ___________ processing and a __________ database.

 a.       centralized, distributed

 b.       centralized, centralized

 c.       distributed, centralized

d.        distributed, distributed

QUESTION 14

1.        A lock that defines how transactions acquire and relinquish locks is known as a(n)

 

a.        shared lock.

 b.       deadlocks.

 c.       exclusive lock.

 d.       binary lock.

 e.       two-phase lock.

1 points  

QUESTION 15

1.        Every transaction must start with the database in a consistent state and must return the database to a consistent state after it has completed.

 True/ False

QUESTION 16

1.        All transactions properties must display

 a.       atomicity, durability, serializability, and isolation.

 b.       durability and isolation.

 c.       atomicity, serializability, and durability.

 d.       serializability, durability, and isolation.

QUESTION 17

1.        The DDBMS transparency features are:

 a.       distribution and Transaction transparencies

 b.       failure and Performance transparencies

 c.       heterogeneity transparencies

 d.       b only

 e.       all of the above

1 points  

QUESTION 18

1.        Normalization reduces data redundancy in the database.

 True/ False

QUESTION 19

1.        A lock that specifically reserves access for the transaction that locked the object is known as a(n)

 a.       binary lock.

 b.       two-phase lock.

 c.       deadlocks.

 d.       shared lock.

 e.       exclusive lock.

QUESTION 20

1.        Because RDBMS hides the system"s complexity from the user/designer,

 a.       data management is very difficult.

 b.       data management is easier.

 c.       it does not exhibit structural independence.

d.        it does not exhibit data independence.

QUESTION 21

1.        The 'vertical' subset of data is the result of adding a WHERE clause to a SELECT statement.

 True/ False

QUESTION 22

1.        A table that is in 2NF and contains no transitive dependencies is said to be in

 a.       1NF.

 b.       BCNF.

 c.       2NF.

 d.       3NF.

 e.       4NF.

QUESTION 23

1.        In database design, a 1:1 relationship is uncommon and often indicates a design flaw.

 True

 False

1 points  

QUESTION 24

1.        A data warehouse stores historical data.

 True

 False

QUESTION 25

1.        Which of the following can be used to retrieve a 'horizontal' subset of data?

 

a.        Selecting all attributes

 

b.        Selecting specific attributes

 

c.        GROUP BY clause

 

d.        WHERE clause

QUESTION 26

1.        A superkey is any key that uniquely identifies each

 

a.        entity in a table.

 

b.        object in a table.

 

c.        table.

 d.       structure in a table.

Top Answer

Answer: True d a c c a b True b a... View the full answer

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online